Query sections
A Query section looks similar to a multiple-record smart section. A query section contains the records found by a query. A query section has no direct connection with a business object. Queries are discussed in the IBM TRIRIGA Application Platform: Reporting User Guide.
Like other kinds of sections, you can create a query section by selecting the tab that will contain the section and clicking the Add Section action. You then set the value of the Type property to Query Section.
After you have set the value of the Type, Name, and Label properties, the next property to set the value of is the Query property. The value of the Query property is used to determine which query will be run to generate the contents of this query section. What is run to generate the contents of this section does not actually have to be a query. It can be any type of report managed by the Report Manager (discussed in the IBM TRIRIGA Application Platform: Reporting User Guide).
A query section is always viewed within a parent record. If the record is a capital project, the active project for that query section is the record itself. If the record is not a capital project, the active project for the query section is the project that the parent record is in. Whether or not the active project is used in the query section results is dictated by the data scope on the query definition. If the data scope of the query definition is Active Project, the records returned by the query are restricted to the active project.
Queries attached to query sections are not run in the Form Builder. Instead the layout displays a label identifying the section.
When a graphics section is associated to a query section, the only items that can be selected from the graphics section are those associated items that are derived from the query results.
Query sections are resized when the number of rows returned by the query is greater than the height defined. The platform produces scroll bars so the user can scroll the results. For hierarchical queries, the number of rows refers to the top-level (check box) rows and expanding the top level causes the query section height to expand accordingly. For queries with Group By or Sum, the number of rows refers to data (check box) rows, not the sum rows. If a query section has a Sum column, all rows display, including the sum row, and the user does not see the Show drop-down list from which to select the number of rows to view. A query section with Height = 0 defaults to Height = 10. A query section with Height = -1 defaults to Height = 10.
At runtime, if an alternate form is defined for this query section and the user selects a record in this query, the alternate form displays.
In a form, when a user sorts query results, the data is sorted based on Unicode sorting for all languages. The result may not match the expected behavior for non-US English-language users.