Trying to find the table that has Workflow item scripts

[shembop]

We have items in our workflow scripts that I want to try and find and correct.What we have tried to do is find in what table the Advance field is housed for workflow items. This would allow me to find every item where we referenced the old field in a script.

[oharel]

I'm on Helsinki too and I have the script part you are missing.

Maybe open a HI incident. And in the meantime, have fun with cjmartin 's suggestion

harel

[Chris M3]

I don't actually do it that way, I developed a search tool that I unfortunately can't share that does all that work for me.

[shembop]

Could you send me screen shots showing? That may help get the HI ticket working. We have had issues in the past because of starting way back in Berlin where we were missing plugins that only HI could turn on for us.

[oharel]

Sure!

Here you go:

[Chris M3]

Workflow variable values are stored in the sys_variable_value table.

Look for document = wf_activity, and then value contains what you are looking for.

Note, this won't give you the workflows.   Plus it will give you unpublished versions also.   No way to dot-walk.

Once you have these, take the document_key field from the results, then search the wf_activity for those sys_id's.   You can then filter by published and see the workflows and activities in the workflow that need to be touched.

Yes it's a pain.