Skip to main content
Version: 20.05

Using Txn attributes

In order to display Txn information in the UI, you will need to setup some mappings via dataIndex. The dataIndex is a Txn attribute in the underlying configuration that will be used as the value for the field.

Example

{
...
mappings: {
...
$primaryApplicant: {
label: 'Name',
dataIndex: 'properties["PrimaryName"]',
type: 'text',
},
...
}
...
}

Fallback DataIndex

In some cases you may want to define a fallback dataindex. Let's say you want to display in the table a value that is not available on certain Txn status. You can define a list of dataIndexes that will be checked in case the first value is not there. e.g:

{
...
mappings: {
...
$primaryApplicant: {
label: 'Name',
dataIndex: ['properties["PrimaryName"]', 'formDataMap["PrimaryName"]'],
type: 'text',
},
...
}
...
}

Below you will find a list of attributes and supported operations that can be used within Workspaces configuration.

Criteria AttributeTypeSupported operationsDescription
authStatusStringSelection, Filter, SortFilter transactions based on the authStatus of the transaction
clientCodeStringSelection, Filter, SortFilter transactions based on the clientCode
emailAddressStringSelection, Filter, SortFilter transactions based on the emailAddress associated with the submission.
formCategoryStringSelection, Filter, SortFilter transactions based on the form template version's association to the category specified
formCodeStringSelection, Filter, SortFilter transactions based on the form code of the submitted form
formDataMapObjectSelection, FilterFilter transactions based on an entry in the formDataMap. Supports exact match of value but not extract name.
Supported: "formDataMap[*] = 'Jane'"
Supported: "formDataMap['firstName'] = 'Jane'"
Supported: "formDataMap['firstName'] IN ('Jane', 'Doe')"
formNameStringSelection, Filter, SortFilter transactions based on the form name of the submitted form
formStatusStringSelection, Filter, SortFilter transactions based on transaction form status
groupNameStringSelection, Filter, SortFilter transactions based on the association with submission groups with names specified
milestonesStringSelection, Filter, SortFilter transactions based on submission milestones
propertiesObjectSelection, FilterFilter transactions based on submission properties. Supports exact match of both name and value for a single property per search.
Supported: "properties[*] = 'prop1Value'"
Supported: "properties['property1'] = 'prop1Value'"
Supported: "properties['property1'] IN ('prop1Value', 'prop2Value')"
spaceNameStringSelection, Filter, SortFilter transactions based on the association with spaces with name(s) specified
submitKeyStringSelection, Filter, SortFilter transactions based on the submission submitKey. Will match to one transaction record.
timeAbandonedStringSelection, Filter, SortFilter transactions based on the time abandoned timestamp in the format "yyyy-MM-dd", "yyyy-MM-dd HH:mm:ss" or
"yyyy-MM-ddTHH:mm:ssZ" (the returned date format)
e.g. "timeAbandoned > '2018-01-01'"
e.g. "timeAbandoned \< '2019-01-01 09:00:00'"
e.g. "timeAbandoned >= '2018-01-01T15:17:29+10:00'"
timeCompletedStringSelection, Filter, SortFilter transactions based on the time completed timestamp in the format "yyyy-MM-dd", "yyyy-MM-dd HH:mm:ss" or "yyyy-MM-ddTHH:mm:ssZ" (the returned date format)
e.g. "timeCompleted \< '2018-01-01'"
e.g. "timeCompleted = '2018-01-01 23:17:29'"
e.g. "timeCompleted > '2018-01-01T15:17:29+10:00'"
timeCreatedStringSelection, Filter, SortFilter transactions based on the time created timestamp in the format "yyyy-MM-dd", "yyyy-MM-dd HH:mm:ss" or "yyyy-MM-ddTHH:mm:ssZ" (the returned date format)
e.g. "timeCreated > '2018-01-01'"
e.g. timeCreated >= '2018-01-01 15:17:29'"
e.g. "timeCreated \<= '2018-01-01T15:17:29+10:00'"
timeRequestStringSelection, Filter, SortFilter transactions based on the time request timestamp in the format "yyyy-MM-dd", "yyyy-MM-dd HH:mm:ss" or "yyyy-MM-ddTHH:mm:ssZ" (the returned date format)
e.g. "timeRequest >= '2018-01-01'"
e.g. "timeRequest = '2018-01-01 15:17:29'"
e.g. "timeRequest >= '2018-01-01T15:17:29+10:00'"
timeSubmittedStringSelection, Filter, SortFilter transactions based on the time submitted timestamp in the format "yyyy-MM-dd", "yyyy-MM-dd HH:mm:ss" or "yyyy-MM-ddTHH:mm:ssZ" (the returned date format)
e.g. "timeSubmitted \< '2018-01-01'"
e.g. "timeSubmitted = '2018-01-01 15:17:29'"
e.g. "timeSubmitted >= '2018-01-01T15:17:29+10:00'"
timeUserLastModifiedStringSelection, Filter, SortFilter transactions based on the time user last modified timestamp in the format "yyyy-MM-dd", "yyyy-MM-dd HH:mm:ss" or "yyyy-MM-ddTHH:mm:ssZ" (the returned date format)
e.g. "timeUserLastModified \<= '2018-01-01'"
e.g. "timeUserLastModified = '2019-01-01 23:17:29'"
e.g. "timeUserLastModified > '2018-01-01T15:17:29+10:00'"
trackingCodeStringSelection, Filter, SortFilter transactions based on the tracking code. Will match to one transaction record.
userLoginNameStringSelection, Filter, SortFilter transactions based on the user login name
userSavedBooleanSelection, Filter, SortFilter transactions based on the user saved property
True: "userSaved = 1"
False: "userSaved = 0" and/or "userSaved = null"
job.jobRefNumberStringSelection, Filter, SortFilter transactions based on job reference number
job.timeCreatedStringSelection, Filter, SortFilter transactions based on job creation time
job.timeLastModifiedStringSelectionSelect job time value for the transaction
job.jobKeyStringSelectionSelect job key value for the transaction
job.nameStringSelectionSelect job name value for the transaction
job.currentActionStringSelectionSelect job's current action for the transaction
job.currentStepStringSelectionSelect job's current step for the transaction
job.statusStringSelectionSelect job's status for the transaction
job.timeCompletionScheduledStringSelectionSelect job's completion schedule time for the transaction