Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
Saved Search broke with upgrade
Good Morning
Our system was upgraded over the weekend and now this saved search formula which worked prior is not functioning correctly. The formula is...
CASE WHEN ({status} = 'Completed' OR ROUND({percentworkcomplete}*100, 1) = 100.0) THEN '<div style="height:15px;width:15px;display:block;margin:0 auto;border:1px solid #afc437;border-radius:15px;-moz-border-radius:15px;-webkit-border-radius:15px;background-color:#afc437;" title="Completed"></div>' WHEN (ROUND({percentworkcomplete}*100, 1) <> 100.0) AND (TO_DATE(TO_CHAR({enddate}, 'MM/DD/YYYY'), 'MM/DD/YYYY') - TO_DATE(TO_CHAR(SYSDATE, 'MM/DD/YYYY'), 'MM/DD/YYYY')) < 0 THEN '<div style="height:15px;width:15px;display:block;margin:0 auto;border:1px solid #bf340f;border-radius:15px;-moz-border-radius:15px;-webkit-border-radius:15px;background-color:#bf340f;" title="Overdue Task"></div>' WHEN (ROUND({percentworkcomplete}*100, 1) <> 100.0) AND (TO_DATE(TO_CHAR({enddate}, 'MM/DD/YYYY'), 'MM/DD/YYYY') - TO_DATE(TO_CHAR(SYSDATE, 'MM/DD/YYYY'), 'MM/DD/YYYY')) = 0 THEN '<div style="height:15px;width:15px;display:block;margin:0 auto;border:1px solid #f89406;border-radius:15px;-moz-border-radius:15px;-webkit-border-radius:15px;background-color:#f89406;" title="Due Today"></div>' ELSE '<div style="height:15px;width:15px;display:block;margin:0 auto;border:1px solid #428bca;border-radius:15px;-moz-border-radius:15px;-webkit-border-radius:15px;background-color:#428bca;" title="On Track"></div>' END