Anyone ever had an intermittent "ERROR: Invalid Ex...
# suiteanalyticsn
Netsuite Tragic
05/05/2022, 1:11 PMAnyone ever had an intermittent "ERROR: Invalid Expression" in their Saved Search. I have an employee search with joins to a custom record. The search runs fine for a few hours then will stubbornly start outputting ERROR: Invalid Expression to my formula columns. Without change to the search it will correct itself after an hour.
Search is running in Administrator role and also has RUN UNRESTRICTED for good measure.
A Formula (text) looks like
CASE WHEN {custrecord_employee.custrecord_date} = TO_CHAR({today},'MM/DD/YYYY') THEN {custrecord_employee.custrecord_type}ELSE null ENDj
jen
05/05/2022, 10:38 PMWhat is
{custrecord_date}n
Netsuite Tragic
05/05/2022, 11:07 PMit's Date field on the Custom Record.
Netsuite Tragic
05/05/2022, 11:10 PMI set this to run every ten minutes over a three hour period. Sometimes it is blank, sometimes displays as error. sometimes displays the data. I think it is a defect and have enough data points to lodge as a support case. Let's see.
j
jen
05/06/2022, 3:42 PMOK yes I meant more like….what does it represent, how does it behave? Does it get set by formula, updated by a script or WF, or anything, or is it just a value that gets set once in the UI? Add columns to your search for all the parts that contribute to the formula to make sure none of them have a weird/null value that might make your comparison fail, or help you to identify a pattern for WHEN it fails.
jen
05/06/2022, 3:42 PMwhat is the type of the field
{custrecord_employee.custrecord_type}3 Views