Start a new topic
Discussions xDM xDM - Model and Application Design
Answered

How to retrieve workflow status (rejected or approved.)

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

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.



4 CommentsSorted by Oldest First
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.



Hello Toshish, 


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



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';

Thank you :) 

Login to post a comment
More topics in xDM - Model and Application Design
See all 178 topics
Help Desk Software by Freshdesk