When creating SuiteQL transaction queries and you ...
# suitescript
m
When creating SuiteQL transaction queries and you want to filter by transaction status, you need to use different syntaxes depending on if you are using runSuiteQL or runSuiteQLPaged - the former requires you to use a “status = ‘CustInvc:A’” syntax, while the latter requires it to say “status = ‘A’“. Is this some sort of bug or is there a logical explanation for the difference?
👍 1
l
we tested and it returned the same results.. might need to ask NetSuite Support what’s happening in the backend
m
Yeah I figured I might have to do that. I’ll create a case for it, thanks for confirming that the issue occurs on your end as well!