Searching the script field(s) of workflow activities

Michael Domke · ‎07-11-2013

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 · ‎07-12-2013

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.

View solution in original post

vikas_sakhare · ‎09-23-2021

Thanks @Michae, This is a really helpful solution.

jdestef · ‎10-19-2021

Can somebody update this? I dont see "Column Name" nor do I see "Variable.Type.Name" when trying to build this filter. On Quebec.

Kalaiarasan Pus · ‎10-09-2014

This might help you. The inspiration was this post ofcourse

Workflow Script Searcher

lekskr · ‎02-19-2018

I've upload the XML, how do I use it?

lekskr · ‎04-03-2020

I have use this tool as well, but it only allow me to search 1 workflow at a time.