Is there any way, using either saved searches, dat...
# suiteanalytics
s
Is there any way, using either saved searches, datasets, or SuiteQL, to do a search or query of all workflow actions? I want to find all Send Email actions across 400+ workflows, in the most efficient way possible.
j
I periodically export the XML of all my workflows, and save them to my WebStorm & upload to Bitbucket. Then I can search for the save eamil action
🙌 1
✔️ 1
Copy code
// Bring up list of all Workflows.  Exclude those from bundles, and inactive WFs.
// Export, make array of all ids.  E.g. var wfids = [1, 2, 3];
// Then, run this script in browser console while logged into NetSuite.

// Replace this with your list of ids.
let wfids = [1, 2, 3];

// Replace this with your NS account id.
let accountid = 12345;

for(var i = 0; i < wfids.length; i++) {

	let link = document.createElement("a");
	link.href = 'https://' + account_id + '.<http://app.netsuite.com/app/suiteapp/devframework/xml/xmlexport.nl?&recordtype=workflow&id=|app.netsuite.com/app/suiteapp/devframework/xml/xmlexport.nl?&recordtype=workflow&id=>' + wfids[i];
	link.target = '_blank';
	document.body.appendChild(link);
	link.click();
	document.body.removeChild(link);
	console.log('downloading ' + link.href);


}
something like this, you can run in console
s
I think this is the only possible solution (based on other feedback I got), so SDF/XML it is! Thanks for the suggestion, at least I can search the XML files for the actions and settings I need.
j
bonus points: this creates a backup of your workflows in case you accidentally delete or change/break one
💯 1
👍 1
m
Have you looked at Salto? You can do this (pull all objects, text search in SDF definitions) using their free tier.
s
Not yet, but I'll check into that too. For now I was able to get what I needed relatively efficiently