Filtering



CQL can be used in many modules to build out filters and searches that give you a specific view of your organization's information.

Figure 1: Using CQL in data sheets.

The CQL expression used above is department:"sales", which will return all people and jobs who match the sales department.

Figure 2: Using CQL in the org chart.

Similarly, the org chart CQL query above is simply using the same expression to narrow the org visualization down to the sales department.

Figure 3: Using CQL in custom field calculations.

CQL is also a helpful tool when creating custom fields with Smart Calculations and Smart Buckets. The image above shows a custom field that uses a calculated expression for determining the cost of recruiting an employee, in this case base multiplied by 0.2, or base * .2.

Sample usage

While there is no field in ChartHop for day, you can use the day function to query all of the date fields you have in ChartHop. In the example below, using the formula will return the number "12" since it is the value in the day spot.

day('20020-05-12')

For a more complex example, let's look at the endOfMonth function. Let's say you wanted to create a query that would add four weeks to a new hire's start date so that you can follow up on their first 30 days. You can create a custom field for "Target Survey Date" and use the function as follows.

date("+4w", personStartDate

Rather than pulling all the start dates and manually calculating, you can use this formula to improve processes drastically.