This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I am trying to search for a record using a custom field, but I don't get any results.
Is there a way to see the records as if you view rational databases or even excel?

i have no idea what you are describing, share the code

```var refID = context.newRecord.getValue("tranid");
    log.debug({title: "refID", details: refID});

    var srch = search.create({
      type: search.Type.INVENTORY_ADJUSTMENT,
      filters: [["custbody3", search.Operator.CONTAINS, refID.toString()]],
    });

    var res = srch.run();

    log.debug({ title: "result", details: res });```

first step should probably be to make the search in the ui, so you can see the data you are working with

importantly you should figure out which filter operators to use

for example, `contains` is a filter for text fields

Yeah, I am stuck at that part.
If I created a search from the UI, can I see the code it generated?

i personally load the search i created in code and then log its filters and columns so i can create it myself

the <https://chrome.google.com/webstore/detail/netsuite-search-export/gglbgdfbkaelbjpjkiepdmfaihdokglp|chrome search export extension> is another option, though i personally disagree with the code it generates, it does dumb things that people are copying and pasting

It worked with the code generated from the first extension. Thanks very much.

<@U5TF1GQ20>, please enlighten me... (from an avid search export user) :slightly_smiling_face:
I usually replace filter operators with enums....

the code it generates uses both a paged search and a result set search, it should only do 1

the building of the search itself is fine, its the running part that I don't use