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.

Configuration

Field

Explanation and Tips

Properties tab

Specify the columns in the table.

  • In the Table Columns area, add columns to 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.

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.
  • The Preview contents area shows a read-only view of the columns of this people attribute.
  • The initial values are the values of the subscriber's people attribute.

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."


Was this article useful?    

The topic was:

Inaccurate

Incomplete

Not what I expected

Other