Query section properties

Properties in a query section include information such as Type, Name, Label, Height and so on.

To select a query, click the search icon in the Query property. Clicking the search icon causes a Select Item(s) panel to pop up over the Properties panel.

Initially, no queries appear in the Select Item(s) panel because no module is selected. Select the module of the query you want from the drop-down list to the right of the Module label. Once the module is selected, the system displays all queries for that module from the Report Manager. If what you are looking for is a query, you will see it in a list.

If what you are looking for is not a query but some other kind of report, you will not see what you are looking for because the list initially includes only queries. You will need to select the type of report you want to see.

To select the type of report you want to see, click the filter icon to the right of the Reports List label. From the menu, you can choose the type of report you want to see a list of or you can choose All to see a list that contains every kind of report.

The query or report you use in a query section should have an association filter that uses $$RECORDID$$ or $$PARENTID$$ so that its results only include records associated with the record that contains the Query section.

Common section properties includes information about the following properties in a query section: Type, Name, Label, Height, Title Bar Color, Visible, Expand Section, Read Only, Show Title Bar, Style Class, Start Row, Row Span, Start Column, and Col Span. The properties in a query section that are not described in Common section properties follow:
Query
See the explanation of this property in the preceding paragraphs.
Threshold Record Field

This property is visible only when the query specified in the Query property is a metric query. Use this property to provide context sensitive behavior for a metric query displayed in a form.

The Threshold Record Field drop-down list contains locator fields anchored to the Threshold business object. At runtime, the platform uses the threshold record from this locator instead of the threshold record specified in the query within the Report Manager. If the locator does not specify a threshold record, the platform uses the threshold record specified in the query.

Auto Refresh
If you wish the query section to refresh automatically, select the Auto Refresh property.
Refresh Time in secs.
This property is visible only when the Auto Refresh property is selected. Enter the number of seconds the platform should wait between automatic refreshes of the query section.
Workflow

The workflow specified by the value of this property is run when, as a result of a Find action, a person selects records to be associated with the record that contains the Query section. Find actions are discussed in Query section actions.

This workflow is typically used to update totals or other statistics about associated records in the record that contains the query section.

If this property has no value, no workflow will be run when a find action is used to associate additional records with the record that contains the query section.

To specify the value of this property, click the search icon. Clicking the search icon causes a list of synchronous workflows to appear. The synchronous workflows in the list will be workflows launched from records created from the business object associated with the form that the query section is part of. If you select one of the workflows in the list and click the OK action on the list, the workflow you selected becomes the value of this property.

If you want to clear the value of this property so that it has no value, click the X icon.

Association Type

The value of this property is the name of the association this section will be based on. If you use the Find or Add action that the IBM® Maximo® Real Estate and Facilities may provide for this query section, the found records or newly created record will become associated with the record that contains this section using the specified association name.

These platform-provided actions are described in Query section actions.

Select Association Type

Workflows may be run as a result of someone clicking a form state transition action (described in "State-based actions"). It may be helpful for the workflow to be able to recognize if the person who clicked the action that triggered the workflow first selected some records displayed in the query section by checking the check box for the record.

If an association name is selected for the value of this property and someone clicks an action you defined that triggers a workflow, the platform will create an association from the record associated with the form to the any records shown in this section that have their check box checked.

There is a different mechanism that allows a workflow run from an action in a query section to navigate to selected records. This is discussed in Query section actions.

Having the same Select Association Type on multiple query sections in the same form may result in undesired select behavior as those sections are sharing the same select associated records. Use a different Select Association Type for each query section to properly maintain each select association.

Temp Select Association
When selected, the query section association is temporary. When not selected, the query section association is permanent.
Alternate Form List
This property identifies the alternate form list to be used to display a record when that record is opened from this query section. The alternate form used to display the record depends on the module, business object, and form defined for the record.
Single Select

If this property's check box is not checked, it means that a user may select the check box for any or all of the records in the Query section.

If this property's check box is checked, it means that a user may select only one of the records in the query section.

Select Workflow

This property is only displayed if the Single Select property is checked. The workflow specified by the value of this property is run when a user selects the radio button of a record contained in the query section.

If this property has no value, then no workflow will be run when a radio button is clicked.

To specify the value of this property, click the search icon. Clicking the search icon causes a list of synchronous workflows to appear. The synchronous workflows in the list will be workflows launched from records created from the business object associated with the form that the query section is part of. If you select one of the workflows in the list and click the OK action on the list, the workflow you selected becomes the value of this property.

If you want to clear the value of this property so that it has no value, click the X icon.

Note that the Select association created when the user clicked the radio button will be deleted after the workflow(s) complete.

Show Add
If this property's check box is checked, then there will be an Add action for people to click in this query section. The Add action is described in Query section actions.
Show Query Header
If this property's check box is checked, then column headings for the query results will be displayed in the query section. This check box is usually checked. If this check box is not checked then no column headings will be displayed in this query section.