Table name schedule/task data
We use scope manager to launch business processes. I am trying to add to a data view what the current task is (per the schedule) and who it is assigned to.
I have found this data (using auburn_sys_task,& auburn_sys_user_info ). Where i am having trouble is linking the active task back the schedule.
For example, my query is returning ALL active tasks for the project, not just those that were generated from the schedule.
For the purposes of this report -- i only want to display the active task that is linked to the schedule.
Can anyone help me with this? I have been trying to find a link between auburn_sch_task (which contains the schedule data) with auburn_sys_task -- but can't seem to find a common key.