SuiteQL Question (again - sigh): I have a locatio...
# general
w
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"
ANSWER: If I pull Location.*, I can get access to the “custrecord162” values via post-processing on each location’s “items” collection. I’m still curious if there is a way to pull this via SuiteQL but it’s not urgent anymore.