question Re: Searching the script field(s) of workflow activities in Developer forum

Searching the script field(s) of workflow activities

Michael Domke — Thu, 11 Jul 2013 22:06:48 GMT

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

Re: Searching the script field(s) of workflow activities

Michael Domke — Fri, 12 Jul 2013 12:29:34 GMT

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.

Re: Searching the script field(s) of workflow activities

Kalaiarasan Pus — Tue, 13 May 2014 11:56:53 GMT

this was a life saver today thanks

Re: Searching the script field(s) of workflow activities

Jace Benson — Thu, 09 Oct 2014 16:04:38 GMT

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

Re: Searching the script field(s) of workflow activities

Kalaiarasan Pus — Thu, 09 Oct 2014 16:18:30 GMT

This might help you. The inspiration was this post ofcourse

Workflow Script Searcher

Re: Searching the script field(s) of workflow activities

Sharique Azim — Fri, 26 Jan 2018 15:05:05 GMT

Hi Michael,

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

Re: Searching the script field(s) of workflow activities

lekskr — Mon, 19 Feb 2018 15:44:53 GMT

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

Re: Searching the script field(s) of workflow activities

mikegrynch — Thu, 26 Mar 2020 19:12:56 GMT

Seven years later and still providing value! Thank you sir! 🙂

Re: Searching the script field(s) of workflow activities

lekskr — Fri, 03 Apr 2020 21:41:47 GMT

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

Re: Searching the script field(s) of workflow activities

lekskr — Fri, 03 Apr 2020 21:43:54 GMT

I agree 7 yrs later! I will share this tips with my team.

Re: Searching the script field(s) of workflow activities

lekskr — Fri, 03 Apr 2020 21:45:11 GMT

Thank you!

Re: Searching the script field(s) of workflow activities

Rajshekhar Pau1 — Tue, 16 Jun 2020 06:54:43 GMT

This is awesome, thank you so much.

Re: Searching the script field(s) of workflow activities

Sksunny6131 — Wed, 17 Jun 2020 11:27:15 GMT

awesome, thank you so much.

Re: Searching the script field(s) of workflow activities

seanphelan — Sun, 04 Jul 2021 14:25:47 GMT

This was a great solution. Just wanted I needed. But I did make some enhancements so I thought I would share

renamed ScriptUtils to WorkflowSearcherScriptUtils to me a more unique name
Added logic to the rendered results to include
Added the ability to search a specific workflow or search all published workflows

direct link to the workflow editor for this result
added a note if the workflow is currently checked out by someone else
is this workflow in an open update set for someone else
the table name the workflow is running on
What catalog forms will be affected so you can retest (and if its not active its red)
A code preview showing the line above and below the matched result

Re: Searching the script field(s) of workflow activities

Alex Bennett — Mon, 19 Jul 2021 19:43:56 GMT

Great tool. I had to modify the query in the WorkflowSearcherScriptUtils at line 30 to get it to work.

Not working:

cExist.addEncodedQuery('document=wf_activity^document=wf_activity^variable.elementLIKEcondition^ORvariable.internal_type.nameLIKEcondition^ORvariable.elementLIKEscript^ORvariable.internal_type.nameLIKEscript^valueLIKE' + searchText + '^document_key=' + wfActivities.getValue('sys_id'));

Working:

cExist.addEncodedQuery('document=wf_activity^valueLIKE' + searchText + '^document_key=' + wfActivities.getValue('sys_id'));

Re: Searching the script field(s) of workflow activities

Nagarjun — Fri, 30 Jul 2021 10:47:29 GMT

Below Script search all the workflows to find a keyword

//Use this Fix script to search workflows for a keyowrd

Re: Searching the script field(s) of workflow activities

Nagarjun — Fri, 30 Jul 2021 10:47:55 GMT

Below Script search all the workflows to find a keyword

//Use this Fix script to search workflows for a keyowrd

Re: Searching the script field(s) of workflow activities

maricielo — Thu, 12 Aug 2021 19:32:27 GMT

This is exactly what I need it. Thanks a lot!

Re: Searching the script field(s) of workflow activities

vikas_sakhare — Fri, 24 Sep 2021 06:38:31 GMT

Thanks @Michae, This is a really helpful solution.

Re: Searching the script field(s) of workflow activities

jdestef — Tue, 19 Oct 2021 14:26:02 GMT

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