Overview
The Query tab lets you write and run filters against any Live Table. Queries use the Trickest Query Language, a concise syntax built for filtering large structured datasets with exact matches, comparisons, regex patterns, and logical operators.Writing a Query
Open a Live Table and click the Query tab. Click New Query to create a query, then type your filter in the text editor that opens.Operators
| Operator | Description | Applicable types |
|---|---|---|
= | Exact match | Strings, numbers, dates, IPs |
!= | Does not match | Strings, numbers, dates, IPs |
> | Greater than | Numbers, dates |
< | Less than | Numbers, dates |
~ | Matches regex pattern | Strings |
!~ | Does not match regex pattern | Strings |
AND | Both conditions must be true | |
OR | Either condition can be true |
Basic examples
Exact value:Quote strings and dates. Leave numbers unquoted. When using regex, escape special characters with a backslash (e.g., use
\\. to match a literal period).Grouping Conditions with Parentheses
Use parentheses to control howAND and OR are evaluated when combining multiple conditions:
Running a Query
Click Run to execute the query against the current Live Table. Results are displayed in the table below the editor. The row count updates to reflect how many records match your filter. To clear the filter and return to the full table, remove the query text and run again.Selecting a dataset and columns
Two dropdowns sit next to the Run button:- Live Table — selects which Live Table in the current database to query. Switch between tables without leaving the Query tab.
- Columns — toggles which columns are visible in the results. Use this to focus on the fields relevant to your current filter. This does not affect the underlying data or other team members’ views.
Tips
- Start broad, then refine. Begin with a single condition and add more until you isolate exactly what you need.
- Use parentheses for mixed logic. When combining
ANDandOR, always use parentheses to make evaluation order explicit.