
Federated tasks lists: Common task attributes
In most cases, the names that are used for an attribute differ in saved searches and query tables. To ensure that query results can be federated, common task attributes provide a mapping of the saved search name to the query table name.
When you create a query table for Heritage Process Portal spaces in a federated environment, use the common attribute name for a property instead of the column name of the predefined database view. The following tables show how the common attributes map to the corresponding saved search names and query table names.
| Common attribute name | Name used in saved searches | Name in the TASK database view |
|---|---|---|
| ACTIVATED | Received Date | ACTIVATED |
| COMPLETED | Closed Date | COMPLETED |
| CONTAINMENT_CTX_ID | Instance ID | CONTAINMENT_CTX_ID |
| DUE | Task Due Date | DUE |
| KIND | N/A (derived from multiple columns) | KIND |
| NAME | Activity | NAME |
| ORIGINATOR | Sent From | ORIGINATOR |
| OWNER | Assigned to User | OWNER |
| PRIORITY | Task Priority | PRIORITY |
| STATE | Task Status (mapped) | STATE |
| TKIID | N/A (taskId) | TKIID |
| Common attribute name | Name used in saved searches | Name in the TASK_DESC database view |
|---|---|---|
| TAD_DISPLAY_NAME | Task Subject | DISPLAY_NAME |
| TAD_DESCRIPTION | N/A (taskNarrative) | DESCRIPTION |