Title
optional
string
The title of the box.
TitleIcon
optional
string
The name of a system icon to display next to the box title.
TitleIconId
optional
int
Deprecated. Use TitleIcon instead.
Displays an icon next to the box title.
TitleIconBadgeId
optional
int
Deprecated. Avoid using badge icons.
Override menu item badge.
ColumnSpan
optional
int
Specifies the column span for the box. If this is above one the box will be displayed on a separate row.
BoxLink
optional
string
Displays the link with the specified alias in the title row of the box.
Columns named PassingField_<xxx> will not be shown in the box and can be referenced from the link as a Column value with name <xxx>.
Only one BoxLink per box can be used.
LinkId
optional
int
Deprecated. Use TopLink/BoxLink instead.
Displays the specified link among the top links and in the title row of the box. The link will only appear in the title row if no ordinary columns lie before it in the resultset.
Columns named PassingField_<xxx> will not be shown in the box and can be referenced from the link as a Column value with name <xxx>.
Only one of TopLink, LinkId, MenuItem and MenuItemId can be used at the same time.
Multiple LinkId columns may appear in a single resultset.
TopLink
optional
string
Displays the link with the specified alias among the top links.
Multiple TopLink columns may appear in a single resultset.
IsPrimaryTopLink
optional
bit
Used in conjunction with "TopLink" to mark it as a primary link. Only one link may be marked as primary.
TopLinkDisabledReason
optional
string
If not null the the top link will be disabled with the tooltip of the disabled button set to the content of the column.
Default: null, enabled.
MenuItem
optional
string
Recommended to use TopLink/BoxLink instead for better tracking of links.
Displays a link to the menu item with this alias among the top links and in the title row of the box. The link will only appear in the title row if no ordinary columns lie before it in the resultset.
Only one of TopLink, LinkId, MenuItem and MenuItemId can be used at the same time.
Multiple MenuItem columns may appear in a single resultset.
MenuItemId
optional
int
Deprecated. Use TopLink/BoxLink instead.
Displays a link to the menu item with this id among the top links and in the title row of the box. The link will only appear in the title row if no ordinary columns lie before it in the resultset.
Only one of TopLink, LinkId, MenuItem and MenuItemId can be used at the same time.
Multiple MenuItemId columns may appear in a single resultset.
NavigatorLinkText
optional
string
Deprecated. Use TopLink with a link label instead.
Used in combination with menuitem/menuitemid to give the navigator link a text that differs from the name of the menu item.
PassingFields
optional
string
Additional information to menuitem/menuitemid, appends values to querystring (supports simple Softadmin® parameters).
If multiple passingfield columns exists, only the first one is used and the others are disregarded.
<colname>
optional
string
Value displayed in the box with heading defined by field information or column name.
<colname>_Color
optional
string
Sets the text color of <colname> to the specified color. See Colors.
<colname>_Icon
optional
string
The name of the system icon to show before the <colname> value.
Use the menu item "Admin>Theme>System icons" to register system icons.
<colname>_IconColor
optional
string
Color to use for the icon specified in <colname>_Icon. See Colors.
<colname>_CellLink
optional
string
Displays the link with the specified alias as a cell link for the <colname> cell.
PassingField_<xxx> columns can be referenced from the link.
Only one of <colname>_CellLink, <colname>_LinkId, <colname>_MenuItem or <colname>_MenuItemId can be used at the same time.
<colname>_LinkId
optional
int
Deprecated. Use <colname>_CellLink instead.
Creates a cell link with the specified link id for the <colname> cell.
PassingField_<xxx> columns can be referenced from the link.
Only one of <colname>_CellLink, <colname>_LinkId, <colname>_MenuItem or <colname>_MenuItemId can be used at the same time.
<colname>_MenuItem
optional
string
Recommended to use <colname>_CellLink instead for better tracking of links.
Supplies a link to the menu item with the specified alias when used in conjunction with <colname>.
Only one of <colname>_CellLink, <colname>_LinkId, <colname>_MenuItem or <colname>_MenuItemId can be used at the same time.
<colname>_MenuItemId
optional
int
Deprecated. Use <colname>_CellLink or <colname>_MenuItem instead.
Supplies a link to the menu item with the specified menuitemid when used in conjunction with <colname>.
Only one of <colname>_CellLink, <colname>_LinkId, <colname>_MenuItem or <colname>_MenuItemId can be used at the same time.
<colname>_PassingFields
optional
string
Supplies the querystring when used in conjunction with <colname>_MenuItemId.
<colname>_Style
optional
string
Sets the CSS style for <colname>. Never use a string from a user as part of this column for security reasons.
<colname>_Tooltip
optional
string
Sets the tooltip for <colname>.
PlaintextFull, PlaintextLeft, PlaintextRight
optional
string
These columns are deprecated. Use either PlainText, Html or SafeHtml instead, depending on what behavior you need.
The content of this column will be treated as Html, but line breaks and non-breaking spaces will be converted to br-tags. In future versions this column will be escaped.
PlainText
optional
string
Displays plain text without a column title, i.e. occupies the entire vertical space available in the box. Any HTML in the text will be escaped.
Html
optional
string
Displays HTML without a column title, i.e. occupies the entire vertical space available in the box. Uses the Layouted HTML level to determine allowed elements and attributes.
If the Html column is too restrictive for your needs then use the SafeHtml column instead.
SafeHtml
optional
string
Displays HTML without a column title, i.e. occupies the entire vertical space available in the box. Uses the Safe HTML level to determine allowed elements and attributes.
The SafeHtml column is less restrictive than the Html column. Use it only when you need it.
WarningSuccess
optional
string
The text will be at the top of the menu item and displayed in green.
WarningInfo
optional
string
The text will be at the top of the menu item and displayed in blue.
Warning
optional
string
The text will be at the top of the menu item and displayed in yellow. This will match any column prefixed with Warning that is not WarningSuccess, WarningInfo, and WarningError.
WarningError
optional
string
The text will be at the top of the menu item and displayed in red.
WarningLink
optional
string
Displays the link with the specified alias inside the warning.
Columns named PassingField_<xxx> will not be shown in the box and can be referenced from the link as a Column value with name <xxx>.
Requires that the row only contains one warning.
StartExpanded
optional
bit
Whether the infobox should start expanded or collapsed. NULL/Omitted means default behavior, where all boxes are expanded on big screens, and only the first box is expanded on small screens.
ExternalEmbedHeight
optional
int
Used together with the ExternalEmbedUrl column to set the height (in pixels) of the generated frame.
ExternalEmbedUrl
optional
string
Embeds content from an external server as an iframe in the infobox. The URL must be an absolute URL.
Kpi
optional
string
Json to generate a kpi. See the documentation for the Detailview component for more details.
Meter
optional
string
Json to generate a row of meters. See the documentation for the Detailview component for more details.
PassingField_<xxx>
optional
string
Not shown in InfoSQL. The corresponding link should be of link type "Top link (InfoSQL)", "InfoSQL cell link" or "InfoSQL warning link", and one of its passing fields should have a value matching <xxx>, and be of type "Column value".
QrCode
optional
string
A QR Code will be rendered containing the text in the column.
To generate Swiss QR Code for digital payments, return an XML with the root attribute Type="Swiss". See example-XML in the documentation for the RTF Document component.