Hello, I have issues with my search.

function IsNewOrder(orderId) {
     s = search.create({
        type: search.Type.SALES_ORDER,
        filters: [search.createFilter ({ 
            name:'otherrefnum',
            operator: search.Operator.CONTAINS,
            values: orderId})],
        columns: ['otherrefnum']
    }).run().getRange({
        start: 0,
        end: 10
    });//should only be one
}

The filter seems to return the first line of all my list of record of Sales Order. It seems that the filter 'otherrefnum' doesn't match the parameter orderID that is a value I get by using getValue in a fieldChanged function. So I don't known why the search always return the first line of all my transaction and not the matching orderId. Have you ever have this issue before ? Thank you !

otherrefnum

is the

PO/Check Number

filter in the ui

@battk what operators should I use ? to do a search for duplicate of PO number in sales order ?

make your search in the ui first

How can I make my search in the UI ? I have to do a search.save() ?

make a transaction search un the ui

I don't understand what do you mean by converting the search to code ? I have to create a search on the saved search report then use the id of this search to do the search in my code ?

make the search in the ui first

ok so I have to save a saved search on my UI and then use it in my code that is it ?

i suspect you would know how to change the code after you learn how the filter works

ok

but if you don't, my recommendation is to load the search you created in the ui in code so that you can inspect.log the filters so you can then copy it in code

ok I will work on that ! Thank you !