Query Builder

Owned by Michelle Cabaya
Sept 08, 2020
1 min read

You can use the query builder to create an advanced find.

Accessing the Query Builder

  1. Click the Advanced tab.

  2. Click the Query Builder icon.

How to Create an Advanced Find

You can type in your SQL query or click in the columns to help create the SQL query.

Manually Enter SQL

Click the SQL Text field and enter the SQL query

Using the Helper Columns

Double click the SQL syntax, table/views, or table/views columns you would like to use to add it to the SQL Text. Make sure to replace the placeholder text such as “<<ColumnList>>” with applicable column names.

See https://cxtsoftware.atlassian.net/wiki/spaces/CXTsupport/pages/1405616469 for more information.