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

Future Hires

Received Response
40
Views
1
Comments
edited Dec 12, 2022 8:42AM in Taleo Learn 1 comment

Summary

query syntax

Content

hi all.

what would be the syntax for making a query of all futures hires?
I'm using the following syntax, but since future hires are filtered automatically (because their record start date is in the future, so they don't exist at query time) I see no results.

what am I missing?

Thanks in advance.
Ben.

ps. - ok i  managed to find related posts regarding the issue. setting the prefix SET VARIABLE PARAM_EFFECTIVE_DATE='2050-12-31'; will do the job but it will apply it for all the fields in the query. is there a way to apply it  for  a specific field? (all other fields on the same report should be taken on  current  date)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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