Where Conditions - 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)

You can define and maintain customized where conditions. You can use the where conditions in Smart Materials modules that need a limited view on the database content. For example, you define where conditions to select specific material for a requisition when running an MTO job.

Technically, a where condition corresponds with a database object called VIEW, which is like a stored query. From the data you enter on this page, the application generates a view and assigns a unique name to it. The module assigned to the where condition can then access the contents of the view by using the internal view name. You can create a where condition using one of the following two methods:

  • Property based

  • Rule based

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

The rule based where conditions is similar to the property based where conditions, with one difference. The conditions defined in the Rules section are joined using the OR operator and you cannot define additional conditions that also have to be fulfilled to get a result. You can only define alternative conditions, which means any of the conditions must be fulfilled.

For property based where conditions, based on the module selected, the required MAPPED_TO record(s) will automatically be filled in the Properties section of the Where Condition Details page, after saving the where condition.

You can not use both rule based and property based definitions for one view.

The following is a list of available modules and the column to be mapped:

Module

Mapped to Column

Label

A2051

IDENT

UOM Configuration

A6008

INTERNAL

Define Formulas

A6009

INTERNAL

Formula Assignments

AS1004

IDENT

AS.10.04 Catalogs

B1001

LP_ID

Verifications

B1005

IDENT

BOM Rules

B200123

LP_ID

Maintain BOM > Reconcile BOM-Assemblies

B200126

LP_ID

B.20.01.26 Define Search/Repl Condition

B200135

LP_ID

B.20.01.35 Verification and Status

B200141

LP_ID

B.20.01.41 Start Job

B200144

LN_ID

Maintain BOM > List Download

B2003

LP_ID

Macro/Procedure log files

B4012_1

IDENT

BOM Compare (Where Condition for Ident)

B4012_2

LP_ID

BOM Compare (Where Condition for List Position)

B4021

IDENT

BOM Compare

C1005_1

IDENT

Work Packages (Where Condition for Ident)

C1005_2

LP_ID

Work Packages (Where Condition for List Position)

C1005_3

LP_ID

Work Packages (Where Condition for mandatory LP)

C1005_4

LP_ID

Work Packages (Where Condition for CIP(List Pos))

C1005_5

IDENT

Work Packages (Where Condition for CIP(Ident))

E1011

IDENT

E.10.11 Estimate Calculation

E1012

IDENT

E.10.12 Update Estimations

ISK1002

IDENT

I-Sketch 10.02 SKEY Mappings

P1042

IDENT

P.10.42 Material Groups

P1091

LP_ID

P.10.91 Fabrication Types

P7072

IDENT

P.70.72 Expediting Details

R1023

IDENT

Material Take Off Jobs

R1024

RLI_ID

Requisition Document Types

R1041

IDENT

Nodes and Templates

R1042

LP_ID

Requisition Split Criteria

R1051

IDENT

Material Take Off Jobs

S8014

IDENT

S.80.14 OII - Export Jobs

SAP2001

IDENT

Requisition Transfer Jobs

Only users who own the privilege CHANGE QUERY CONDITION are allowed to change where conditions from other users. Without this privilege, the user can only change his own where conditions.