Dashboard widgets

Official Content

A Dashboard layout is composed of different kind of widgets available on the toolbar. The available options are:

  • Filter
  • Image
  • Query
  • TextBlock
  • Table

Filter

Its function is to filter the data in the remaining widgets of the dashboard that accept that filter as an input. All the filters in the dashboard are global in a sense they broadcast its value to every widget in the dashboard. It's the definition of the widget that determines if a filter on the screen is accepted as a parameter of the widget or ignored. All filtering is done taking into account its name. So, if you have a filter name called "CustomerId"; when changing its value, all queries with a parameter matching "CustomerId" will be updated.

The most important properties are:

  • Control Name: name assigned to the control.
  • Frame: to define if the filter has a frame.
  • Name: filter name to be used in query widgets.
  • Visible: Whether the filter is visible or not (boolean). It is useful if you want to leave a filter with a fixed value and it cannot be changed.
  • Caption: text to be displayed.
  • Type: filter data type (enumerated: numeric without decimals, numeric with decimals, boolean, character, date or datetime).
  • IsCollection: Whether the value is multivalued or not (boolean).
  • Control Group
    • Type: control type (edit, radio button, combo box, drop-down list).
    • Dynamic: if possible values are fixed or are calculated by an expression (boolean).
    • Values: applies to non-dynamic filters and is a collection of fixed values, indicating for each value a Name and Value.

The filters may be static or dynamic. When static, the list of possible values must be provided in the filter's definition. When dynamic, you must provide an attribute for the filter values, another one for the filter value descriptions and the set of conditions that may be necessary to navigate the database in search of the filter possible values. For example; if you have a Brand and Model filters, the condition for Model would be: MakeDsc = &MakeDsc (anywhere in the Dashboard filters are referenced with & + <FilterName>).

There are no actions you can define in a filter because the filter's action is specific. They are used to inform other widgets that some value has changed and they need to refresh themselves.

Image

Inserts a standard Image object on the layout.

Query

Displays a Query object. The main properties are:

  • Object: referenced query object.
  • Type: Visual output type (Card, Chart, PivotTable, or Table); depending on the type of output chosen, the associated properties are the same as in the QueryViewer properties section.
  • On Item Click: Action to be executed when clicking an item (not implemented yet!).

TextBlock

Inserts a reduced version of a Text Block control. The main properties are:

  • Frame: to define if the filter has a frame.
  • Caption: text to be displayed.

The properties include the caption of the text and it may reference any filter in the dashboard, for example, "List of &CustomerName orders:"

Table

Inserts a reduced version of a Table control to organize and position other widgets.

Standard Variables

The following standard variables are supported

Was this page helpful?
What Is This?
Your feedback about this content is important. Let us know what you think.