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 Administration

Here's what to do

1. Click Data Model Definitions.
2. Click on the desired data model definition.
3. Click Create next to List of Values.
4. Provide a name.
5. Select SQL Query.
6. Click Save.
7. Click Edit next to Query.
8. Select a subject area.
9. Selects the query type (logical or physical).
10. Write the query.
11. 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.
12. 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.
13. Click Save.
14. Click Save.