Find out user sorting order
Hi All,
We have a pagelist which is defined in a Grid and has sorting enabled. In the user portal, we the user views the list, he can sort it by any property in any order.
After he has sorted he can update the record and save it. To save the record we are calling an activity. In this activity, after the save step, I am loading the list again, but I was to retain the sort that the user made.
Is there anyway I can find out by which property the list has been sorted and in what order(ASC or DEC)?
Thanks
Sujithram
Myknowtech B.V
NL
Hi Sujithram,
You can find the property by using pxsqlstatementpre/post property in that respective page.
you can fid the property and order sorted by using what comes next ORDER BY.
IQZ Systems LLC
US
Hi Premkumar,
Thanks for your input.
I did try looking into pxsqlstatementpre/post, but sql queries remain unchanged before and after sorting.
I don't see the sorted property anywhere in the clipboard, that's the problem.
Regards,
Sujithram
Myknowtech B.V
NL
Hi Sujithram,
You are welcome!. According to my knowledge if sorting happens successfully the SQL Query must contain ORDER BY field.
If you check clipboard after this step
In this activity, after the save step, I am loading the list again, but I was to retain the sort that the user made.
U wont get ORDER BY values.
but as soon as u click header column to sort, you must get ORDER BY value.
I am sorry if this cant help you
Thanks,
Hi Sujithram,
You are welcome!. According to my knowledge if sorting happens successfully the SQL Query must contain ORDER BY field.
If you check clipboard after this step
In this activity, after the save step, I am loading the list again, but I was to retain the sort that the user made.
U wont get ORDER BY values.
but as soon as u click header column to sort, you must get ORDER BY value.
I am sorry if this cant help you
Thanks,
Prem