Creating queries for System Filters

Written By Natalia Povrozniak (Administrator)

Updated at August 6th, 2024

Create system filters for teams to be able to conveniently work with a certain set of spaces or view specific information that is not easily accessible elsewhere.

To create a system filter, do the following:

  1. Define what information you'd like to be displayed. You can apply one or more conditions per one record type. As of now, filters work with booking records only.
  2. Use parameters that correspond to the record type selected and query expressions to build a filter query.

Parameters to use in your queries

Additional parameters to be added in the future.

Bookings

For bookings filtering, for now, use the following parameter for your query:

  • Space_Id

⚠️ The limit is 100 spaces per filter.

Supported query expressions

Expression Explanation
eq equal to
and and
or or

Examples

Organisational need Query text suggestion
Team A oversees 10 specific client meeting rooms, and you know Space IDs of those rooms. Space_Id eq '1CC_01-NW-R005' or Space_Id eq '1CC_01-NW-R006' or Space_Id eq '1CC_01-NW-R007' or Space_Id eq '1CC_01-NW-R008'

⚠️ Remember to test your query in OneLens 360. If the query has a typo, it will show the Unexpected Response error.

In the following example, we created a filter for three spaces and have a missing space in the query.

This leads to only one space being displayed that is not affected by the typo.