<div class="gmail_extra">Hi Alan,</div><div class="gmail_extra"><br></div><div class="gmail_extra">Providing sorting option on any random field of module would pull down the performance. </div><div class="gmail_extra"><br>
</div><div class="gmail_extra">It is advised to sort on fields having table-index defined. Although we can add index on the field selected for sorting it could lead to "too many indexes" on table and in-turn affect the performance.</div>
<div class="gmail_extra"><br></div><div class="gmail_extra">We plan to optimize the data-fetch queries for custom filters and review the option to provide sort options to the field.</div><div class="gmail_extra"><br></div>
<div class="gmail_extra">Please share your updates in case you make any progress.</div><div class="gmail_extra"><br></div><div class="gmail_extra">Regards,</div><div class="gmail_extra">Prasad</div><div class="gmail_extra">
<br><div class="gmail_quote">On Wed, Apr 25, 2012 at 12:34 AM, Alan Lord (News) <span dir="ltr"><<a href="mailto:alanslists@gmail.com" target="_blank">alanslists@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="HOEnZb"><div class="h5">On 24/04/12 19:47, Michael Spicer wrote:<br>
> Hi Everyone,<br>
><br>
> I have been investigating how to create default sorting that is on a per<br>
> user basis. I have also been looking at how to implement this behavior<br>
> for listviews that are using filters. What I have found so far is that I<br>
> can hard code a default sorting into the module but that doesn't have<br>
> any affect on a per user basis. I have search and searched the forums,<br>
> wiki's and docs to find more details on sorting. It is not very user<br>
> friendly to have to click what sort they want everytime the listview is<br>
> loaded. Does anyone have any thoughts or are there any plugins to create<br>
> advanced sort functionality?<br>
<br>
<br>
</div></div>Hi Mike,<br>
<br>
adding a default sort choice for custom list view filters was something<br>
I raised on here ages ago (see thread "Please add "sort" configuration<br>
to Custom Filters" from June 2010) and seems to be quite a popular idea.<br>
But I don't know if it is really hard to do or not.<br>
<br>
<br>
cheers<br>
<span class="HOEnZb"><font color="#888888"><br>
Al<br>
<br>
<br>
--<br>
Libertus Solutions<br>
<a href="http://www.libertus.co.uk" target="_blank">http://www.libertus.co.uk</a><br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</font></span></blockquote></div><br></div>