[dave.gilbert]

I’d like to set up a NetSuite saved search that can accept filter criteria in a more convenient way.

For example, let’s say that Marketing wanted to search for all of your customers who are within one of five zip codes in a particular city. And then, the next day they want to search for all customers within one of 15 zip codes surrounding a larger city.

Because there’s no way to specify logical OR criteria within one criteria line, each zip code has to be named individually on its own criteria line. Someone would have to go in and manually change the search criteria, line by line, to make the search work for the new group of zip codes.

What are your suggestions for automating the process of building the search? I’m thinking Suitelet as a front end, passing values to a script that in turn runs the search. What would you do?
This is a cached copy. Click here to see the original post.

[evan_goldberg]

RE: Clean "front end" for complex NS search?

That’s probably the best way to go. In 2012.1 we will (tentatively) have an API for building up (with or without saving) a saved search, and (tentatively) as part of that you will be able to go directly to the search results for that search, so that may end up being the best way to go.

Thanks,

-e

[dave.gilbert]

Thanks, Evan!!

[Author]

Posts