Filter queries allow a group of employees to be assigned to template documents (e.g., welcome emails and contract templates), workflows (e.g., info requests, onboarding, offboarding), or info requests This article will discuss how filter queries work and how to use filter queries in an onboarding or offboarding process.
Follow me.
How do filter queries work?
A filter query is set up in two parts:
- The Query name - what this filter query is called. The name should describe the group of employees selected with the filter.
- The Selection criteria - the conditions the system will use to identify the group of employees to be selected by the filter.
How to create a filter query for an Onboarding or Offboarding process?
For an onboarding or offboarding process, filter queries are assigned upon setting up the workflows.
- Navigate to Settings > Rules > Process Templates.
- Select the Process Group: "Onboarding and Offboarding" and then select any Onboarding or Offboarding Process.
- If you selected a Default template, untick the "Default template" option first.
- Select Edit Filter
- Tick Show query which shows the selection criteria you'll build in later steps.
- Create a new filter by clicking on New
- Tick Require permission to edit query
- Create the selection criteria by clicking on Add Condition
- Select the appropriate criteria for your filter (e.g. 'Job equals Manager')
- Click on Update and then Apply
- Back on the Process Template screen, from the "Filter Query" drop down list, select the filter you've just created
- Click on Save
Selection Criteria set up tips
- When setting up the selection criteria, you'll be required to input 3 fields
- Select from the condition list
- Select the logic - "is equal to" or "is not equal to"
- Select the appropriate value in the third list
Some of the values for the condition list can be set under Settings > Setup > List Management (e.g. ContractGroup, Department, Division, and Location).
- If you're setting up multiple conditions, ensure that you choose from the drop down list with the AND and OR options:
- AND - choose AND if you'll be adding multiple conditions and you want to select employees who satisfy ALL conditions.
Example: when you select AND and then add the following conditions, this means that the Filter Query will select employees who are Full Time and are also part of the Operations Department. If someone is a Full Time employee but belongs to the Human Resources department, then they will not be selected by this filter. - OR - choose OR if you'll be adding multiple conditions and you want to select employees who satisfy ANY ONE of the conditions you've added
Example: When you select OR and then add the following conditions, this means that the Filter Query will select employees who are full time OR employees who are part time.
But if you selected AND in this instance, then no one will be selected by the filter because a Flare user can't be assigned to both Full Time and Part Time employment types.
- AND - choose AND if you'll be adding multiple conditions and you want to select employees who satisfy ALL conditions.
- Add Group option - you may also use the option to add condition Groups for more complicated conditions.
Example: Instead of just selecting Full Time employees who are also part of the Operations Department, maybe you'd also want to add Full Time employees who belong to the Administration Department.
Note: Keep Filter Query set ups as simple as possible so it's easily understood. However, if more complicated set ups are required, ensure that you click on the Result option to preview the set of users being selected by the system so you can be sure that you've set up the correct filter.