Skip to content

Column

Optional XML element with column options

XML
1
<itm model="column" type="timg" name="logo">/api/files/26EFEED6-CDEF-E911-80DA-9C8E994DC647.png</itm>

convert to img tag in system UI

Attributes

Required

  • name, required

Optional

  • lg - (true/false) show/hide column on desktop
  • sm - (true/false) show/hide column on mobile
  • ex - (true/false) show/hide column on export for example excel
  • title title for name example title="{invoiceFullNR} {printoutName}"
  • text URL /item/{anycolumnname}/{anycolumnname}?app_name=[[app_name]]&amp;columnx1={columnx1},
    • server side variables [[variable]] are available see server side variables
    • IMPORTANT server side variables will be replaced with empty string if not found
    • Warning & need to be replaced with &amp;
  • label - label
    • server side variables [[variable]] are available see server side variables
    • IMPORTANT server side variables will be replaced with empty string if not found
  • required true/false
  • type see section Column type
  • acl column permission
  • css custom class - see xd.css https://kotynia.github.io/xd-css/
  • width column width
  • opts
    • uiinline - render inline component in row
    • uianonymize - when role uianonymize assigned sensitive information are removed
    • uisum - total in table footer
    • global-on - Information: column configuration was inherited from global configuration global.xml
    • lg-auto - lg set to false when column is empty
    • lg-true, lg-false - override desktop visibility, can be setup through Business logic in srssetup
    • sm-true, sm-false - override mobile visibility, can be setup through Business logic in srssetup

Column type

Autodiscover

List of autodiscover types from database schema

  • tguid
  • tdate - date . On the client, the UTC offset is applied to convert it to local time
  • tbool - Boolean
  • tinteger - Integer, example 2
  • tdecimal - Decimal, example 2.02
  • tstring

UI types

  • tdatetime - date with time DD/MM/YYYY HH:mm . On the client, the UTC offset is applied to convert it to local time
  • tinput_number - input number
  • tinput_text - text
  • tinput_bool - checkbox number
  • tlink - link
    • text value = url
    • if panull text value not link
  • tlink_frame - link , when ctrl key then modal
    • text value = url
    • if panull text value not link
  • tlink_modal - tlink_frame with default modal
  • tlink_tag - build tag link with color based on text
  • tlink_icon - internal link with icon font awesome 4 icon
  • tlink_download - dedicated for files download
  • tlink_icon_download_pdf - dedicated for download files pdf.
    • The downloaded file name can be set by column.title property.
    • only work for icons! Make sure you passed it in column.css
    • example use: <itm model="column" name="action" label="Drukuj" type="tlink_icon_download_pdf" title="{invoiceFullNR} {printoutName}" css="fa fa-print">{action}</itm>
  • tlink_post - send javascript object to url
  • turl_blank - external link in new window
  • tcolor_progress
  • turl_progress
  • tformat_bytes - Human readable size input bytes
  • tformat_k - Human readable size for large numbers, REturn 10K, 20M
  • ttag - build tag list with color based on text
  • tstring_multi -- multiline Text with Line breaks similar to HTML pre tag
  • timg - image
  • tmail email separated by space

server side transformation

  • tcolor, render hexadecimal color code based on text
  • tbase64 - server side base64 datastore image render return bytes
    • support : "jpg", "png", "jpeg", "apng", "webp", "gif" with optimization, optional w,h,o - width,height,option, default w=400
    • example item 00000000-0000-0000-0000-000000000000.png?w=400
  • tbarcode - server side barcode returns bytes , can use width attribute and opts="label" to display label
  • tqrcode - server side qrcode returns bytes
  • tmarkdown, renders markdown to html
  • tjson, renders xml to json s

Special column names

  • pa_background Hexadecimal color for background
  • pa_color Hexadecimal color for text

Examples

tlink tlink_modal tlink_frame,tlink_post

All link types require a URL IN text , in URL You can use:

  • row data, for example {planid} .
  • server side variables [[variable]] are available see server side variables
  • client side parameters are available {parameter} , which will be replaced with (in order of priority):
    1. client side parameters passed to the srs
    2. query string parameters
  • Warning & need to be replaced with &amp;
