What are record filters?

Have more questions? Submit a request

What are record filters?

Record Filters are used to identify and select records based on shared characteristics, such as specific selection criteria, Payroll, or Post. These filters can be applied to the Navigator to modify the displayed record count. 

To open the Record Filters Window

Menu bar > Definitions > Filters > Record Filters window

The Record Filter Window 

The Records Filter window allows you to perform the following:
  • Create and maintain categories for grouping filter definitions.
  • Create record filter definitions.
  • Test record filters.

Name Description
Data File

This displays the sub folder you wish to filter. 

The location of where you are  in Cintra iQ determines  which sub folder appears in the Data File drop-down list. i.e. When the Employment Records sub folder is selected in the Folders pane, the Employee data file appears in the Record Filters window.
If you wish to change sub folders, close the Record Filters window, select another sub folder in the Folders pane and then click Filters to reopen the Record Filters window. The new selection appears in the Data File drop-down list.
Search the record filter titles within the Definitions pane by keyword.
Definitions pane
View the various record filter definitions that are grouped into categories. A newly created category is hidden from view until a record filter is attached to it.
If you do not save your new filter to a specific category, it is automatically saved to the Uncategorised category. 


If you do not save your new filter to a specific category, it is automatically saved to the Uncategorised category.


Use the following buttons to perform various tasks. 
Name Description
Click this button to unlock the selected filter for editing by a single user.


This is only available for use by the System Administrator.

Click this button to count the number of records the system selects when you apply the record filter. For more information, see Counting Records in the side menu.
Expand All
Click this button to display the record filter definitions in all  categories listed in the Definitions pane.
Category Maint
Click this button to create, edit or delete categories.
Click this button to create a record filter definition.
Click this button to open and amend a record filter definition.
Click this button to  create a similar filter definition.
Click this button to change the name of the filter definition.
Click this button to delete the filter.
Click  this button to allow all users access to the filter.
Click this button to restrict access to the filter definition, from all or various users.
Click this button to protect the filter definition from changes made by anyone but its creator. 
Highlight a filter definition and click this button to remove its protection and allow anyone to amend  it.
Click this button to save the record filter definitions and close the window.

  Knowledge Bite:

You may want to create a filter that finds all Employees who are New Starters in the current Payroll pay period.

You may want to create a filter to find which Employee records have missing NI numbers. By grouping the records by filter, you can see immediately the record that needs updating.

Or, you may want to create a filter to group together departments so you can update absence information and report on sickness for that month.

A filter is saved under the sub folder where it was created i.e. if you create a filter while in Employment Records, you are only  able to view, amend or use the filter while in Employment Records.

  Knowledge Bite:

Check whether a filter has already been applied to the Navigator by viewing the display at the bottom right-hand corner of the Cintra iQ window.


Filters can also be used with the following functionality:

Name Description

Email Notifications

Filters can be used  when sending email notifications and creating emails.


Filters can be used when managing letters. It can be applied to the records in the Navigator for those Employees for whom the letter is intended. For more information, see the Letters module. 


Filters can  be used when running reports. If you run a Listing report and have a filter applied to the Navigator, only records shown in the Navigator are selected in the report. You can also embed filters into reports so no matter when you run the report or what filters you have applied to the Navigator, you will always be selecting the required records. This is done via: Lower right-hand corner> Reports or Definitions> Reporting> Reports> Reports window> Report Type: Listing Report> Creating Listing Reports Definition window> Record Filters tab. For more information, see the Reports module.

Articles in this section

Was this article helpful?
0 out of 0 found this helpful