Query Parameters Designer Dialog Box - Intergraph Smart 3D - Help

Intergraph Smart 3D Reports

Language
English (United States)
Product
Intergraph Smart 3D
Subproduct
Drawings and Reports
Search by Category
Help
Smart 3D Version
11 (2016)
SmartPlant Foundation / SDx Version
7.1 (2018 R1)

This dialog box is accessible in both the Catalog task and the Drawings and Reports task.

In both tasks, you first select a label with query parameters (a SQL label) on the Label Editor dialog box. For more information, see Label Editor Command. Then, click in the Properties area to display the Query Parameters Designer dialog box.

You can also view this dialog box if you edit a report template with query parameters in Drawings and Reports.

Name

Provides an internal name for the parameter.

Index

Specifies an index number for the parameter. This number provides a mapping between the prompt that displays at runtime and the query syntax. The reason for this number is the SQL/ADO limitation of positional parameters only.

Caption

Provides a caption for the parameter at runtime.

Prompt Category

Specifies the category of prompt for the query parameter.

Prompt Type

Specifies the type of prompt. This list is based on your selection under Prompt Category.

SQL Data Type

Specifies a data type available in the SQL query language.

Default Value

Defines the default value for the parameter.

Displayed

Specifies whether or not the parameter displays on the report.

You can move the parameters up and down in the list on the dialog box by clicking Move Up and Move Down.