Is there a way to write a Saved/Advanced Query's condition dynamically against 'whoever is currently running it' (their User ID or Person ID), rather than hardcoding one specific username, so the same shared query works correctly for every user it's shared with?

Q: Is there a way to write a Saved/Advanced Query's condition dynamically against 'whoever is currently running it' (their User ID or Person ID), rather than hardcoding one specific username, so the same shared query works correctly for every user it's shared with?

Yes — for the current session's User ID (identity), use &APPOWNER.FND_Session_API.Get_Fnd_User; for the corresponding Person ID, use &APPOWNER.PERSON_INFO_API.Get_Id_For_User(&APPOWNER.FND_Session_API.Get_Fnd_User). Both can be used directly inside a Saved/Advanced Query's condition (in place of a hardcoded literal value), so the same shared query dynamically scopes its results to whichever user actually runs it, rather than needing a separate copy of the query per user.

Answer

Yes — for the current session's User ID (identity), use &APPOWNER.FND_Session_API.Get_Fnd_User; for the corresponding Person ID, use &APPOWNER.PERSON_INFO_API.Get_Id_For_User(&APPOWNER.FND_Session_API.Get_Fnd_User). Both can be used directly inside a Saved/Advanced Query's condition (in place of a hardcoded literal value), so the same shared query dynamically scopes its results to whichever user actually runs it, rather than needing a separate copy of the query per user.

← Browse Platform, Aurena, and customization questions