XSL: conditionally format table row

EDN Admin

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
I need a little help in getting the background color of a row, which meets specific criteria, to be a specific color. Im about 95% there, but instead of just the individual row being colored, the entire table is colored.
My CSS styles:

<div style="color:Black;background-color:White; <pre>
<span style="color:Blue; <<span style="color:#A31515; style <span style="color:Red; type<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; text/css<span style="color:Black; "<span style="color:Blue; >
body {margin-left: 20px; font-family: calibri;}
h1 {font-size: 70%; font-family: calibri; font-weight:normal; color:#000;}
h2 {font-size: 70%; font-family: calibri; font-weight:bold; text-decoration:underline;}
h3 {font-size: 70%; font-family: calibri;}
th {font-size: 65%; font-family: calibri; font-weight:bold;}
td {font-size: 60%; font-family: calibri; padding-right: 10px; color:#000;}
tr.redRow td {font-size: 60%; font-family: calibri; font-weight:bold; background-color: #FF2626; padding-right: 10px; color:#000;}
<span style="color:Blue; </<span style="color:#A31515; style<span style="color:Blue; >
[/code]
<br/>
My Table definition:

<div style="color:Black;background-color:White; <pre>
<span style="color:Blue; <<span style="color:#A31515; xsl<span style="color:Blue; :<span style="color:#A31515; template <span style="color:Red; match<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Approved<span style="color:Black; "<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; xsl<span style="color:Blue; :<span style="color:#A31515; if <span style="color:Red; test<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; /Email/Approved[Deadline = number($currentDate)]<span style="color:Black; "<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; xsl<span style="color:Blue; :<span style="color:#A31515; attribute <span style="color:Red; name<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; class<span style="color:Black; "<span style="color:Blue; >redRow<span style="color:Blue; </<span style="color:#A31515; xsl<span style="color:Blue; :<span style="color:#A31515; attribute<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; xsl<span style="color:Blue; :<span style="color:#A31515; if<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; td<span style="color:Blue; ><span style="color:Blue; <<span style="color:#A31515; xsl<span style="color:Blue; :<span style="color:#A31515; value-of <span style="color:Red; select<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; MetricName<span style="color:Black; "<span style="color:Blue; /><span style="color:Blue; </<span style="color:#A31515; td<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; td<span style="color:Blue; ><span style="color:Blue; <<span style="color:#A31515; xsl<span style="color:Blue; :<span style="color:#A31515; value-of <span style="color:Red; select<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; RequestDate<span style="color:Black; "<span style="color:Blue; /><span style="color:Blue; </<span style="color:#A31515; td<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; td<span style="color:Blue; ><span style="color:Blue; <<span style="color:#A31515; xsl<span style="color:Blue; :<span style="color:#A31515; value-of <span style="color:Red; select<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Requestor<span style="color:Black; "<span style="color:Blue; /><span style="color:Blue; </<span style="color:#A31515; td<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; td<span style="color:Blue; ><span style="color:Blue; <<span style="color:#A31515; xsl<span style="color:Blue; :<span style="color:#A31515; value-of <span style="color:Red; select<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; FieldChanging<span style="color:Black; "<span style="color:Blue; /><span style="color:Blue; </<span style="color:#A31515; td<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; td<span style="color:Blue; ><span style="color:Blue; <<span style="color:#A31515; xsl<span style="color:Blue; :<span style="color:#A31515; value-of <span style="color:Red; select<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; ChangeFrom<span style="color:Black; "<span style="color:Blue; /><span style="color:Blue; </<span style="color:#A31515; td<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; td<span style="color:Blue; ><span style="color:Blue; <<span style="color:#A31515; xsl<span style="color:Blue; :<span style="color:#A31515; value-of <span style="color:Red; select<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; ChangeTo<span style="color:Black; "<span style="color:Blue; /><span style="color:Blue; </<span style="color:#A31515; td<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; td<span style="color:Blue; ><span style="color:Blue; <<span style="color:#A31515; xsl<span style="color:Blue; :<span style="color:#A31515; value-of <span style="color:Red; select<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; CRStatus<span style="color:Black; "<span style="color:Blue; /><span style="color:Blue; </<span style="color:#A31515; td<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; td<span style="color:Blue; ><span style="color:Blue; <<span style="color:#A31515; xsl<span style="color:Blue; :<span style="color:#A31515; value-of <span style="color:Red; select<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; Deadline<span style="color:Black; "<span style="color:Blue; /><span style="color:Blue; </<span style="color:#A31515; td<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; td<span style="color:Blue; ><span style="color:Blue; <<span style="color:#A31515; xsl<span style="color:Blue; :<span style="color:#A31515; value-of <span style="color:Red; select<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; CRID<span style="color:Black; "<span style="color:Blue; /><span style="color:Blue; </<span style="color:#A31515; td<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; tr<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; xsl<span style="color:Blue; :<span style="color:#A31515; template<span style="color:Blue; >
[/code]
And here is my sample XML:

<div style="color:Black;background-color:White; <pre>
<span style="color:Blue; <<span style="color:#A31515; Email<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Approved<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; MetricName<span style="color:Blue; >Blah Crap Metric<span style="color:Blue; </<span style="color:#A31515; MetricName<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; RequestDate<span style="color:Blue; >12/21/2011<span style="color:Blue; </<span style="color:#A31515; RequestDate<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Requestor<span style="color:Blue; >Chris<span style="color:Blue; </<span style="color:#A31515; Requestor<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; FieldChanging<span style="color:Blue; >ActualCalc<span style="color:Blue; </<span style="color:#A31515; FieldChanging<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ChangeFrom<span style="color:Blue; >X=Actual<span style="color:Blue; </<span style="color:#A31515; ChangeFrom<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ChangeTo<span style="color:Blue; >X/Y<span style="color:Blue; </<span style="color:#A31515; ChangeTo<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; CRStatus<span style="color:Blue; >Needs Validation<span style="color:Blue; </<span style="color:#A31515; CRStatus<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Deadline<span style="color:Blue; >20111222<span style="color:Blue; </<span style="color:#A31515; Deadline<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; CRID<span style="color:Blue; >1112<span style="color:Blue; </<span style="color:#A31515; CRID<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; Approved<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Approved<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; MetricName<span style="color:Blue; >Blah Crap Metric B<span style="color:Blue; </<span style="color:#A31515; MetricName<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; RequestDate<span style="color:Blue; >12/20/2011<span style="color:Blue; </<span style="color:#A31515; RequestDate<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Requestor<span style="color:Blue; >Chris<span style="color:Blue; </<span style="color:#A31515; Requestor<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; FieldChanging<span style="color:Blue; >ActualCalc<span style="color:Blue; </<span style="color:#A31515; FieldChanging<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ChangeFrom<span style="color:Blue; >X=Actual<span style="color:Blue; </<span style="color:#A31515; ChangeFrom<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ChangeTo<span style="color:Blue; >X/Y<span style="color:Blue; </<span style="color:#A31515; ChangeTo<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; CRStatus<span style="color:Blue; >Needs Validation<span style="color:Blue; </<span style="color:#A31515; CRStatus<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Deadline<span style="color:Blue; >20111225<span style="color:Blue; </<span style="color:#A31515; Deadline<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; CRID<span style="color:Blue; >1113<span style="color:Blue; </<span style="color:#A31515; CRID<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; Approved<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Rejected<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; MetricName<span style="color:Blue; >Licenses<span style="color:Blue; </<span style="color:#A31515; MetricName<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; RequestDate<span style="color:Blue; >12/15/2011<span style="color:Blue; </<span style="color:#A31515; RequestDate<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Requestor<span style="color:Blue; >Chris<span style="color:Blue; </<span style="color:#A31515; Requestor<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; FieldChanging<span style="color:Blue; >MetricName<span style="color:Blue; </<span style="color:#A31515; FieldChanging<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ChangeFrom<span style="color:Blue; >Licenses<span style="color:Blue; </<span style="color:#A31515; ChangeFrom<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ChangeTo<span style="color:Blue; >Blah Crap Metric C<span style="color:Blue; </<span style="color:#A31515; ChangeTo<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; CRStatus<span style="color:Blue; >Submitted<span style="color:Blue; </<span style="color:#A31515; CRStatus<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; CRID<span style="color:Blue; >1111<span style="color:Blue; </<span style="color:#A31515; CRID<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; Rejected<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; currentDate<span style="color:Blue; >
20111222
<span style="color:Blue; </<span style="color:#A31515; currentDate<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; Email<span style="color:Blue; >
[/code]
<br/>
And one additional question is, how do I format the Deadline into a human readable format? Im brining it in as YYYYMMDD for the comparison.

Thanks,
Chris

View the full article
 
Back
Top