What's new in Customer Journeys?

Connect and learn more! ×
Need query/Table details to fetch the Status details like the Number of a Task of Flow pattern — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need query/Table details to fetch the Status details like the Number of a Task of Flow pattern

Received Response
64
Views
20
Comments

we used the following query but its showing only the Total count, but not the details like success/error count . attached the screenshot showing the same.

Query

=====

SELECT

fti.*

FROM

pay_flow_task_instances fti,

pay_flow_tasks_vl ft,

pay_flow_instances pfi

WHERE

1 = 1

--FTI.STATUS = 'SCHEDULED'

--AND PFI.STATUS = 'SCHEDULED'

AND fti.base_flow_task_id = ft.base_flow_task_id

AND pfi.flow_instance_id = fti.flow_instance_id

--AND FTI.SCHEDULED_DATE IS NOT NULL

AND pfi.instance_name = 'GS Payroll Flow 29OCT'

AND flow_task_name = 'Calculate Payroll'


Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!