Configure table service attributes

In the Management Portal at Service Catalog, on the Attributes tab of the service page, 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 service attribute. In a workflow action, this makes it easier to provide values based on the device that is used. Table service attributes are also very useful in integrations with third-party solutions like Mobile Device Management (MDM) systems.

Configuration

Field

Explanation and Tips

Table columns

Specify columns and values manually.

  • On the Columns tab, specify the columns of the table. You can add a maximum of 32 columns.
  • Select the check boxes in the Required column to specify mandatory columns.
  • Select the check boxes in the Restricted Information column to mask the column values in the Management Portal. This ensures you can be compliant with the privacy laws of your country or organization, as unauthorized administrators do not have access to private information like e-mail addresses, phone numbers, social security numbers, etc. This functionality applies to the Management Portal only; restricted information is still shown in the Web Portal.
    • Authorized administrators see the icon Eye-outline-vector-256-256 for restricted attributes and their placeholders. They can click this icon to view their value. These values are hidden again when the page is refreshed. This prevents situations in which unauthorized administrators can view restricted information by shoulder surfing authorized administrators. Where appropriate, a button is available to view ALL restricted attributes at once.
    • Unauthorized administrators see the icon Evil eye for restricted attributes and their placeholders. At Transactions, restricted attributes are shown as [attributename]. Although unauthorized administrators cannot see the attribute value, this still allows them to verify if the context or definition of the attribute is correct.
    • You can set administrative permissions on this functionality.
  • On the Initial Value tab, specify the default values of the table rows.
    • You can specify separators in input values:
      • Pipe-characters ("|") are changed to a capital i ("I").
      • Semi-colons (";") are changed to a colon (":").
    • You can add a maximum of 512 rows.
    • The value is limited to 2000 characters.
    • You can use placeholders to specify values. This allows you to configure services that dynamically resolve the values of table service attributes. For example, you can use a person attribute as a label in a table service attribute. During the service transaction, this person attribute then resolves dynamically depending on the person that requests or subscribes to the service. This allows you to use personalized options in the table.
      • If you use placeholders to specify values, they need to resolve in unique values. If multiple placeholders resolve in the same value, only one value will be added to the table.
  • If you first link the service attribute to another one, and then select Table columns, the table of the other service attribute is "copied". This makes it easier to create a new table.
  • You can add a maximum of 32 columns.

Copy from global attribute of type Table

Base the columns and values on a table global attribute.

  • The Preview contents area shows a read-only view of the columns of this global attribute.
  • The initial values are the values of the global attribute.

Copy from people attribute of type Table

Base the columns and values on a table people attribute.

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

Copy from service attribute of type Table

Base the columns and values on another table service attribute.

  • The Preview contents area shows a read-only view of the columns and values of this service attribute.
  • The subscriber to the current service must already subscribe to the other service before the values of its service attribute can be resolved.

Placeholders

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

For example, if you have configured a table service attribute MyDevices 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

#Service[SA Table.FullTable]

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

Example

#Service[MyMobileDevices.FullTable]

Returns

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

 

Get the values of the current row

Command

#Service[SA Table.CurrentRow.FullRow]

Note: Column values are separated with “;”

Example

#Service[MyMobileDevices.CurrentRow.FullRow]

Returns

123-123-1234;S4;Phone;Android;8008937810;Active

 

Get the values of a column of the current row

Command

#Service[SA Table.CurrentRow.C1]

Example

#Service[MyMobileDevices.CurrentRow.UUID]

Returns

123-123-1234

 

Get the values of a table column

Command

#Service[SA Table.EntireColumn.C1]

Example

#Service[MyMobileDevices.EntireColumn.UUID]

Returns

123-123-1234

123-123-1235

 

Get the number of rows of a table

Command

#Service[SA Table.Number of rows]

Example

#Service[MyMobileDevices.Number of rows]

Returns

2

 

Get the description of the table

Command

#Service[SA Table.Description]

Example

#Service[MyMobileDevices.Description]

Returns

"This table shows the mobile devices of the subscriber"

See also

Was this article useful?    

The topic was:

Inaccurate

Incomplete

Not what I expected

Other