If you would like to upgrade to a newer long-term support version of Studio Pro, see Moving from Mendix Studio Pro 8 to 9.
Columns (Document Template)
Appearance Properties
Caption
The caption of a column is the text that appears as a header above the rows. This is a translatable text. See Internationalization.
Enumeration Format (Only for Attributes of the Enumeration Type)
A column can show its contexts as text (default) or as image.
| Value | Description |
|---|---|
| Text | Show the contents of the connected attribute as a text. |
| Image | Show the image of the enumeration value. |
Decimal Precision (Only for Decimal Attributes)
The precision of a value is defined by 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: 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: False
Date Format (Only for Attributes of Type Date and time)
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.
These are the possible values:
- Date (default)
- Time
- Date and time
- Custom (see below for more details)
Custom Date Format (Only for Attributes of Type Date and time)
If you choose Custom as the date format (see above), this property determines how the attribute value is formatted. The custom date format is a string that allows for any combination of symbols found in the table below. Any punctuation will be rendered literally.
All examples are for 30th December 2014, at 00:27:16.789
| Symbol | Example | Description |
|---|---|---|
G |
AD | The era |
y, yyy, yyyy, etc. |
2014 | Year |
yy |
14 | Year |
Y, YYY, YYYY, etc. |
2015 | Week year, use in combination with w for week number formatting |
YY |
15 | Week year, use in combination with w for week number formatting |
M, MM* |
12 | Month number |
MMM |
Dec | Month abbreviation |
MMMM |
December | Month name |
w, ww* |
1 | Week of year, use for week number formatting |
d, dd* |
30 | Day of month |
D, DD, DDD |
364 | Day of year |
a |
AM | AM or PM |
h, hh* |
12 | Hour (1-12) |
H, HH* |
00 | Hour (0-23) |
k, kk* |
24 | Hour (1-24) |
K, KK* |
00 | Hour (0-11) |
m, mm* |
27 | Minute |
s, ss* |
16 | Second |
S, SS, SSS |
789 | Milliseconds |
E, EE |
05 | Day of week number |
EEE |
Tue | Day of week abbreviation |
EEEE |
Tuesday | Day of week name |
X |
08:00 | Time zone parsed |
Z, ZZ, ZZZ |
-04:00 | Time zone offset |
ZZZZ |
GMT-04:00 | Time zone offset and standard |
*Two characters pads with zero
These are some examples:
| Format | Example Output |
|---|---|
EEEE d MMMM yyy G, h:mm a ss's' |
Tuesday 30 December 2014 AD, 12:27 AM 16s |
h:mm a |
12:27 AM |
yyy D KK:mm |
2014 364 00:27 |
EEEE MMMM d yyy |
Tuesday December 30 2014 |
EEE, MMM dd, ''yy |
Tue, Dec 30, ‘14 |
EEEE, 'week' ww YYYY |
Tuesday, week 01 2015 |
Data Source Properties
Attribute (Path)
The attribute (path) property specifies the attribute whose value will be displayed in the column. It can be an attribute of the grid entity, or it can be an attribute of an associated entity. The path over which an associated object is accessed is referred to as 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.