Create a rule based where condition - Intergraph Smart Reference Data - 2020 (10.0) - Help - Hexagon

1. From the Home page, select Administration > Global Setup > Query Builder.

2. From the Where Conditions tab, select a rule based where condition.

3. Click Add Row.

   

4. Select a commodity group from the Commodity Groups list.

5. Select a commodity part from the Commodity Parts list.

6. Select a master table from the Tables list.

7. Select a table name from the Tables list.

8. Select a table detail from the Tablenames with Details list.

9. Select a commodity code from the Commodity Codes list.

10. Select an ident code from the Ident Codes list.

11. Type details for Input 1, Input 2, Input 3, Input 4, and Input 5 and then click Save.

Add commodity code properties

1. In the Commodity Code Properties section, click Add Row.

2. Select a property from the Properties list.

3. Select an operator from the Operator list.

4. Select a value from the Values list and then click Save.

Add list position properties

1. In the List Position Properties section, click Add Row.

2. Select a property from the Properties list.

3. Select an operator from the Operator list.

4. Select a value from the Values list and then click Save.