Method Community

I am looking for the SQL code to set a font color in an ActivityStatus field that is rendering in a grid.

If the activity is set to "Not Started" then it should show in the grid red

If the activity is set to "Completed" then it should show in the grid green

In the advanced properties of the column ActivityStatus (alias: Status) I entered the folowing but get an error generating grid

CASE WHEN viewActivity.ActivityStatus = 'Not Started' THEN '<font color="red"><b>' + ActivityStatus + '</b></font>' WHEN viewActivity.ActivityStatus = 'Completed' THEN '<font color="green"><b>' + ActivityStatus + '</b>' ELSE '<font color="black">' + Entity + '</font>' END)

Is there anybody... out there?

Hi there mraley,

Looking at your SQL there - the syntax is correct. If this was copy pasted exactly as is, however - You are missing an opening Bracket before the Query to match the ending one

Try the same query - with the addition of an opening bracket Before CASE WHEN - this should do what you want it to!

You are also missing a closing </font> tag after the 'Completed' status case - but this shouldnt be preventing the grid from loading.

Thanks mraley!

-Ben

Thank you...worked perfect. I knew it was something I missed.