Somebody knows or remember what would be the limit...
# suitescripta
alien4u
12/28/2022, 5:46 PMSomebody knows or remember what would be the limit for:
Copy code
["formulatext: case when {itemid} in ('" + aItemNames.join("','") + "') then 'Y' else 'N' end","is","Y"]b
battk
12/28/2022, 7:27 PM1000
a
alien4u
12/28/2022, 7:37 PMThanks, do you have any metrics about what is faster? this or:
itemid, IS, itemName1,
'OR'
itemid, IS, itemName2
n...
What would be the limit of the chained ORs?
b
battk
12/28/2022, 7:38 PMi believe last time i tested the in clause was faster, though i have also seen just chained ors being faster
👍 1
battk
12/28/2022, 7:39 PMi believe you run out of governance before you run out of ors, so no limit to the number
battk
12/28/2022, 7:40 PMthe difference in code between the two isnt large, you can probably test both and see which is faster for your purposes
👍 1