QueryViewer control properties (X Evolution 3)

Unofficial Content

Control properties

QueryViewer control (X Evolution 3) properties are:

Auto Refresh Group property Allows the association of different Query Viewer controls that provide related information (or the same information, with a different output) to be automatically updated when one of them is changed.
ControlName property ControlName, used to reference the control in the GeneXus object code.

 

Event Parameters Group  
Drag And Drop Data property Contains the name of the variable that can be used in the DragAndDrop event.
Item Expand Data property Contains the name of the variable that can be used in the ItemExpand event.
Item Collapse Data property Contains the name of the variable that can be used in the ItemCollapse event.
Filter Changed Data property Contains the name of the variable that can be used in the FilterChanged event.
Aggregation Changed Data property Contains the name of the variable that can be used in the AggregationChanged event.
Item Click Data property Contains the name of the variable that can be used in the ItemClick event.
Item Double Click Data property Contains the name of the variable that can be used in the ItemDoubleClick event.

 

Data Bindings  
Object property - QueryViewer Contains the name of the Query object or Data Provider object displayed in the Query Viewer Control.
Axes Property It contains the name of the variable and is used to act programmatically on the chart axes.
Parameters Allows sending values to the Query Object or Data Provider Object at runtime.
Use Cache property It avoids accessing the server to show the last view of a chart.

 

Appearance  
Shrink To Fit property It allows specify if want to use the minimum Column Width (Table and Pivot Table) necessary to display the contents of all their cells.
Auto Resize property - QueryViewer It allows reducing the size of the Pivot Table or graphics when we need additional free space for other controls or objects.
Hide Measures Properties Box property It allows hide the measures area (Pivot Table), either design time or runtime.
Axes Selectors property It allows showing or hiding the lists of values (dialogs) that query elements have.
Disable Expand Collapse property It allows to show all the expanded elements from the start with no possibility to collapse them.
Allow Change Axes Order property It allows sorting the fields in the Pivot Table according to the order set in the Query object or the Web Form.
DisableColumnSort Property It allows enabling or disabling the end user’s ability to change the information layout.

 

Export  
Export Properties group It allows exporting the Pivot Table or Table to XML, HTML, XLSX, XLS and PDF formats.

 

Output  
QueryViewer Type property Allows developers to select the output type to be used.
QueryViewer Chart Type property Allows developers to select the type of chart to be used.
XAxis Title property Allows writing the caption that will appear on the X axis.
YAxisTitle Property Allows writing the caption that will appear on the Y axis.
Preferred Renderer For Query Viewer Charts property Enables the selection of technology for showing Charts with views through Flash or Javascript.
Preferred Renderer For Query Viewer Pivots and Tables property Enables the selection of technology for showing Pivot/ table and Tables with views through Flash or Javascript.
XAxis Labels property Set the position of the chart axis labels.
Show Values property Set if the chart values are shown in the control.
Paging property Set if paging is required, if Type is set to Table or Pivot Table, By default set to true.
Page size property Page size, applies when paging = true
Show Data Labels In property It allows to indicate how you want to display the Data elements of the Query object.

 

State management  
Remember Layout property Allows keeping the latest Table/Pivot Table status (for the same user in the same browser).

 

All these properties can be set at design time and runtime. To simplify the use of the properties at runtime, some Domains are automatically added to the Knowledge Base when a QueryViewer control is used for the first time.

Control properties (in run-time only)

IsExternalQuery Allows indicating that the query is defined in GXquery and not in the KB itself. It is related to the ExternalQueryResult property.
ExternalQueryResult Allows to load the result of the Execute method of the GXquery API before showing the query. It is related to the IsExternalQuery property.