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
Marvin
06/20/2025, 7:24 AM
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
Daryl K
06/21/2025, 8:48 AM
The problem with using suiteql is that you can't run everything with it (for example some fields on transactions).