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 have a custom module script with a query that is used by a MR and UE script. One script returns one line as it should and the other script returns 0 lines. Same query, getting same parameters passed, different results.

Are the permissions between the two UEs different?

Sorry i need to correct my message, its one MR and one UE. Yes, permissions are the same

Will potentially have to share the query and the parameter values getting passed in

Can't think of a reason off the top that it would be different

Untitled.txt

It passes in a custom record id. I logged the output of the sql for the one returning 0 and then ran it in the query tool and it returns 1 result.

Untitled.js

I don't know the answer to your question. I would suggest using SuiteScript 2.1 if you're writing this module from scratch though. It's going to be much easier to develop queries using <https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Template_literals|template literals>.

Thanks for everyone's help. changed it to a search and seemed to work fine.