We have a portlet with action item status that relies on processes. Unfortunately, we're getting records of all approvers of a timesheet instead of the approvers on a single time entry.
We're doing a join where bpm process id is joining to the prtimeentry table based on the timesheet id.
bpm_run_objects.object_id = prtimeentry.prtimesheetid
What this does is that it shows us all of the approvers of a timesheet but not the time entry approver.
Is there a way to join the process based on the timeentry id, instead? So that we don't get multiple approvers for a timeentry line? Any good queries out there with the BPM tables to Timeentry table?
Thanks