How to retrieve workflow status (rejected or approved.) : Portal

W

Wijden Dahmen

started a topic 10 days ago

Hello,

I would like to retrieve the status of a workflow launched by Semarchy.

I want to know if the request has been rejected or approved.

Example: a user initiated a workflow to create a perfume.

The data steward rejected the creation of this perfume.

How do I retrieve that the creation of this perfume has been rejected

Thank you

Best Answer

T

Toshish Chauhan said 10 days ago

Hlo Wijden,

In My Tasks we have My Workflows tab when we click here on that all workflows list appears and when we click on any workflow a side tab will arrive in which we can see the history or lifecycle of workflow.

T

Toshish Chauhan

said 10 days ago

Answer

Hlo Wijden,

In My Tasks we have My Workflows tab when we click here on that all workflows list appears and when we click on any workflow a side tab will arrive in which we can see the history or lifecycle of workflow.

W

Wijden Dahmen

said 10 days ago

Hello Toshish,

Thank you for your quick reply. Where can I find this information in the repository and API?

T

Toshish Chauhan

said 10 days ago

Hlo Wijden,

In Db side you can find it in wf_step_instance table. You can use this query to retrieve Discard or rejected product :-

select * from wf_step_instance where selected_transition_name = 'DiscardProduct';

For approved product you can use this query :-

select * from wf_step_instance where selected_transition_name = 'SaveToxDM';

W

Wijden Dahmen

said 10 days ago

Thank you :)