Query to get admin and grand father

mpol_ch · Post by **mpol_ch** » Thu Dec 18, 2014 5:01 pm

Hello
I am using the following query to get the son and father records. But I would like also to have all records for admin (-1) and the records of grand father. Is there to improve the query to get the results?

Select * FROM events WHERE (User = $my_current_user_id) OR (User IN (SELECT Id FROM mitarbeiter WHERE Reportsto = $my_current_user_id))"

thanks
mpol_ch

mobhar · Post by **mobhar** » Thu Dec 18, 2014 5:12 pm

You may use "UserID_Loading" and/or "UserID_Loaded" server event to add or change the User ID to the current logged in user, so he/she will be able access the records that belong to the other users.

Read "Server Events and Client Scripts" in the PHPMaker help file for more information and example.

scs · Post by **scs** » Thu Dec 18, 2014 7:07 pm

Maybe you can try on RecordSet_Selecting(&$filter).

No filter for administrator (-1), otherwise set the filter base on your requirements.

mpol_ch · Post by **mpol_ch** » Thu Dec 18, 2014 9:32 pm

Thanks for the information. I am using this in "Custom File". Will it work also in custom file?

thanks
mpol_ch

mobhar · Post by **mobhar** » Fri Dec 19, 2014 9:19 am

"UserID_Loading" and "UserID_Loaded" server events are implemented in Custom Files, but not with "RecordSet_Selecting" server event.