`N/query` Anyone have issues using SuiteQL with se...
# suitescript
d
N/query
Anyone have issues using SuiteQL with select fields on a custom record? I can get the values for the text fields just fine but it continues to fail on me when I add the field that is a list/record select.
s
I've never had a problem with this but I've only written the queries with the actual query.main, query.columns type calls, not SuiteQL.
d
I'm finding that this field is not even available in the analytics dataset. I think it might be because of the type of field it is.
s
maybe paste your SuiteQL here?
d
I think it's because the list type is
Record Type
and SuiteQL doesn't support this yet. I can do a saved search for this portion of my script.