Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Default Filter/Prompt to Logged In Recruiter — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Default Filter/Prompt to Logged In Recruiter

Received Response
106
Views
5
Comments
edited Oct 14, 2016 3:26PM in Reporting and Analytics Taleo Enterprise 5 comments

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))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!