Mahjooob
Rookie

Best way for action history

Hi,

 

what is the Best way to save the action history for the workflow actions in business tables

 

0 Kudos
Reply
4 Replies
Prineel
Scout

Re: Best way for action history

Hi @Mahjooob,

 

If you are using sql, I am 99% sure that workflow actions are saved there. If you are not, or want to save it in your own tables, I would recommend that you create a new smart object to store a workflow action log and in your workflow, use the SmartObject Method after each action to save an action into your “log” smartobject. Let me know if you want screenshots of how to do so.

 

Kind Regards

Prineel

Reply
Mahjooob
Rookie

Re: Best way for action history

Prineel wrote:

Hi @Mahjooob,

 

If you are using sql, I am 99% sure that workflow actions are saved there. If you are not, or want to save it in your own tables, I would recommend that you create a new smart object to store a workflow action log and in your workflow, use the SmartObject Method after each action to save an action into your “log” smartobject. Let me know if you want screenshots of how to do so.

 

Kind Regards

Prineel

actually, I'm using SQL server but I have no access to k2 database, I'm using now the smo to save the log but I face some discrepancy here.

 

 

0 Kudos
Reply
Prineel
Scout

Re: Best way for action history

Hi @Mahjooob ,

 

Ive created a small Log:

65a123dd-ce3e-40bd-81b9-7d33475da117.png
This is the SmartObject (can be way more detailed)
8c0b55dc-bfc7-4ef0-9932-3db021fbc4e1.png
This is how my workflow looks (The 2 smart object methods are to save data into the log)
823c25a0-23c4-4cd3-b360-01e9e470ae52.png
This is how I saved it, but you can also use the “Step Name” (as shown in the next image) which will save the SmartObject’s method name
ea6797d3-fa35-4717-94bd-8590403c4285.png
Under the Workflow tab on the right, there are a lot of useful details with regards to the workflow, people using it and its steps that you can use to create a detailed log
78e6bff4-fd30-47e9-9626-3b57818b10e2.png
I created a listview and configured the Date Time Format to display the date and time (Short DateTime) 

Feel free to share your discrepancies if this post didn’t help, as we might help you find another solution/workaround :)

 

Kind Regards

Prineel

0 Kudos
Reply
Mahjooob
Rookie

Re: Best way for action history

Dear @Prineel 

thank you that is really cool

 

BR

0 Kudos
Reply