Searching the script field(s) of workflow activities

[Michael Domke]

Is there a way to search the various script fields in workflow activities? I need to verify the use of certain table/field uses in workflow activity scripts.

For example, search all workflow activity scripts to see which ones contain "u_software" somewhere in the script. To do this manually will be very time consuming as well as the potential for blurry eyed oversight mistakes.

Thanks,
Michael

[Michael Domke · Accepted solution]

To benefit others:

Yes, you can do this search.
1) In the Navigator filter box, type sys_variable_value.list <-- This takes you to the table to search
2) Click on the Filter wizard icon to create a custom filter
--- Table (document) is wf_activity AND
--- Variable.Column Name contains script' OR
------ Variable.Type.Name contains 'script' AND
--- Value contains [whatever you are searching for]

Although, I could not find Variable.Type.Name in the filter wizard. Variable.Type didn't show to have any related fields.

[Kalaiarasan Pus]

this was a life saver today thanks

[Jace Benson]

This also save me a bunch of time.   Thank you!

[shariq3]

Hi Michael,

Can we find the table   of the workflow or the name of the workflow from this table 'sys_variable_value'