Parameters - Intergraph Smart Materials - Version 10.1 - Administration & Configuration - Hexagon

Intergraph Smart Materials Classic Administration (10.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Administration & Configuration
Smart Materials/Smart Reference Data Version
10.1

All parameters such as project defaults and report parameters used in Smart Materials must be defined on the A.30.05 Parameter screen.

A3005

In general, you can edit all parameters with the Standard indicator not checked, and you cannot edit any of the standard parameters with the Standard indicator checked. Standard parameters with details are delivered with the software.

To create a new parameter, enter the parameter name in the Parameter field and the descriptions in the Short Desc and Description fields. The Standard indicator must remain unchecked to indicate that the parameter is customer defined. The Mandatory indicator specifies whether the parameter is mandatory, which means you must assign a value when using this parameter. This indicator is modifiable even if it is a standard parameter.

Select an option from the drop-down list in the Lexical field. The following options are available:

  • Lexical Where-Clause - A variable SQL where condition can be assigned to the parameter.

  • Lexical Order-By-Clause - A variable SQL Order statement can be assigned to the parameter.

  • no lexical parameter - Discrete values can be assigned to the parameter in the Application Parameter Values block.

Select the type of the parameter from the drop-down list in the Parameter Type field. The following types are available:

  • Module specific - Applies only to a specific Smart Materials module.

  • Product wide valid - Applies to all modules of Smart Materials.

  • System (Oracle Reports) - For example, report parameters.

  • Administration - For example, project defaults.

Select the data type of the parameter from the drop-down list in the Data Type field. The following data types are available:

  • Character

  • Date

  • Number

  • Special Value

You can assign a list of values (LOV) to the parameter, to be used when inserting a value, for example, for project defaults on A.20.12. There are two options when assigning the LOV:

  • based on a query

  • based on static values

If no LOV is assigned to the parameter, select None from the drop-down list in the Query Type field.

If the LOV should be based on a query, select Query from the drop-down list in the Query Type field and enter a select statement in the Command field. The select statement must return two values. The title of the LOV is defined at the end of the statement, enclosed with /* and */.

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 */

The resulting LOV is displayed below.

In case the parameter is a report parameter and the report should be started from Smart Materials BIR, it might be necessary to define an alternative command in the BIR Command field. For more information, see Start Reports Configuration.

If the LOV should be based on static values, select Static from the drop-down list in the Query Type field and enter values for the LOV in the Application Parameter Values block. Enter the value in the Parameter Value field and a description in the Comment field; both will be displayed in the LOV. You can define a value as the default value by selecting the Default check box. To allow the modification of standard parameter values, select the Modifiable check box at the top right hand side of the lower block. Clear this check box to protect the standard parameter values.

For each of the parameter values you can define check conditions that must be fulfilled when setting this value for the parameter. To enter these check conditions, click the Go to next block button. Window 2 opens where you can enter the check condition in the Check Condition field, the condition required to be met in the Operator field, and a description or comment in the Comment field.

When you select a value from the LOV and the condition is not fulfilled, the comment is displayed to indicate the reason why the value cannot be set.

All check conditions must start with SELECT COUNT(*). You can define multiple check conditions for each possible value of the parameter in case of a static query type.

The Operator can have one of two possible values:

  • = 0 - The query returns TRUE (condition fulfilled) if no record is found.

  • > 0 - The query returns TRUE if one or more records are found.

For example, if you try to change the value of a project default from Y to N, all check conditions assigned to N must be fulfilled; otherwise, a change is not possible.

In the same way it is possible to define check conditions for parameters of a non-static query type. In this case, click the Details button to open Window 2 where check conditions are maintained.

If the selected parameter is used in reports, you can assign a table column in the Table Column field. This column will be used to find appropriate information for the report parameter.