Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Bug Reports » sql_orderby_seq (When set to desc in script, has no effect)
sql_orderby_seq [message #4056] Wed, 22 January 2014 14:09 Go to next message
David Lee is currently offline  David Lee
Messages: 44
Registered: June 2006
For a list1 screen, and possibly others, setting $sql_orderby_seq='desc' has no effect - the order is still asc. A workaround is adding desc to the end of the $sql_orderby, as in $sql_orderby='location desc' to sort by the location field in descending order.

It may be best to remove $sql_orderby_seq completely, and let the sequence be defined in $sql_orderby, as that appears to be the way the existing code works.
Re: sql_orderby_seq [message #4057 is a reply to message #4056] Wed, 22 January 2014 14:42 Go to previous message
AJM is currently offline  AJM
Messages: 2350
Registered: April 2006
Location: Surrey, UK
Senior Member
If you want to set the sort sequence for a particular LIST1 transaction then the correct way to do it is to set the 'Order By' field in the 'Update Task' screen. I have tested it, and it works perfectly.

$sql_orderby_seq is there to allow toggling between 'asc' and 'desc' on whatever field is specified in $sql_orderby.

Previous Topic: v1.81.0 dict-schema.sql, dict-data.sql
Next Topic: PDF does not print cells with only 'zero' (string or integer)
Goto Forum:

Current Time: Mon Jun 24 10:06:07 EDT 2024

Total time taken to generate the page: 0.03474 seconds