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
the search still runs and th CASE/WHEN criteria seems to work but the results show as in the case of an overdue task for example...
<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"
as opposed to just showing the words overdue task in the correct font, colours etc...what changed and how do I fix it to work today?