Hello all,
I am creating a SharePoint site that we will use to report issues with trucks used in our business. Linked to
the list I have created will be a page that will display an overview of
the trucks and a little truck icon will show
the trucks current status. Green and
the truck is okay (no open issues), Red and
the truck have an open issue with status "Undrivable", Orange and there is two issues open that requires
the user to look further into
the truck before using it and finally a Gray truck for when there is a new issue created that has not been looked into (not sure if it is drivable or not).
I have managed to create
the "Dashboard" and with my limit XSL/XPATH knowledge been able to add a truck and replicate
the description
above but... in my test I have created 4 issues, for example if three of them are changed to status Closed and one left to Undrivable I will get four icons on
the page, three with Green trucks and
the last one Red. So in theory it works but I obviously only want to see
the last truck, one truck. I am not interested in seeing
the others.
<xsl:template name="dvt_1.rowview">
<xsl:variable name="CountReport" select="count(/dsQueryResponse/Rows/Row[@Highloader='GGEU12' and @Status!='Closed'])" />
<xsl:variable name="MoreThan" select="$CountReport > 1" />
<xsl:variable name="NoReports" select="$CountReport = 0" />
<xsl:variable name="Closed" select=" @Highloader='GGEU12' and @Status='Closed'" />
<xsl:choose>
<xsl:when test="$MoreThan">
<div class="ms-vb"><img title='More than one report exist!' border='0' alt='In Progress' src='highloader/Library/hl-orange.png' /></div>
</xsl:when>
<xsl:otherwise>
<div class="ms-vb"><xsl:value-of disable-output-escaping="yes" select="@Icon" /></div>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
My hope is that someone with slightly more knowledge can find
the last piece of
the puzzle for me!
Thanks for reading and asking questions to fill any gap I left
above.
David
