User`s guide

Refine Results Using Query Criteria and Rules
4-21
Refine Results Using Query Criteria and Rules
In this section...
“Define Query Criteria to Refine Results” on page 4-21
“Query Rules Using the SQL Criteria Panel” on page 4-22
To define a query without writing SQL code, use the SQL Criteria panel in Database
Explorer. Define criteria to build your query within one table or join multiple tables in
the database. Build your query using the SQL Criteria panel rules and control options.
Define Query Criteria to Refine Results
Database Browser selections and SQL criteria work together.
Using the Database Browser pane and the SQL Criteria panel, you can define query
conditions and display the results in the Data Preview pane. Each row in the SQL
Criteria panel has a drop-down list of controls to define SQL query conditions. You can
create SQL query conditions that span multiple rows in the SQL Criteria panel.
Requirement: When you enter a custom value in the text box on the right side of a query
condition, press Enter or Tab to apply it. Alternatively, you can click the Import button
to apply the condition and import data into a MATLAB variable.
If you do not use the Enter or Tab keys to apply the query condition, selecting Import
> Import applies the condition to the Data Preview pane. Then, Database Explorer
imports the data into a MATLAB variable. If there is no data to satisfy the condition,
then the Nothing to import error message appears.