Method:Classic General Q&A

Re: SQL - Grid font color

mraley — Mon, 17 Jul 2017 18:28:47 GMT

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

Re: SQL - Grid font color

Method_Ben — Mon, 17 Jul 2017 17:23:41 GMT

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 tag after the 'Completed' status case - but this shouldnt be preventing the grid from loading.

Thanks mraley!

-Ben

Re: SQL - Grid font color

mraley — Mon, 17 Jul 2017 16:09:51 GMT

Is there anybody... out there?

SQL - Grid font color

mraley — Mon, 10 Jul 2017 22:40:29 GMT

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 '' + ActivityStatus + '' WHEN viewActivity.ActivityStatus = 'Completed' THEN '' + ActivityStatus + '' ELSE '' + Entity + '' END)