Conduct a SQL WHERE Clause Search

You can use a SQL WHERE Clause search to search for employees and plans in Resource Management.

To perform a SQL WHERE Clause search, complete the following steps:

1. From the Vision Navigation menu, click Planning >  Resource Management > Resource Utilization or Generic Assignments.
2. Click Search to display the Employee lookup for Resource Utilization or the Plan lookup for Generic Assignments.
3. From the Display Type drop-down list, select SQL WHERE Clause.
4. Create the SQL WHERE Clause.
5. Optional. Save the SQL WHERE Clause for use in future searches.