Specify Query CriteriaBack to index page
It is possible to specify additional query criteria for import on Query tab. Columns could be filtered based on the following criteria:
Numeric columns: =,<>,<,”<=”,”>”,”>=”
Text based columns: Like, Starts with, Ends with, Contains.
Note: The decimal separator should be always specified as „.”, regardless of the cultural settings.
Query criteria for related tables
If the selected table contains related tables, it is possible to specify query criteria on those columns as well.
Note: Related tables are tables that have foreign key relation between them defined in Oracle. This information is retrieved from the Oracle schema.
How to specify a query criterion
Find all structures where the molweight is less than 250, and the formula begins with „C10”.
Deleting a query criterion
By pressing Next button you can switch to Columns tab.