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
