BPM workflow future approval not visible in wftask,wftaskhistory
Summary:
BPM workflow future approval not visible in wftask,wftaskhistory
use case: once job requisition submitted, it went for multiple approval.
We are creating report which show all approver name and status and approved date in excel using BIP report but not able to findout future approvers in table.
Thank in advance.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
WITH req AS (
SELECT
rb.requisition_id,
rb.requisition_number,
rtl.title AS requisition_title,
rb.creation_date,
rb.approved_date,
rb.object_status,
ph_tl.name AS current_phase,
st_tl.name AS current_state,
0