This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hello Team,  How do I find out "All searches that use the current department field for an item."

You would have to write a script which creates a search for all saved searches, and loads the search, gets the columns, finds the existence of the column name, and then returns the search if it matches.

Sounds like a fun Suitelet project, but due to script governance, if you have a ton of saved searches, you’d probably have to create a map/reduce script, or find another way to offload the processing.

i was able to partial achieve the goal by doing this, and export it in excel.

yeah , its not the exact thing he was looking for but it's close enough without doing what you mentioned

was that also inclusive of private searches?

OK <@UMZJF3BCH> — I found a simple solution .. haha..
The “RESULT FIELD’ isn’t available in the native criteria field list, but it IS available in the formula fields, and it works just fine…

I created a Formula (Text) criteria row, and selected {result} is Department

works like a charm

only returns searches with that column included..

but department can be on transaction, entities and others so we only need for item it's kind of hard to see the join on transaction and entities so thats why i said it's not exact but its close enough

ah, gotcha.. yea, what is the purpose of this magical search anyway?

They want to see which searches uses departments because departments might be used for some other values so they want to transfer this values into the new field 