Hi, I have this script that use a filter array. Ho...
# suitescriptt
Tyn Guardian
03/26/2024, 12:26 PMHi, I have this script that use a filter array. However, I want the filter to have a "OR" statement at the end. BUT this is not working. Any ideas 🤔
Copy code
filters[0] = new nlobjSearchFilter("type", null, "anyof", 'Custom110') + "AND,";
filters[1] = new nlobjSearchFilter("postingperiod", null, "abs", "389" ) + "OR";
filters[2] = new nlobjSearchFilter("postingperiod", null, "abs", "390");s
Stefan Reeder
03/26/2024, 12:32 PMThere's a much easier way to build your filters:
Copy code
filters.push(["type","anyof","Custom110"]);
filters.push("AND");
filters.push([["postingperiod",null,"abs","389"],"OR",["postingperiod",null,"abs","389"]]);Stefan Reeder
03/26/2024, 12:33 PMNot sure about null/abs - what are you trying to do there?
t
Tyn Guardian
03/26/2024, 12:33 PMI just convert this search into script using a google add ons
Tyn Guardian
03/26/2024, 12:34 PMnull are join and abs is the search operator
s
Stefan Reeder
03/26/2024, 12:34 PMSuggest you get the chrome plugin "NetSuite:Search Export"
https://chromewebstore.google.com/detail/netsuite-search-export/gglbgdfbkaelbjpjkiepdmfaihdokglp?pli=1
Stefan Reeder
03/26/2024, 12:34 PMWith this plugin your can click a link to see the "scripted" version of your current search
Stefan Reeder
03/26/2024, 12:35 PMIt's an incredible time-saver for scripting searches... build it in the UI and get the code for it
Stefan Reeder
03/26/2024, 12:36 PM Copy code
filters.push(["type","anyof","Custom110"]);
filters.push("AND");
filters.push([["postingperiod","anyof","389"],"OR",["postingperiod","anyof","390"]]);Stefan Reeder
03/26/2024, 12:36 PMThat should do the trick
Stefan Reeder
03/26/2024, 12:37 PMExpressions are much easier than using the
new nlobjSearchFiltert
Tyn Guardian
03/26/2024, 12:39 PMYeah I couldn't agree more on the add ons. However, my plan is to get the posting period dynamically that is why I wanted to isolate the filter per index array
s
Stefan Reeder
03/26/2024, 12:39 PMjust use variables in the search
🤔 1
t
Tyn Guardian
03/26/2024, 12:39 PMBTW, still getting an error on the script you shares sadblob
s
Stefan Reeder
03/26/2024, 12:40 PMyou don't need the OR then. Pass an array of internal ids into a function
Copy code
var accounts = ["389","390"];
filters.push(["type","anyof","Custom110"]);
filters.push("AND");
filters.push(["postingperiod","anyof",accounts]);Stefan Reeder
03/26/2024, 12:43 PMTry this method (if it's a transaction search)
Copy code
var accounts = ["389","390"];
filters.push(["type","anyof","Custom110"]);
filters.push("AND");
filters.push(["postingperiod.internalid","anyof",accounts]);t
Tyn Guardian
03/26/2024, 12:46 PMthis one actually works thankyou so much!!!
🙌 1
🎉 1
s
Stefan Reeder
03/26/2024, 12:47 PMno problem
8 Views