Overview
Create queries to filter submissions and data tables in Mirata using various parameters and logical operators.
Accessing the Query Editor
The query editor is available to you for various tasks in the Admin Tool. You access the query editor when creating or editing:
Certain
Integration Actions:Action Request Type =
Data Table RequestRequest Type =
QueryRequest Type =
Query DeleteRequest Type =
Query To CSV
Action Request Type =
Submission RequestRequest Type =
QueryRequest Type =
Query DeleteRequest Type =
Query To CSV
Submission QueriesThe
Submission Managementtab of theAdmin Tool
Building a Query
Start by creating or opening an integration action, a submission query, or navigating to the submission management tab.
Adding Parameters
Click the + button to add your first parameter. Select a field from the dropdown.
A new row will be added to your query for that parameter.
Next, choose an operator (like "equals") from the second dropdown. Enter a value or constant in the third field to complete the parameter.
Click the + button to add more parameters.
Select AND, OR, AND NOT, or OR NOT to define the logic between parameters.
Adding Groups
Grouping parameters allows you to create nested conditions. For example, you could have one group of parameters combined with "OR" and another group combined with "AND."
Add a new parameter group using the Group button to the right of the + button. This adds the placeholder to add a new set of parameters within the query.
Within the new group, click the + button to add parameters within that group.
Using Queries
Some examples of places you can use queries are: