Has anyone ever gotten this error while running a ...
# suitescriptb
Benjamin Cookson
06/15/2022, 8:07 PMHas anyone ever gotten this error while running a saved search? ------- {"reaction":{}}
It's very strange. I was trying to do a Formula Text
It works in the UI, but throws this strange error in the code
Copy code
CASE WHEN 1=1 THEN '{"priorityPoints":0,"fulfillmentModifier":"","priorityRankText":""}' ELSE '{"priorityPoints":0,"fulfillmentModifier":0}' ENDs
Sandii
06/15/2022, 8:10 PMNever seen it but that looks like a pretty silly CASE WHEN conditional
b
Benjamin Cookson
06/15/2022, 8:11 PMIt is very silly. its a test case to insure a certain result
c
CD
06/15/2022, 8:13 PMAre you loading an already defined search containing the above, or are you doing all of it via code? Share your code if so
b
Benjamin Cookson
06/15/2022, 8:20 PMWe are allowing a user to define some rules, and have validation to insure that it wouldn't fail in a saved search.
Copy code
var searchColumn = search.createColumn({name: "formulatext", formula: formulaString, label: "Formula (text)"});
var testPriorityRuleSearch = search.create({
type: "salesorder",
filters:
[
["type","anyof","SalesOrd"],
"AND",
["custrecord_byu_wms_sop_so.custrecord_byu_wms_sop_status","anyof",sopConstants.BYU_SOP_RECORD_STATUSES.ACTIVE],
"AND",
["datecreated","on","today"]
],
columns:[searchColumn]
});Benjamin Cookson
06/15/2022, 8:20 PMWhen formula string is CASE WHEN {item.name}='1' THEN '{"priorityPoints":0,"fulfillmentModifier":"","priorityRankText":""}' ELSE '{"priorityPoints":0,"fulfillmentModifier":0}' END
Benjamin Cookson
06/15/2022, 8:20 PMIt works
Benjamin Cookson
06/15/2022, 8:21 PM Copy code
CASE WHEN 1=1 THEN '{"priorityPoints":0,"fulfillmentModifier":"","priorityRankText":""}' ELSE '{"priorityPoints":0,"fulfillmentModifier":0}' ENDBenjamin Cookson
06/15/2022, 8:21 PMThrows the weird error
b
battk
06/15/2022, 8:40 PMis the string properly escaped?
b
Benjamin Cookson
06/15/2022, 8:41 PMWhich string
Benjamin Cookson
06/15/2022, 8:42 PM Copy code
The only difference between the two is ---- 1=1 vs. {item.name}='1'b
battk
06/15/2022, 8:43 PM Copy code
CASE WHEN 1=1 THEN '{"priorityPoints":0,"fulfillmentModifier":"","priorityRankText":""}' ELSE '{"priorityPoints":0,"fulfillmentModifier":0}' ENDb
Benjamin Cookson
06/15/2022, 8:44 PMMy biggest question is that it seems weird a saved search would throw an error that isn't an error -- {"reaction":{}}
b
battk
06/15/2022, 8:48 PMyou only get guesses on that one
battk
06/15/2022, 8:48 PMi would guess it doesnt like the quotes