Query Builder - Intergraph Smart Reference Data - 2020 (10.0) - Help - Hexagon

Intergraph Smart Reference Data Plus Help (2020)

Language
English
Product
Intergraph Smart Reference Data
Search by Category
Help
Smart Materials/Smart Reference Data Version
2020 (10.0)

A where condition corresponds to a database object called VIEW, and is also called as a stored query. Based on the data you provide, the application generates a view and assigns a unique name to the view. The module that is assigned to the where condition can then access the contents of this view using the view name. There are two methods of creating a where condition:

  • Property based

  • Rule based

The Property based where conditions require the creation of an alias or property that references the base table structure of Smart Materials, whereas the Rule Based where conditions can be built from predefined tables and properties.

You can use the rule based conditions similar to the property based conditions, except that the conditions defined in the Rules tab are joined using the OR operator and hence you cannot define additional conditions. You can only define alternative conditions, which means any one of the conditions must be fulfilled.

You cannot define both property based and rule based definitions for one view.

What do you want to do?