Constructing a query with a SQL statement

About this task

In the administration console, you can review and change the settings that affect how queries are run. In particular, you might want to force case-insensitive search behavior.

You can optionally start query construction on the Simple View tab. This construction activity is represented by SQL text that Content Platform Engine automatically enters on the SQL View tab. You cannot switch back to the Simple View tab, however, without losing the changes that you made on the SQL View tab.

To set query-related parameters and construct an SQL query:

1. Access the Query tab in the administration console to set the query-related parameters.
   1. In the domain navigation pane, click the object store.
   2. In the details pane, click the Query tab.
   3. Change property values as wanted.
   4. Save your changes.
2. Access the search node in the administration console to construct an SQL query.
   1. In the domain navigation pane, click the object store.
   2. In the object store navigation pane, click Search.
   3. On the Search tab, click New.
   4. On the New Search tab, click the SQL View subtab.
   5. Enter SQL text for your query.
   6. To run the query, click Run.