Mendix 7 is no longer supported unless you have Extended Support (for details, please contact Mendix Support). Mendix 7 documentation will remain available for customers with Extended Support until July, 2024.
Data grid
The data grid shows a list of objects in a grid. For example, a data grid can show all the orders a customer has placed. Using controls provided by the data grid you can browse, search and edit those objects.
A data grid showing accounts.
Common Properties
Name
The internal name of the widget. You can use this to give sensible names to widgets. The name property also appears in the generated HTML: the widget DOM element automatically includes the class mx-name-{NAME}
, which can be useful for Selenium testing.
Class
The class property allows you to specify one or more cascading style sheet (CSS) classes for the widget. The classes should be separated by a space. The classes will be applied to the widget in the browser and the widget will get the corresponding styling. The classes should be classes in the theme that is used in the project. It overrules the default styling of the widget.
Styling is applied in the following order:
- the default styling defined by the theme the project uses
- the
Class
property of the widget - the
Style
property of the widget.
You can see which widgets in a page have styling applied via the class or style property by clicking the Show styles button.
Style
The style property allows you to specify additional CSS styling. If a class is also specified, this styling is applied after the class.
For example:
background-color:lightblue; color:red;
will result in red text on a blue background.
You can see which widgets in a page have styling applied via the style or class property by clicking the Show styles button.
Tab index
The tab index influences the order in which the end user navigates through the page using the tab key. By default tab indices are zero and the tab order is determined automatically by the client system. A value of minus one (-1) means that the widget will be skipped when tabbing through the page.
Default value: 0
General Properties
Show Control Bar Buttons
This property indicates whether the control bar buttons will be visible in the end user interface.
Default value: True
Show Paging Buttons
This property indicates with the buttons to page through the information in the grid are visible. Only hide these buttons if you are sure that there will never be more objects than the number of rows of the grid.
Default value: True
Width Unit
The width unit specifies the unit of the specified column widths (see property ‘Column Widths’ below). There are two possible values for the unit:
Value | Description |
---|---|
Percentage | Column widths are expressed as percentages of the available width. When resizing, columns will become wider/narrower while keeping the same relative widths. |
Pixels | Column widths are expressed as pixels. Optionally, some columns can have width ‘auto’ and those columns evenly divide the rest of the space. When resizing, the pixel width columns will keep the same size; auto columns will become wider/narrower. |
Default value: Percentage
Column Widths
The column widths property describes the widths of each of the columns as a list of numbers separated by semi-colons. The unit (see above) determines what these numbers mean: percentages or pixels. In the case of pixels, ‘auto’ is also a valid value for the width of a column. Auto columns evenly divide space that remains after giving the pixel width columns their desired width.
Examples:
Widths | Unit | Description |
---|---|---|
30;70 | Percentage | Two columns of which the first is 30% and the second is 70% |
20;200;auto | Pixels | Three columns of which the first is 20 pixels wide, the second is 200 pixels and the last one is ‘auto’ which means that it will take up the rest of the space. |
Number of Rows
With this property you can change the number of rows that will be shown in one page. See also the property ‘Show empty rows’.
Default value: 20
Show Empty Rows
If you choose to show empty rows there will always be the grid will always show the same number of rows (see ‘Number of rows’) even if there are less objects to show on the page.
Default value: False
Selection Mode
The selection mode determines whether and how the user can select items in the grid.
Value | Description |
---|---|
No selection | The user cannot select items. |
Single selection | The user can select a single item by clicking on it. Clicking another item will make that item the selection. |
Single selection and maintain | The user can select one item at a time by clicking on it. Users cannot deselect an item. By default the first item will be selected and removing a selected item will autoselect a subsequent item. |
Multi-selection | The user can select multiple items by clicking the first one and holding the ‘Ctrl’ key while clicking on other items. Simply clicking an item will deselect all items and make the clicked item the selection. |
Simple multi-selection | The user can select multiple items by simply clicking on them. This was the default multi-selection behavior prior to version 3.1.0. |
Default value: Single selection
Select First
This property indicates whether the first item will be selected initially. This is especially useful if there is a data view listening to this grid.
Default value: False
Default Button Trigger
The default button can be triggered by a single or a double click a row.
Value | Description |
---|---|
Single click | A single click triggers the default button. This cannot be used in combination with allowing the user to select rows. |
Double click | A double click triggers the default button. |
Default value: Double click
Refresh Time (in Seconds)
If the refresh time is non-zero, the data grid will refresh its contents every given number of seconds. For example, a task list could be refreshed every minute so that you know when new tasks arrive. By default the refresh time is zero and this means that the grid will not automatically refresh itself.
Default value: 0
Tooltip Page
A tooltip page is a page that appears when you hover your mouse over a row. The tooltip page should consist of a data view on the same entity as the data grid. Besides creating and connecting a tooltip page you also have to specify on which columns the tooltip will appear. See the property ‘Show tooltip’ of data grid columns.
Data Source Properties
The data source determines which objects will be shown in the data grid. For general information about data sources, see Data Sources.
Type
The data grid supports the following types of data sources: Database Source, XPath Source, Association Source, Microflow Source. The database and XPath sources retrieve objects from the database and supports searching and sorting. The database source can also be used in offline applications. The association source follows an association from the enclosing data view to get to the objects. Finally, the microflow source calculates the list of objects by executing a microflow.
Other Properties
See the corresponding data source for its properties:
Visibility Properties
Visible
By default, whether or not an element is displayed in the browser is determined by how the page is designed and the user’s roles within the application. However, the page can be configured to hide the element unless a certain condition is met.
Context
The widget can be made visible only if the object of the data view that contains the widget satisfies the specificied criteria.
A practical example would be a web shop in which the user must submit both billing and delivery information. In this case, you might not wish to bother the user with a second set of address input fields unless they indicate that the billing address and delivery address are not the same. You can accomplish this by making the delivery address fields conditionally visible based on the Boolean attribute SameBillingAndDeliveryAddress
.
Based on Attribute Value
When selected, this shows the widget while a particular attribute has a certain value. Only boolean and enumeration attributes can be used for this purpose.
Based on Expression
Added in Mendix 7.1.
When selected, this shows the widget while a provided expression evaluates to true. The object of the containing data view is available inside an expression as a $currentObject
variable.
Note that the expression is evaluated in the browser, and hence, we advise against using “secret” values (like access keys) in it. In particular, we disallow usages of constants. Also, client-side expressions currently do not support all the functions that are available in the microflows. Please refer to an autocomplete list to know what functions are supported in your version.
Module Roles
The widget can be made visible to a subset of the user roles available in your application. When activated, this setting will render the widget invisible to all users that are not linked to one of the selected user roles.
Components
Columns
Common Properties
Class Property
The class property allows you to specify a cascading style sheet (CSS) class for the widget. This class will be applied to the widget in the browser and the widget will get the corresponding styling. The class should be a class from the theme that is used in the project. It overrules the default styling of the widget.
Note that the styling is applied in the following order:
- Default styling defined by the theme the project uses.
- The ‘Class’ property of the widget.
- The ‘Style’ property of the widget.
Style Property
The style property allows you to specify additional CSS styling. If a class is also specified, this styling is applied after the class.
Data Source Properties
Attribute (path)
The attribute (path) property specifies the attribute’s value that will be displayed in this column. It can be an attribute of the grid entity, or it can be an attribute of an associated entity, in which case we speak of an attribute path. The path can follow multiple associations of type reference, and at the end (optionally) one of type reference set. If you show a reference set in a column the values will be separated by a comma.
Formatting Properties
Enumeration Format (Only for Attributes of Type Enumeration)
A column connected to an attribute of type enumeration can show its contexts as text (default) or as image.
Value | Description |
---|---|
Text | Show the caption text of the enumeration. |
Image | Show the image of the enumeration value. |
Decimal Precision (Only for Decimal Attributes)
The precision of a value is defined the number of digits that is used to express that value. This property indicates the number of decimal places (the number of digits following the decimal point).
Default value: 2
Group Digits (Only for Numeric Attributes)
For ease of reading, numbers with many digits before the decimal separator may be divided into groups using a delimiter. This property defines whether the end user will see these groups, or not.
Default value: False
Date Format (Only for Attributes of Type DateTime)
The date format determines whether the date part, the time part or both are shown. How the date and time parts are formatted depends on the localization of the user using the application.
Possible values: ‘Date’, ‘Time’, ‘Date and time’ and ‘Custom’.
Default value: Date
If you choose ‘Custom’ as the date format (see above) the custom date format determines the way date and/or time are formatted. The custom date format is a string that follows the rules in this table,
Symbol | No. | Example | Description |
---|---|---|---|
G | 1 | AD | Era |
y | 1..n | 2010 | Year |
M | 1..2 | 09 | Month |
M | 3 | Sept | Month |
M | 4 | September | Month |
w | 1..2 | 27 | Week of Year |
D | 1..3 | 93 | Day of Year |
a | 1 | AM | AM or PM |
h | 1..2 | 11 | Hour (1-12) |
H | 1..2 | 13 | Hour (0-23) |
k | 1..2 | 10 | Hour (1-24) |
K | 1..2 | 0 | Hour (0-11) |
m | 1..2 | 59 | Minute, use one or two for zero padding |
s | 1..2 | 12 | Second, use one or two for zero padding |
Format | Example output |
---|---|
EEEE d MMMM yyy G, h:mm a ss's |
Tuesday 29 March 2011 AD, 1:37 PM 48s |
h:mm a |
1:37 PM |
yyy D KK:mm |
2011 88 01:26 |
EEEE MMMM d yyy |
Tuesday March 29 2011 |
EEE, MMM d, ''yy |
Wed, Jul 4, ‘01 |
General Properties
Caption
The caption of a column is the text that appears as a header above the rows. This is a translatable text. See Translatable Texts.
Editable
The editable property indicates whether the values of the column will be editable inline, as in, without opening a page with a data view. In-line editing allows the data grid to behave like you would expect from a spreadsheet application.
Aggregate Function
The values in a column can be aggregated in several ways. The aggregate function determines the way in which the values are aggregated. The aggregate will be shown at the bottom of the column that precedes by the aggregate caption (see below).
Value | Description |
---|---|
None | Do not aggregate the values in the column. |
Average | Show the average of the values. |
Minimum | Show the smallest value. |
Maximum | Show the largest value. |
Sum | Show the sum of the values. |
Count | Show the count of the values. |
Aggregate Caption
The aggregate caption is the text that appears in front of the computed value. This is a translatable text. See Translatable Texts.
Show Tooltip
This property determines whether the tooltip page is shown as the mouse is hovered over this column. The tooltip page can be configured on the data grid.
Default value: False
Control Bar
The control bar of the template grid, data grid, and reference set selector allows you to manipulate the objects displayed by means of buttons. By default, both grids will be created with a new, edit, and delete button in the control bar. The control bar can also include a number of selection options and spreadsheet export buttons, as well as microflow buttons for custom actions.
See Control Bar.
Search Bar (for the Database and XPath Data Source Types)
The search bar contains search fields that allow the end-user to quickly find the information they need.
See Search Bar.
Sort Bar (for the Database and XPath Data Source Types)
The sort bar contains a number of sort items. Each sort item specifies what attribute to sort on and in what direction (ascending or descending). First the contents of the grid will be sorted on the first item; if two rows are the same with respect to this sort item the second item will be used et cetera. For example, if you have sort items for name and age and two people have the same name they will be sorted on their age.
See Sort Bar.