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

Weird permission error on searching on supportcase with joins via the company field:

`Your search contains a reference to join for which you do not have a permission: Entity`

There isn't a permission called Entity. I have granted View permission for Contacts, Customers, Employees, Projects and Supplies but that didn't fix it. Any ideas?

```var filters = [];

filters.push(search.createFilter({
    name: 'custevent_sp_icefs_everenabled',
    operator: <http://search.Operator.IS|search.Operator.IS>,
    values: [true]
}));

if (!!prevLastModifiedDate){
    filters.push(search.createFilter({
        name: 'lastmodifieddate',
        operator: search.Operator.GREATERTHAN,
        values: [prevLastModifiedDate]
    }));
}

const results = utils.doSearch('supportcase', filters, [
    'internalid',
    'casenumber',
    'custevent_case_sched_start_date',
    'custevent_case_sched_start_time',
    'custevent_case_sched_end_date',
    'custevent_case_sched_end_time',
    'custevent1',
    'title',
    'startdate',
    'custevent_sp_description',
    'company.entityid',
    'company.companyname',
    'custevent_case_address',
    'phone',
    'custevent_sp_icefs_enabled',
    'lastmodifieddate'
]);```


utils.doSearch just runs the search. It doesn't modify its parameters before passing them to the native search functionality

and which columns do you have to remove to remove to fix the permission error

got a invalid column on company.companyname

and thats on a role with 2 permissions, full run search and view case

Even if I remove only company.entityid and include company.companyname then I get the permission error

might want to simply try removing the companyname column

you might just be getting the wrong error message

Just tried that and got the same permission error

I contacted NS support 12 hours ago so hopefully I'll discover the answer soon. It'd be annoying to have to perform more than one search

you will probably want to give them simpler code

that they can use to reproduce the problem themselves

```require(["N/search"], function (search) {
  log.debug(
    "results",
    search
      .create({ type: "supportcase", columns: ["company.entityid"] })
      .run()
      .getRange(0, 1000)
  );
});```