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]

Hi Shembop,

Try wf_activity table.

Actually, in the filter box you can write wf_activity.list and get all work flow activities, then filter them...

harel

[shembop]

You would think, right?

But, when you go in, if you hover on the information icon you can see it, but if you enter the record, it is not there. I even tried to export to XML hoping it was just somehow hidden, No dice. I attached a video, as I am a visual person.

[oharel]

Hm...

I could not find the UI policy that's doing it. What version are you on?

Also, try this:

Press the SHIFT key and then move your mouse to the tooltip i. It should open the record in edit mode.

[shembop]

We are on Helsinki currently. I did use the shift key to look at the record. The problem on not finding it in a table view is I can't do a search on the field to filter down and find all activities that have the same script action. The goal is to be able to, from a list view, find all activities that may have an issue. We had a painful circumstance where we had a script that needed to be updated, and we had to go into every workflow, and every activity to confirm that we had fixed the script. I don't want to do that again..... ever.