SuiteQL Question (again - sigh):
I have a location I can pull via REST (location/id) and it has a field called “custrecord162” on it with something of interest. Apparently, this field is defined under “Other Record Fields” in NS.
How do I pull the “custrecord162” values for my locations via SuiteQL (some join with location?)?
Currently, I have to pull the locations of interest via SuiteQL and then issue REST requests per each location to get the value of “custrecord162"