Define parameters and parameter values - 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)
  1. From the Home page, select Administration > Global Setup > Parameters.

  2. Click Add Row in the Parameters section.

  3. Type a parameter name in the Parameter cell.

  4. Type the descriptions in the Short Description and the Description cells.

  5. Select Yes in the Standard list if the parameter is a standard parameter

    Standard parameters are parameters that are delivered with the software and are not editable.

  6. Select Yes in the Mandatory list to indicate that the parameter is mandatory.

  7. Select an option from the Lexical list:

    • Lexical Where-Clause - to assign a variable SQL where condition to the parameter.

    • Lexical Order-By-Clause - to assign a variable SQL Order statement to the parameter.

    • No lexical parameter - to assign discrete values to the parameter in the Parameter Values block.

  8. Select Yes in the Modifiable list to modify the standard parameter values.

    Standard parameters are not editable. You can edit/modify the standard parameter values by setting Modifiable to Yes.

  9. Select a parameter from the Parameter Type list:

    • Module specific - specifies that the parameter applies only to a specific Smart Materials module

    • Product wide valid - applies to all the modules of Smart Materials

    • System (Oracle Reports) - applies to, for example, report parameters

    • Administration - applies to, for example, project defaults

  10. Select a data type from the Data Type list.

  11. Select a query type from the Query Type list:

    1. Query - specifies that the list of values should be based on a query set.

    2. Static - specifies that the list of values should be based on static values. Type the list of values in the Parameter Values section.

  12. Based on the query type selected in Step 11, do the following:

    1. For Query type, enter the select statement in the Command cell.

      • The select statement must return two values.

      • The title of the list of values must be defined at the end of the select statement and must be enclosed in /* */. For example, the LOV of parameter ZB_LST_ID is defined as:

        select LST_ID, LST_CODE from m_list_status /* B.10.02 List Status */

    2. For Static type, enter the list of values in the Parameter Values section.

  13. Type a table column.

  14. Type an alternative command in the BIR Command cell if the parameter is a report parameter.

    For more information on BIR, see Smart Materials Business Intelligence Reporting User’s Guide.

  15. To check the conditions of the parameters, select a parameter and click Check Conditions.

    • You can add multiple check conditions and all the check conditions must start with Select count(*).

    • You can validate the check condition that are either equal to zero or greater than zero.

    • For checking the conditions of a parameter, the selected parameter must not have parameter values defined.

Define parameter values

  1. In the Parameter Values section, click Add Row.

  2. Type a Parameter Value.

  3. Select Yes from the Default list to make the parameter value as the default value.

  4. Type a comment and then click Save.

  5. To set the conditions that must be fulfilled for a parameter value, select a parameter value and click Check Conditions.

    For checking the conditions of a parameter, the selected parameter must not have parameter values defined.

  6. In the Parameter Check Conditions pop-up, click Add Row.

  7. Type the Check Statement.

    • You can add multiple check conditions and all the check conditions must start with Select count(*).

    • You can validate the check condition that are either equal to zero or greater than zero.

  8. Select a condition from the Condition list.

  9. Type a comment and then click Save.