XML
1
2
<itm model="column" type="tlink_modal" css="xd-button" name="PlanDetails" label="-"><![CDATA[/srs/456-plan/view?planid={planid}&app_name=[[app_name]]]]></itm>
<itm model="column" type="tlink_modal" css="xd-button" name="PlanDetails" label="-"><![CDATA[/srs/456-plan/view?planid={planid}&datefrom=[[datefrom]]]]></itm>

tjson Examples

<Array force array output for single item (if not provided will return object)

Example 1

IN

XML
1
2
3
4
5
6
7
8
<ArrayOfFile>
  <file>
    <name>image001.png</name>
    <bytes>32674</bytes>
    <hash>550dc3bf-a1d2-e39b-58b1-56883453c2f0</hash>
    <extension>.png</extension>
  </file>
</ArrayOfFile>

OUT

  • force array output <Array
JSON
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
{
  "ArrayOfFile": {
    "file": [
      {
        "name": "image001.png",
        "bytes": "32674",
        "hash": "550dc3bf-a1d2-e39b-58b1-56883453c2f0",
        "extension": ".png"
      }
    ]
  }
}

IN

  • Warning json will be different for single itm node { "diff": { "itm": {} } } to avoid this prefix root with Array text
XML
1
2
3
4
5
<diff>
  <itm name="ID" old="a" new="b" />
  <itm name="DATE" old="" new="2025-03-11 00:00:00" />
  <itm name="LINEID" old="" new="b2401d60-ce9c-ef11-95b7-d89d6719e0cb" />
</diff>

OUT

JSON
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
{
  "diff": {
    "itm": [
      {
        "@name": "ID",
        "@old": "a",
        "@new": "b"
      },
      {
        "@name": "DATE",
        "@old": "",
        "@new": "2025-03-11 00:00:00"
      },
      {
        "@name": "LINEID",
        "@old": "",
        "@new": "b2401d60-ce9c-ef11-95b7-d89d6719e0cb"
      }
    ]
  }
}

timg images

Important notice ampersand (&) must be replace with & in attributes or you can use cdata section

XML
1
2
3
4
5
6
7
8
9
<itm model="column" type="timg" name="logo">/api/files/26EFEED6-CDEF-E911-80DA-9C8E994DC647.png</itm>
<itm model="column" type="timg" name="logo">/assets/images/logo.png?w=150</itm>
<itm model="column" type="timg" name="mail_to_avatar">/account/avatar/{mail_to_avatar}</itm>
<!--Example BARCODE-->
<itm model="column" type="timg" name="qr" width="100">/api/core/system/barcode?code={qr}&amp;type=code128</itm>
<!--Example BARCODE using cdata -->
<itm model="column" type="timg" name="qr" width="100"><![CDATA[/api/core/system/barcode?code={qr}&type=code128]]></itm>
<!--Example QRCODE-->
<itm model="column" type="timg" name="qr" width="100">/api/core/system/qrcode?code={qr}</itm>

turl_blank external linking

XML
1
2
3
4
<!--Redirect to external page-->
<itm model="column" type="turl_blank" name="test1">http://test.com/test?commisionID={commisionID}</itm>
<itm model="column" type="turl_blank" name="email">mailto:{email}</itm>
<itm model="column" type="turl_blank" name="phone">tel:{phone}</itm>

tstring_multi Text with Line breaks similar to HTML pre tag

SQL Server Example:

SQL
1
SELECT 'Hello' + CHAR(13) + CHAR(10) + 'World'

pa_background color for background

Used with 'var(--xd-green1)'

XML
1
2
3
4
5
6
7
8
9
<itm model="command" name="saleInvoiceDateSummary"><![CDATA[
select
  ROUND(sum(sysnetValue), 2) value,
  'RAZEM'  invoiceCategory,
  'var(--xd-green1)' pa_background
FROM
  saleInvoiceSummary 
]]>
</itm>

Used with hex value (e.g. '#112233') or column name from query (e.g.column_hex_example)

XML
1
2
3
4
5
6
7
8
9
<itm model="command" name="saleInvoiceDateSummary"><![CDATA[
select
  ROUND(sum(sysnetValue), 2) value,
  'RAZEM'  invoiceCategory,
  '#112233' pa_background 
FROM
  saleInvoiceSummary 
]]>
</itm>