Configure table global attributes

In the Management Portal at Data Model > Global Attributes, configure Global Attributes. Configure table attributes to store multiple rows of data in a table structure.

For example, because people may use multiple devices when they interact in your environment, it can be useful to store data about these devices in a single table global attribute. When you use it in a workflow action, it becomes easier to provide values based on the device that is used. This is also very useful in integrations with third-party solutions like Mobile Device Management (MDM) systems.

Properties tab

In the Table Columns area, specify the columns in the table.

  • Select the check boxes in the Required column to specify mandatory columns.
  • Click the arrows to configure the order of the columns.
  • You can add a maximum of 32 columns.
  • You can click Pause Transactions to export information to a CSV file.

Optionally, after you have created the table attribute, you can create a data connection to fill the table. Once a data connection has been created:

  • the icon is displayed next to the attribute name, in the list on the Global Attributes page.
  • the Data connection name is displayed on the attribute details page.

After you have saved a table global attribute for the first time, its layout becomes read-only. You can change the Required setting, but you cannot add, delete or rename columns.

Value tab

Specify the default values of the table rows.

  • You can add a maximum of 512 rows.
  • The value is limited to 2000 characters.

Placeholders

Use the following commands to retrieve values from the table, for use in workflow actions and in other attributes.

For example, if you have configured a table global attribute Devices with the following values:

UUID

FriendlyName

Type

OS

PhoneNumber

Status

123-123-1234

S4

Phone

Android

8008937810

Active

123-123-1235

iPad

PDA

iOS

 

Wiped

Use the following commands:

Get the values of the entire table

Command

#Global[{attributename}.FullTable]

Note: Column values are separated with “;”, rows with a “|”.

Example

#Global[Devices.FullTable]

Returns

123-123-1234;S4;Phone;Android;8008937810;Active|123-123-1235;iPad;PDA;iOS;;Wiped

 

Get the values of a table column

Command

#Global[{attributename}.EntireColumn.{columnname}]

Example

#Global[Devices.EntireColumn.UUID]

Returns

123-123-1234;123-123-1235

 

Get all values of the selected table row

Command

#Global[{attributename}.CurrentRow.FullRow]

Remark

If you use this placeholder in a Perform Table Operation action, this resolves the values of the table selection that was made during the service transaction.

Example

#Global[Devices.CurrentRow.FullRow]

Returns

123-123-1235;iPad;PDA;iOS;;Wiped

 

Get the value of a specific column in the selected table row

Command

#Global[{attributename}.CurrentRow.{columnname}]

Remark

If you use this placeholder in a Perform Table Operation action, this resolves the value of a specific column of the table selection that was made during the service transaction.

Example

#Global[Devices.CurrentRow.OS]

Returns

iOS

 

Get the number of rows of a table

Command

#Global[{attributename}.Number of rows]

Example

#Global[Devices.Number of rows]

Returns

2

 

Get the description of the table

Command

#Global[GA Table.Description]

Example

#Global[MyMobileDevices.Description]

Returns

"This table gives an overview of the available mobile devices."

See also