winkimjr2 Posted June 2, 2015 Share Posted June 2, 2015 What I want to do is...to determining Hearing Date. I want to evaluate the Hearing records in the xml document. If more than one Hearing ID is found, use the most recent HearingDate that has passed. Skip records where SettingID/Cancelled = “True” If multiple hearings are on a case the most recent hearing date should be selected to populate the outbound message. How do I do this? xml document <Integration xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:tsg="http://tsgweb.com" xmlns:IXML="http://tsgweb.com" xmlns:CMCodeQueryHelper="urn:CMCodeQueryHelper" PackageID="DL Notice to DVS" MessageID="67086844" xmlns=""> <Case InternalID="1616832909" ID="11783147" xmlns:user="http://tylertechnologies.com"> <Hearing ID="153546512" InternalHearingEventID="1716143353"> <Setting ID="23490064" InternalSettingID="1623782066" Date="05/14/2014">--> <HearingDate>01/01/2014</HearingDate> </Setting> </Hearing> <Hearing ID="155794813" InternalHearingEventID="1717919318"> <Setting ID="23727431" InternalSettingID="1623950282" Date="07/09/2014"> <HearingDate>07/09/2014</HearingDate> </Setting> </Hearing> <Hearing ID="158501312" InternalHearingEventID="1720225032"> <Setting ID="24032349" Cancelled="true" InternalSettingID="1624178189" Date="07/11/2014"> <HearingDate>07/11/2014</HearingDate> </Setting> </Hearing> <Hearing ID="158551556" InternalHearingEventID="1720240342"> <Setting ID="24040436" InternalSettingID="1624179819" Date="08/20/2014"> <HearingDate>08/20/2014</HearingDate> </Setting> </Hearing> </Case></Integration> My xsl line of code to get the HearingDate. I need to check for hearing and select the most recent HearingDate which do not have Hearing/Setting/@Cancelled="true" <xsl:value-of select="mscef:formatDate(string(Hearing/Setting[not(@Cancelled)]/HearingDate))"/> Link to comment Share on other sites More sharing options...
winkimjr2 Posted June 2, 2015 Author Share Posted June 2, 2015 I resolved this one...... <xsl:for-each select="Hearing/Setting[not(Cancelled)]"> <xsl:sort select="HearingDate" order="descending"/> <xsl:if test="position() = 1"> <xsl:value-of select="mscef:formatDate(string(HearingDate))"/> </xsl:if> </xsl:for-each> Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now