Basic SuiteQL question
I am selecting a field whi...
# suiteqla
Azi
08/08/2022, 5:41 PMBasic SuiteQL question
I am selecting a field which is a type checkbox. It returns as 'T' or 'F' but I want it to return as true or false.
What function would I use in a query to accomplish that?
a
Alan Fitch
08/08/2022, 5:49 PM Copy code
query.runSuiteQL(theQuery).asMappedResults(x => {return {...x, fieldname: x.fieldname == "T"}})a
Azi
08/08/2022, 6:09 PMThanks. I appreciate the help, but I was looking for a suiteql function solution not a js solution
Azi
08/08/2022, 6:10 PMWhat I am trying to avoid is having to re-iterate over thousands of results
a
Alan Fitch
08/08/2022, 6:15 PMEven if millions of results the overhead will be minimal to run this map statement.
Oracle databases don't have a boolean datatype. The only other thing I would suggest is to use something like
CASE WHEN fieldname = 'T' THEN 1 ELSE 0 ENDif(x.fieldname)a
Azi
08/08/2022, 6:15 PMGot it. Thank you very much!
s
scottvonduhn
08/08/2022, 6:16 PMSQL has no boolean data type at all, and this is no different
a
Azi
08/08/2022, 6:17 PMOkay. I was coming from postgresql which does have boolean types.
Thanks guys
a
Alan Fitch
08/08/2022, 6:17 PMWelcome to the clown database that is oracle.
s
scottvonduhn
08/08/2022, 6:17 PMgenerally 0, the empty string ‘’ or null all evaluate as falsy in JavaScript, so you can use that to your advantage.
scottvonduhn
08/08/2022, 6:19 PMOracle databases tend to treat empty strings the same as null. Not sure if that holds true for SuiteQL, but I suspect it does (need to test it).
a
Azi
08/08/2022, 6:24 PM@Alan Fitch
Copy code
query.runSuiteQL(theQuery).asMappedResults(x => {return {...x, fieldname: x.fieldname == "T"}}) Copy code
query.runSuiteQL(theQuery).asMappedResults().map(x => {return {...x, fieldname: x.fieldname == "T"}})a
Alan Fitch
08/08/2022, 6:25 PMYeah typo.
👍 1
Alan Fitch
08/08/2022, 6:25 PMOnly have slack on my phone.
a
Azi
08/08/2022, 6:26 PMLol! I got excited there that there was a way to pass a callback to asMappedResults that I never knew about
🔜 1
p
Pavol
08/11/2022, 1:27 PM@Azi: Use this SuiteQL function to return booleans:
BUILTIN_RESULT.TYPE_BOOLEAN()😮 1
a
Azi
08/12/2022, 4:23 PM@Pavol Wow. Thank you this worked. Except it still leaves null results as null instead of false. But regardless it will still evaluate to falsy so that shouldn't be such a big deal
4 Views