|
Subject: [xsl] Get the most recent date From: "LEGAULT, PHILLIP plegault@xxxxxxxxxx" <xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx> Date: Tue, 12 Mar 2024 16:03:32 -0000 |
I have an XML file with the following sections with date fields.
I need the latest sf:LastModifiedDate field when sf:ActivityCategory_GCC__c =
Additional Information
<records xsi:type="sf:Task">
<sf:Id xsi:nil="true"/>
<sf:ActivityAwarenessDate_GCC__c>2023-11-05T00:28:00.000Z</sf:Activi
tyAwarenessDate_GCC__c>
<sf:ActivityCategory_GCC__c>Additional
Information</sf:ActivityCategory_GCC__c>
<sf:ActivityNumber_GCC__c>xxxxxxx</sf:ActivityNumber_GCC__c>
<sf:ActivityType_GCC__c>Receive Phone Call</sf:ActivityType_GCC__c>
<sf:DetailsDelayedAwareness_GCC__c>The delay occurred because there
was a data-entry omission of "Task" when the follow-up report was
created.</sf:DetailsDelayedAwareness_GCC__c>
<sf:LastModifiedDate>2023-11-09T04:30:46.000Z</sf:LastModifiedDate>
<sf:ReasonDelayedAwareness_GCC__c>Other
Cause</sf:ReasonDelayedAwareness_GCC__c>
<sf:Subject>Task</sf:Subject>
<sf:TranslationCompleted_GCC__c>true</sf:TranslationCompleted_GCC__c
>
</records>
<records xsi:type="sf:Task">
<sf:Id xsi:nil="true"/>
<sf:ActivityAwarenessDate_GCC__c>2024-01-23T05:46:01.000Z</sf:Activi
tyAwarenessDate_GCC__c>
<sf:ActivityCategory_GCC__c>Additional
Information</sf:ActivityCategory_GCC__c>
<sf:ActivityNumber_GCC__c>xxxxxx</sf:ActivityNumber_GCC__c>
<sf:ActivityType_GCC__c>Receive Phone Call</sf:ActivityType_GCC__c>
<sf:LastModifiedDate>2024-01-25T13:27:31.000Z</sf:LastModifiedDate>
<sf:Subject>Task</sf:Subject>
<sf:TranslationCompleted_GCC__c>true</sf:TranslationCompleted_GCC__c
>
</records>
Here is what I have now xslt 2
Receipt Date: <xsl:choose>
<xsl:when test="/records/sf:Tasks/records/sf:ActivityCategory_GCC__c =
'Additional Information' and
max(/records/sf:Tasks/records/sf:ActivityAwarenessDate_GCC__c)">
<xsl:value-of
select="format-dateTime(/records/sf:Tasks/records[sf:ActivityCategory_GCC__c=
'Additional
Information']/./sf:ActivityAwarenessDate_GCC__c,'[D01]-[MN,*-3]-[Y0001]')" />
</xsl:when>
<xsl:when test="/records/sf:Tasks/records/sf:ActivityCategory_GCC__c =
'Initial'">
<xsl:value-of
select="format-dateTime(/records/sf:Tasks/records[sf:ActivityCategory_GCC__c=
'Initial'][1]/./sf:ActivityAwarenessDate_GCC__c,'[D01]-[MN,*-3]-[Y0001]')" />
</xsl:when>
</xsl:choose>
| Current Thread |
|---|
|
| <- Previous | Index | Next -> |
|---|---|---|
| Re: [xsl] How to declaratively desc, G. Ken Holman g.ken. | Thread | Re: [xsl] Get the most recent date, Martin Honnen martin |
| Re: [xsl] How to declaratively desc, Michael Kay mike@xxx | Date | Re: [xsl] Get the most recent date, Martin Honnen martin |
| Month |