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:
- From the Vision Navigation menu, click Generic Assignments. or
- Click Search to display the Employee lookup for Resource Utilization or the Plan lookup for Generic Assignments.
- From the Display Type drop-down list, select SQL WHERE Clause.
- Create the SQL WHERE Clause.
- Optional. Save the SQL WHERE Clause for use in future searches.