Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Data table for workflow history

Joon
Regular Contributor II
Regular Contributor II

Hello Folks,

I would like to get histories about workflow's changes.

Can you please let me know Which table I can refer to get the history ?

5 REPLIES 5

naveenss
All-Star
All-Star

Hi @Joon  refer to "workflowupdatehistory" table to fetch this data. 

 

Regards,
Naveen Sakleshpur
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

Manu269
All-Star
All-Star

use the table workflowupdatehistory.

You need to use the analytics as seems this is not available on data analyzer

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

Joon
Regular Contributor II
Regular Contributor II

workflowupdatehistory-

This is what I got for the query statement below

select * from workflowupdatehistory

Joon_0-1692360763259.png

Could I get the column names from the table, So I can put them in select statement ?

Hi @Joon  below are the attributes in the table. 

select WORKFLOWHISTORYKEY,CHANGELOG, UPDATEDATE as 'Updated On',UPDATEDBY,WORKFLOWKEY from workflowupdatehistory;

Another version of the query:

select wupd.WORKFLOWHISTORYKEY,wupd.CHANGELOG, wupd.UPDATEDATE as 'Updated On',u.username as 'UPDATED BY',w.wfname as 'Workflow Name' from workflowupdatehistory wupd, workflowhistory w, users u where wupd.WORKFLOWKEY=w.WORKFLOWKEY and u.userkey=wupd.updatedby;

 

 

Regards,
Naveen Sakleshpur
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

Hi @Joon ,

Try below query

Select CHANGELOG, UPDATEDATE as WFUpdateDate, UPDATEDBY, WORKFLOWHISTORYKEY, WORKFLOWKEY from workflowupdatehistory

Below is the list of attributes in workflowupdatehistory table:

CHANGELOGlongtextYES   
UPDATEDATEdatetimeYES   
UPDATEDBYbigint(20)YESMUL  
WORKFLOWHISTORYKEYbigint(20)NOPRI auto_increment
WORKFLOWKEYbigint(20)NOMUL

Pandharinath Mahalle(Paddy)
If this reply answered your question, please Accept As Solution to help other who may have a same problem. Give Kudos 🙂