Hi Alan,<div><br></div><div>Click the column again and it will be sorted the way you wish (it's a toggle). Or you can change the code permanently by changing ./modules/potentals/potentials.php</div><div><br></div><div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>//Added these variables which are used as default order by and sortorder in ListView</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>var $default_order_by = 'potentialname';</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>var $default_sort_order = 'ASC';</div></div><div><br></div><div>ASC or DESC are your two options.</div><div><br clear="all">-- Stephen Mack<br>Gerente de Ventas y Marketing<br>
Escuela Fronteras | <a href="http://www.eFronteras.com">www.eFronteras.com</a><br>skype: eFronteras.Stephen<br>Member of NAFSA & AmCham<br>Visit my blog at: <a href="http://efronteras.com/ElPituto">http://efronteras.com/ElPituto</a><br>
Hear our students thoughts: <a href="http://efronteras.com/audioblog">http://efronteras.com/audioblog</a><br>
<br><br><div class="gmail_quote">On Mon, Jul 5, 2010 at 8:17 AM, Alan Lord (News) <span dir="ltr"><<a href="mailto:alanslists@gmail.com">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;">
I only just noticed this and it's a tad annoying.<br>
<br>
I was sorting our Potentials by clicking the Id. column header in the List View.<br>
<br>
They are not being sorted properly... The image shows how Potentials are being sorted in Descending order.<br>
<br>
I think this is wrong and should be fixed. From what I could see there is no inbuilt "natural sort" in MySQL but there is in PHP: <a href="http://php.net/manual/en/function.natsort.php" target="_blank">http://php.net/manual/en/function.natsort.php</a><br>
<br>
I have also added a link to this on a TRAC ticket reporting the same problem.<br>
<br>
Cheers<br>
<br>
Al<br><font color="#888888">
<br>
<br>
-- <br>
The Open Learning Centre<br>
<a href="http://www.theopenlearningcentre.com" target="_blank">http://www.theopenlearningcentre.com</a><br>
</font><br>_______________________________________________<br>
Join vtiger community at <a href="http://forums.vtiger.com" target="_blank">http://forums.vtiger.com</a><br></blockquote></div><br></div>