Properties for Where conditions - Intergraph Smart Materials - 10.2 - Help - Hexagon

Intergraph Smart Materials Web Help (10.2)

Language
English
Product
Intergraph Smart Materials
Subproduct
Web
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.2

To define property based where condition, you must first create properties in the Query Builder > Properties page as you define selection criteria based on the properties.

An in-depth knowledge of internal data structures and SQL processing is required to define property definitions and must be performed an expert.

The properties used in the where condition are aliases and not the base table property definitions from Smart Materials core database. It is easier for the engineers to easily identify aliases defined by the database administrator than the core database table/property structures. The aliases are called properties for where conditions and the more common ones are delivered by default.

Defining properties involves the following steps:

  1. Assign a unique name and a module reference to the property definition.

  2. Decide a base table to select an property.

  3. Specify the column of the table.

You must know how the table you choose relates to tables M_IDENTS, M_LIST_NODES, M_LIST_POS, and M_REQ_LINE_ITEMS. Each property must be joined to at least one of these tables. If there is a direct relationship, you might use enter the name of the join column or AUTO. If there is no direct relationships, you can specify the use of a specific intersection table to create the join.

  • Use the AUTO option carefully since it is always displayed in the list of values, but the program that creates the view definition might be unable to find a join column. Check the SQL command text of the generated view for as an error results in an unwanted cross join and thus wrong result set.

  • Additionally, you can specify a user-defined where condition to further restrict the property. If you want to refer to the base table of the property in this condition, use the prefix "BASE_TABLE".