Anybody know how I use getValue to reference a col...
# suitescript
j
Anybody know how I use getValue to reference a column in a saved search that's a numeric formula when I have multiple columns that are also numeric formulas?
m
That's one of the frustrations that made me move to "N/query" you can create aliases for all the columns and then
run().asMappedQuery()
that gives you a nice array of objects with simple keys you define. You can do it in searches like you found, but it's not nearly as clean.
🤔 1
d
The problem with using suiteql is that you can't run everything with it (for example some fields on transactions).