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 item_fulfillment containing a specific inventorynumber. But Im doing something wrong with the joining.
```  search.create({
      type:search.Type.ITEM_FULFILLMENT,
      filters: ['inventorynumber', 'is', 'bcy32scy'],	  
      join:['inventorydetail'],
      columns:['entity']
  }).run()
    .each(function(result) {
      log.debug(result);
      return true;
    });```

Have you looked at the api for `search.create()` ?  Join is not a parameter it takes.

`search.create()` does not have a `join` option parameter, joins are done within the columns option parameter

e.g. `inventorydetail.entity` or `search.createColumn({ name: 'entity', join: 'inventorydetail'})`

I highly highly highly suggest using the Chrome `Netsuite: Search Export` extension, which allows you to save a search in the UI and then have it create the equivalent `search.create()` variable for you with all the joins, correct field names, etc

Also `log.debug()` , takes 2 parameters, trying to log that much as the title will not produce anything of value.

I know. It was just to show that there was (or was not) a result :slightly_smiling_face:

technically, `log.debug()` has 1 parameter - the dastardly `options` object.

(unless you're using NFT which does indeed take the more sane two params for title/details)

however, I'm guilty of using the 2 parameter version myself... it's  a lot less typing and cleaner looking imho

var myValue = 'value';
log.debug({
    title: 'Debug Entry',
    details: 'Value of myValue is: ' + myValue
});

<http://system.netsuite.com/app/help/helpcenter.nl?fid=section_4430385329.html&amp;whence=>

Anyway, don't mean to hijack thread, back to regularly scheduled programming.

Thanks <@U5375UUJ2> :slightly_smiling_face:
I still can't get my head around the search-join. This is what I have so far, but it hangs the debugger :confused:
```  search.create({
      type:search.Type.ITEM_FULFILLMENT,
      filters: [search.createFilter({
                            name: 'inventorynumber',
                            join: 'inventorydetail',
                            operator: <http://search.Operator.IS|search.Operator.IS>,
                            values: ['bcy32scy']
                        })],	  
      columns:['entity'] // or any field from Item-Fulfillment
  }).run()```

maybe this is easier with SuiteQL? I can't say I know how to get to inventory detail  via SuiteQL off the top of my head but <@U856E2SEA> might!

I would `IS` is the problem, doesn't it use `ANYOF` when you make the search in the UI?

I believe the `IS` operator is for text fields, not select fields.

I'm pretty sure `is` works on select fields too. battk can probably provide the help link where there's a table showing which operators work with each field type.

1.0 table says `IS` is for checkboxes and email/text

<https://system.netsuite.com/app/help/helpcenter.nl?fid=section_N3005172.html|SuiteScript 1.0 Search Operators>

Good find Sandii -  looks like indeed `ANYOF` is the safe bet.