- Implementing Recruiting
- Creating a List of Values of Type SQL Query
Creating a List of Values of Type SQL Query
Before you start
The Access Embedded Reporting Management user type permission is required.
Configuration > Recruiting Administration > Embedded Reporting AdministrationHere's what to do
- Click Data Model Definitions.
- Click on the desired data model definition.
- Click Create next to List of Values.
- Provide a name.
- Select SQL Query.
- Click Save.
- Click Edit next to Query.
- Select a subject area.
- Selects the query type (logical or physical).
- Write the query.
- In the Search Alias field, define the alias that will be
used as a search criterion.
The Search tool is available to users in the Recruiting Center if the Search Alias field has been defined in the List of Values of a data model definition. The search should be enabled when there is a possibility that there will be more than 999 possible values. The Search Alias is only available for a list of values using an SQL query.
- Validate the accuracy of the query.
When you click the Validate query button, the system validates the accuracy of the query. If the query is accurate, the system will, as a second step, verify if the search alias is valid and if it can be used to search values.
- Click Save.
- Click Save.