|
Columns settings sort function not working 10 Years, 4 Months ago
|
Karma: 0
|
|
I am trying to sort by two columns, for some reason the sort does not show in the article. Please see the SQL query and the Columns settings below:
SELECT `SCHEDULE DATE`, `AM/PM`, `MILL`, `work order #`, `TRACTOR`, `TRAILER`, `SERV VEH`, `TANK TRUCK`, `CREW CHIEF`, `CREW1`, `CREW2`, `CREW3`, `CREW4`, `WRKORDCELL#`, `TRANSPORT`, `MOB DAY` FROM `tse_schedule`
# Column index Sorting type Sorting order
1. SCHEDULE DATE Date Ascending
2. AM/PM String Ascending
The data shows correctly but I don't have the sorting correct.
|
|
|
|
|
|
|
Re:Columns settings sort function not working 10 Years, 4 Months ago
|
Karma: 748
|
Hello,
Use settings like on the screenshot below:
Regards,
ARI Soft |
|
|
|
|
|
|
Re:Columns settings sort function not working 10 Years, 4 Months ago
|
Karma: 0
|
Still isn't sorting correctly, but did make a change. I would like to sort by date then am or pm.  |
|
|
|
|
|
|
Re:Columns settings sort function not working 10 Years, 4 Months ago
|
Karma: 748
|
|
Could you provide a link to a page where we can see the problem?
PS: You can specify default order directly in the query. It will look like:
SELECT `SCHEDULE DATE`, `AM/PM`, `MILL`, `work order #`, `TRACTOR`, `TRAILER`, `SERV VEH`, `TANK TRUCK`, `CREW CHIEF`, `CREW1`, `CREW2`, `CREW3`, `CREW4`, `WRKORDCELL#`, `TRANSPORT`, `MOB DAY` FROM `tse_schedule`
ORDER BY `SCHEDULE DATE`,`AM/PM`
Regards,
ARI Soft
|
|
|
|
|
|
|
Re:Columns settings sort function not working 10 Years, 4 Months ago
|
Karma: 0
|
|
Ok, I think I found what it was.... I had the Save state turned on which was saving the sort when the page was viewed...... Wonderful Product though, thanks so much for your help.
|
|
|
|
|
|
|
