How do I get the Status with the latest TimestampCreate?

winkimjr2 · June 13th, 2016, 12:58 PM

I have revised my question.
I would like to get the Status whose TimestampCreate matches the ControlPoint Timestamp.

My xml 1.0 code

Code:

<?xml version="1.0" encoding="UTF-8"?>
<Integration>
	<ControlPoint Timestamp="5/9/2016 2:34:34 PM" UserID="Kuku">SAVE</ControlPoint>
	<ProtectionOrders>
		<ProtectionOrder Op="E" InternalProtectionOrderID="11831">
			<Statuses>
				<Status>
					<Current>true</Current>
					<Active>No</Active>
					<Date>05/09/2016</Date>
					<Type Word="DISMISSED">Dismissed</Type>
					<TimestampCreate Op="A">05/09/2016 14:34:48:633</TimestampCreate>
				</Status>
				<Status Op="A">
					<Current>false</Current>
					<Active>Yes</Active>
					<Date Op="A">05/09/2016</Date>
					<Type Op="A" Word="SBJO">Signed By Judicial Officer</Type>
					<TimestampCreate>05/09/2016 14:34:34:737</TimestampCreate>
				</Status>
				<Status>
					<Current>false</Current>
					<Active>No</Active>
					<Date>12/30/2014</Date>
					<Type Word="DRAFT">Draft</Type>
					<TimestampCreate>05/09/2016 14:34:14:987</TimestampCreate>
				</Status>
			</Statuses>
		</ProtectionOrder>
	</ProtectionOrders>
</Integration>

I am not sure how to change my xslt code

I am using a function to convert date time to a number. I am not sure how then to compare the Status TimestampCreate to ControlPoint Timestamp and select the Status TimestampCreate that matches ControlPoint Timestamp.

xslt 1.0 code

Code:

<ProtectionOrderStatus>
		<ProtectionOrderStatusDate>
			<xsl:value-of select="mscef:formatDate(string(Statuses/Status/Date))"/>
		</ProtectionOrderStatusDate>
</ProtectionOrderStatus>

Here is my function to convert Status TimestampCreate and ControlPoint Timestamp to numeric

Code:

<xsl:value-of select="mscef:formatDateTimeNumeric(mscef:fixOdysseyTimestamp(string(TimeStampCreate)))"/>

mhkay · June 13th, 2016, 01:05 PM

Well, first we need to know whether 05/09/2016 is 9th May or 5th September. In most of the world it's 5th September, but the US has its own peculiar ideosyncracies.

Really you would be much better off switching to international standard date time representation, that is 2016-09-05T14:34:48.633. If you do that sorting becomes trivial. If you don't do that, then you need to write a lot of messy code using concat and substring to reformat the date before you can sort it.

winkimjr2 · June 13th, 2016, 01:17 PM

Quote:

Originally Posted by mhkay

Well, first we need to know whether 05/09/2016 is 9th May or 5th September. In most of the world it's 5th September, but the US has its own peculiar ideosyncracies.

Really you would be much better off switching to international standard date time representation, that is 2016-09-05T14:34:48.633. If you do that sorting becomes trivial. If you don't do that, then you need to write a lot of messy code using concat and substring to reformat the date before you can sort it.

The date is May 9th 2016. How do I switch to international standard date time representation? I have a function I can use which will format date time to something like this 20160509143434

Here is the code using my function used in the following code

Code:

<xsl:variable name="vTimeStampCreate" select="/Integration/ProtectionOrder[@InternalProtectionOrderID=$pProtectionOrderID]/Statuses/Status[Current='true']/TimestampCreate"/>
				<ext:ProtectionOrderStatusDate>
xsl:value-of select="mscef:formatDateTimeNumeric(mscef:fixOdysseyTimestamp(string($vTimeStampCreate)))"/>
</ext:ProtectionOrderStatusDate>
			</ext:ProtectionOrderStatus>