Database View Creation and Report Configuration

[SambitRath]

All,

Wanted to create a database view for the specific Request items which have skipped approvals in the workflow

and provide the report access to the user.

Thought of joining requested item, Workflow Context and Workflow History to create that view.

Request to share the steps in detail please basically in the conditions where I have to match the fields 

Thanks

[pavani_paluri]

Hi @SambitRath ,

You want a report that shows request items where an approval step in the workflow was skipped. To do that, you need to connect three pieces of information:

Request Item (RITM) – the actual request.
Workflow Context – the workflow run that belongs to that request.
Workflow History – the log of each step in that workflow, including approvals.

That gives you a list of RITMs that had skipped approvals.

Go to System Definition > Database Views.
Create a new view and add the three tables: `sc_req_item`, `wf_context`, `wf_history`.
Define the joins:
-sc_req_item.sys_id = wf_context.context_id
-wf_context.sys_id = wf_history.context
Add a condition on wf_history.state = skipped or check the backend value of state.
Choose the fields you want to show (like RITM number, short description, workflow name, approval activity, etc.).
Save the view and use it as the data source for a report.

Please verify the backend field names and values.

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for

Kind Regards,

Pavani P

[SambitRath]

Hi Pavani,

Thanks for your reply .It partially succeed for me ,But while I am trying to join the workflow history Then I am not getting blank details in the report .Please find the  details of the conditions as screenshots and provide your input for the same.

Thanks,

Sambit

[SambitRath]

HI Pavani,

Any update from your end please.