-
Open the Select Filter Dialog Box by doing one of the following:
Click Tools >Select by Filter.
Select More from the Filter list on the Define Workspace Dialog Box.
Select More from the Filter list on the Surface Style Rule Properties Dialog Box.
-
Select a location in the tree view to place the SQL filter. You can add the SQL filter in the Catalog Filters, Model Filters, or My Filters folder, or move the filter after you create it.
-
Click New SQL Filter
.
-
On the Filter Properties Dialog Box, type the name that you want to assign to the SQL filter in the Name box.
Filter names must be unique within the folder. You can have a filter in your My Filters folder with the same name as a filter in another folder. If you move a filter into
a folder that already contains a filter of the same name, the software adds a numeric
suffix to the filter name to keep the filter names unique.
-
Type the SQL statements in the Text of SQL query box.
-
If you use SQL or Oracle reserved keywords in your query, you must place square brackets [ ] around the words. Also, if you include spaces in property names, you must place brackets around the names.
-
You can use SQL filters inside compound filters. A compound filter combines two or more filters by using an operator, such as not, union, or intersection, between the filters to explain the relationship between the filters.