Color code item current states

Hi Dkinsley

Try this code and let me know if it works

string bg_color_new = "";
string myCss_new = "";
string text_color_new = "#000000";
string bg_color_aff = "";
string myCss_aff = "";
string text_color_aff = "#000000";
for (int i = 0; i < this.getItemCount(); i++)
{
Item thisItem = this.getItemByIndex(i);
string thisStatus = thisItem.getProperty("new_state", "");
string thisAffStatus = thisItem.getProperty("affected_state", "");
switch (thisStatus)
{
case "Preliminary":
case "In Review":

bg_color_new = "#FFCC00"; // yellow
text_color_new = "#000000"; // black
break;
case "In Change":

case "Inactive":
bg_color_new = "#80EE80"; // light green
text_color_new = "#000000"; // black
break;

case "Released":
bg_color_new = "#55CC55"; // green
text_color_new = "#000000"; // black
break;
case "Superseded":
case "Obsolete":
bg_color_new = "#FF8888"; // light red
text_color_new = "#000000"; // black
break;
default:
bg_color_new = ""; // none
break;
}
switch (thisAffStatus)
{
case "Preliminary":
case "In Review":

bg_color_aff = "#FFCC00"; // yellow
text_color_aff = "#000000"; // black
break;
case "In Change":

case "Inactive":
bg_color_aff = "#80EE80"; // light green
text_color_aff = "#000000"; // black
break;

case "Released":
bg_color_aff = "#55CC55"; // green
text_color_aff = "#000000"; // black
break;
case "Superseded":
case "Obsolete":
bg_color_aff = "#FF8888"; // light red
text_color_aff = "#000000"; // black
break;
default:
bg_color_aff = ""; // none
break;
}

if (bg_color_new != "")
{
myCss_new = ".new_state { background-color: " + bg_color_new + "; color: " + text_color_new + "; }";
}
if (bg_color_aff != "")
{
myCss_aff = ".affected_state { background-color: " + bg_color_aff + "; color: " + text_color_aff + "; }";
}
thisItem.setProperty("css", myCss_new + " " + myCss_aff);
}
return this;

Thanks

Gopikrishnan R

Hi Gopikrishnan,

Your scrip colors the new_state but not the affected_state. Nothing has to be added to the lines below?

if (bg_color != "") {
myCss = ".new_state { background-color: " + bg_color + "; color: " + text_color + "; }";
thisItem.setProperty("css", myCss);
}

Updated the above code.

Updated the above code.

With the updated code, now the affected_state colors but not the new_state.

I'm using event onAfterGet for CN affected items

Can you try debugging this method ?

Sorry, I am not familiar how that is done.

No Worries. Updated the code. Test and let me know if it works

When I checked the syntax, it displayed this:

Checking syntax...

ERROR: 2517CBB12F8145209E6A8CBF076E1E0B.
Line number 84, Error Number: CS0165, Use of unassigned local variable 'myCss_new'
Line number 84, Error Number: CS0165, Use of unassigned local variable 'myCss_aff'

My bad. Its because the value is not assigned to this variable. updated above

The code works except once it put red color in the affected_state column when the cells were blank. I will try it some more.

If i have a CN with a few revise action rows and then below those a few release action rows, it colors the blank cell in the release actions.

There would never be a blank cell in the new_state column only in the affected_state column.

Sorry, I just noticed i sent replies to myself.

If I have a revise action row and then a release action row, the script is coloring the empty/blank cell in the affected_state column of the release action item. It only does this under this condition.