Mapping attributes to create a report for Tasks
Hi,
I am trying to create a report that returns a list of task with the following columns:
- Work Item
- Created On (Date)
- Initiated by
- Task Due Date/Deadline - found under Task > Template View > Deadline
- Object Priority - found under Task > Template View > Priority
- Task Name
- Trip Count
- Accepted date - found under Task > Task History > Performed On
- Completed By
- Date Completed - found under Task > Process Status > Date Completed
- State
- Context
- Last Modified
I have been able to narrow down the type/tables these properties are coming from but I am having trouble matching them to the correct attribute.
The Resource for reporting was very helpful but I was not able to find mapping for some of these properties.
I also used jcaDebug=1 to gather detail information. This helps me narrow down the table but it does not help map the attribute. ColumnID value doesnt match to an attribute name in the type/table/Row Object.
If you have any resources to show the relationships between tables/types and how to link them, that would be great. For example, what is the best way to link WfAssignmentEventAudit to obtain the actionPerformedOn value for a task?
TIA!