@vilaspadole Load the search in the script then use addFilter In the help this example is shown:- var newSearch = nlapiLoadSearch('opportunity', 'customsearch_kr'); // Call addFilter to add an additional filter to the existing search var newFilter = new nlobjSearchFilter('somefilter'); newSearch.addFilter(newFilter);

so a) load search, b) define new filter c) loadedsearch.addFilter(newly_defined_filter).

@vilaspadole If you are adding multiple, use an array of filters and addFilters: var newSearch = nlapiLoadSearch('opportunity', 'customsearch_kr'); // Define additional filters to the existing search var newFilters = new Array(); newFilters[0] = new nlobjSearchFilter('somefilter'); newFilters[1] = new nlobjSearchFilter('somefilter1'); newFilters[2] = new nlobjSearchFilter('somefilter2'); // Call addFilters to add filters to the existing search newSearch.addFilters(newFilters);

i want to add filter as date_created = 26022018...but as this is string parameter need to convert it to date

format will want to be like this:

var customrecord_blt_supplier_volumetricsSearch = nlapiSearchRecord("customrecord_blt_supplier_volumetrics",null, [ ["custrecord_blt_sid_product_barcode","contains","E+"], "AND", ["created","on","26/2/2018 11:59 pm"] ],

in an expression so I think the same applies in a filter

@vilaspadole in your case just 26/2/2018 BE AWARE it does NOT like leading zeroes note February is 2 not 02

@vilaspadole working with dates in SS1 can be a complete pain to be honest

oh ok...i will change 2 to 02 by padding 0 for single digit months

Thanks...will try

@vilaspadole I think you mean remove not pad

yes

how the heck do you filter on entity type? Not seeing it in the filters (through the UI) and want to see what values are available...

Would you perhaps need to join to entity to see the type?

@erictgrubaugh On Map Reduce in the getInput stage is possible to just iterate over an array without doing a search?

Why would I need to do that on an Entity search, the base record is entity? According to the records browser the Entity Type is a searchable field with an internal id of 'type'

I don't see why not

I feel sure in SS1 I have used the deployment id to ascertain the type to add to a saved search to pull back just customers / prospects etc. Since I cannot add a filter to a saved search in SS2 I was going to add a parameter on the deployment and create the search on the fly and jack in the "type" . Guess I'll have to handball the whole thing with a switch

You differentiate Customers, Prospects, and Leads using the

stage

filter

they are all considered Customer records

and you can add filters to saved searches in ss2

@alien4u Can you be a little more specific what you're trying to do? In general sure you can just iterate over an array in `getInputData`; do you mean you just want to return an Array instead of a Search?

Yeah just a hard code array it works and pass each element to map...

right

that's what it does

getInputData

always returns an Array, and each element of that Array gets passed individually to

map

, which in turn also returns an Array (although it looks different because you

context.write

instead of

return

), and each element of that Array gets passed individually to

reduce

in the event you return a Search from

getInputData

, that's just a convenience that NS runs the search for you

it's still returning an Array of search results