Get Started with Redwood for Oracle Cloud HCM Begin Now
Default Filter/Prompt to Logged In Recruiter
Content
Use the following SQL to create a prompt or a filter to default to logged in user
SELECT "Requisition Recruiter"."Recruiter Name" FROM "Recruiting" where "Requisition Recruiter"."Recruiter ID"=SUBSTRING( (VALUEOF(NQ_SESSION.USER)) FROM( (LOCATE('.',(VALUEOF(NQ_SESSION.USER))))+1))
Tagged:
4