How do I concatenate HearingDate and StartTime?

winkimjr2 · August 12th, 2014, 01:02 PM

How do I get this result:
<ext:HearingDateTime>07/21/2014 8:30 AM</ext:HearingDateTime>
I have xml that have two StartTime and a HearingDate. The two StartTime are the same but one is near the top and the other one is a child of CourtSessionBlock.
The first StartTime is not always there which means sometimes the only available StartTime is the child of CourtSessionBlock.
For this reason, I need to first check if there is StartTime near the top of xml document. If it is there, I will use that StartTime concatenated with HearingDate. Otherwise if it's not there or when the only StartTime is the child of CourtSessionBlock, I will use that one. I have tried using <xsl:if> and <xsl:choose> but I am not getting anything displayed for the <ext:HearingDateTime/>. Please help.
Here is my xml code:

Code:

<Setting ID="21613643" InternalSettingID="1622304543" Date="07/21/2014">
	<HearingDate>07/21/2014</HearingDate>
	<StartTime>8:30 AM</StartTime>
	<EndTime>9:30 AM</EndTime>
	<CourtSessionBlock InternalCourtSessionBlockID="1614615037">
		<StartTime>8:30 AM</StartTime>
		<EndTime>9:30 AM</EndTime>
	</CourtSessionBlock>
	<TimestampCreate>07/15/2014 09:27:49:607</TimestampCreate>
</Setting>

I removed the xslt code. Based on this xml how can I check to see if the first StartTime is present and use it otherwise check to see if there is StartTime as a child of CourtSessionBlock?

mhkay · August 13th, 2014, 06:58 AM

Your paths are wrong. It's hard to tell exactly how wrong, because they refer to elements Integration and Case which you haven't shown us, and also we can't see what the context item for your XSLT code fragment is, but at the very least I would expect the path in the first xsl:value of to be the same as the path in the first xsl:when. And there seems a disagreement between the two branches as to whether it is /Integration/Case/Setting or /Integration/Case/Hearing/Setting.

winkimjr2 · August 13th, 2014, 09:50 AM

Thanks for pointing out the paths. I did for security reasons remove other elements from my xml before posting. My question to you now is based on the xml I have posted here, how can I check to see if the first StartTime is present and use it otherwise check to see if there is StartTime as a child of CourtSessionBlock?
If you can help me with this, I am sure I will be able to figure out the xpath.

mhkay · August 13th, 2014, 10:01 AM

The simplest logic is to write

(path1 | path2) [1]

which will select the first item selected by either path1 or path2, in document order.