How can you search/filter for open invoices? These...
# suitescript
d
How can you search/filter for open invoices? These examples filters do not work:
Copy code
const invoiceOpenStatusFilterExample1 = search.createFilter({
            name: "status",
            operator: <http://search.Operator.IS|search.Operator.IS>,
            values: "Open"
        });
const invoiceOpenStatusFilterExample2 = search.createFilter({
            name: "status",
            operator: <http://search.Operator.IS|search.Operator.IS>,
            values: ["Open"]
        });
const invoiceOpenStatusFilterExample3 = search.createFilter({
            name: "status",
            operator: search.Operator.ANYOF,
            values: ["Open", "open"]
        });
But I can successfully retrieve an invoice via the entity/customer id filter example below
Copy code
const invoiceEntityFilter = search.createFilter({
            name: "entity",
            operator: <http://search.Operator.IS|search.Operator.IS>,
            values: customerId
        });
c
@Darren It's not "Open"... it should be like this:
Copy code
["status","anyof","CustInvc:A"]
d
Thanks Charles, that's got it working
👍 1
s
@Darren In general, its easiest to make the search in the UI and use the chrome extension
NetSuite: Search Export
to avoid the guessing game
👍 1
☝️ 2
d
Thanks Sandii, that's a good tip
a
Or just create the search and then load it from the console and execute api for get filters / columns definition you need to create in the code