2. PHPRunner General questions
  3. [SOLVED] list sorting
This topic is locked
[SOLVED]

list sorting

 		6/10/2022 7:17:43 AM
PHPRunner General questions
G
 Grdimitris author

If in security Advanced i have Users can see other users data, can edit their own data only
Can i sort list page first his own data?
fhumanes 6/10/2022

Hello,

I think it can be simple if using this algorithm:

  • Create a pseudo column, which has value 1 when it is a user record and 0, when it is not.
  • Order the consultation for this (and other columns).
    With this you can order the records as you want.

Cheers,
fernando
G
 		Grdimitris author 6/10/2022

Thank you Fernando
I added this pseudo column if(grafeio=:session.synergeio, 1, 0) AS is_mine and i sorted the table with is_mine DESC and works perfect.
Thank you again.