Work with the query modeler
The query modeler simplifies the process of filtering the database based on various criteria. Additionally, the query modeler can manage very complex and long queries efficiently, offering enhanced flexibility and precision. Furthermore, it supports predefined filters within conditions, empowering you to refine your queries with ease while utilizing advanced expressions and operators for comprehensive audience targeting and segmentation strategies.
Access the query modeler
The query modeler is available in every context where you need to define rules to filter data.
| Usage | Example |
|---|---|
| Define audiences: Specify the population you want to target in your compositions, and effortlessly create new audiences tailored to your needs. |
|
| Customize activities: apply rules within composition activities, such as Split and Reconciliation, to align with your specific requirements. Learn more on composition activities |
|
Query modeler interface
The query modeler provides a central canvas where you build your query, and a right pane providing information on your query.
The central canvas
The query modeler central canvas is where you add and combine the different components building your query. Learn how to build a query
The toolbar located in the upper-right corner of the canvas provides options to easily manipulate the query components and navigate in the canvas:
- Multiple selection mode: Select multiple filtering components to copy and paste them at the location of your choice.
- Rotate: Switch the canvas vertically.
- Fit to screen: Adapt the canvas zoom level to your screen.
- Zoom out / Zoom in: Zoom out or in the canvas.
- Display map: Opens a snapshot of the canvas showing you are located.
The Rule properties pane
On the right hand side, the Rule properties pane provides information on your query. It allows you to perform various operations to check the query and ensure it suits your needs. This pane displays when building a query to create an audience. Learn how to check and validate your query
