has anyone used SuiteQL in a getInputData() stage ...
# suitescript
s
has anyone used SuiteQL in a getInputData() stage of a MR script? What's the best practice? It looks like you can return an N/query object from
getInputData()
but no mention of how to handle SuiteQL. Do I have to
.run()
the [SuiteQL] query and return a resultSet? I'd prefer to just return my SuiteQL query string or something and have NS execute it.
m
It's not mentioned in Map/Reduce docs, but there is an example in the SuiteQL section like this
Copy code
return {
    type: 'suiteql',
    query: "SELECT ... FROM ... "
};
https://system.netsuite.com/app/help/helpcenter.nl?fid=section_158039627694.html
s
awesome find @michoel, thanks!