Define Query-Based Parameter - Intergraph Smart Materials - Version 2016 R4 (8.4.0) - Administration & Configuration - Hexagon PPM

Intergraph Smart Materials Report Configuration (2016 R4)

PPMProduct
Intergraph Smart Materials
PPMCategory_custom
Administration & Configuration
Version_SPMat_custom
2016 R4 (8.4)

A query-based parameter uses a select command to retrieve a value at runtime. The values are shown in a list of value (LOV) in A.60.71.

Enter the Parameter name, Short Description and Description for the new parameter. Choose System (ORACLE Reports) as Parameter Type and the Data Type and Query Type Query.

In the Command field, enter the query for the parameter. The Query must have two columns; the first one will pass to the report.

At the end of the query you can enter a comment by using /* and */ . The text in the comment is used as the title of the list of value in A.60.71.