Sets where the query element will be presented (specific to the Pivot Table).
| Columns | It’s the one that has the column headers, and in particular, are present in the Pivot table view. It’s ideal for creating a data matrix or showing trends over time. Any column can be dragged to the filters area and vice versa. |
| Pages | This area is located above the control and contains an optional group of one or more drop-down controls, similar to combo boxes. |
| Rows | It shows the field’s unique values on the left side. Typically, this area has at least one field even though it may have none. The data types included here are those that group and categorize. |
Objects: Query
An Axis can be set as:
The property is only valid when the Output is a PivotTable; it does not apply to the case of Table, Card, or Chart.
It shows the field’s unique values on the left side. Typically, this area has at least one field even though it may have none. The data types included here are those that group and categorize, such as products, names, places, etc. and they can be of any type.
It’s the one that has the column headers, and in particular, are present in the Pivot table view. It’s ideal for creating a data matrix or showing trends over time. Any column can be dragged to the filters area and vice versa.
This area is located above the control and contains an optional group of one or more drop-down controls, similar to combo boxes. Usually, the types of fields included here are those to be isolated from the rest to obtain a different view of the entire table.
This property applies both at run-time and at design-time.
To apply the corresponding changes when the property value is configured, execute a Build with this Only of the object.
This property is available since GeneXus 17 upgrade 1.
Type property in Query Element
Visible property in Query Element