Search found 55 matches

by winkimjr2
Fri Feb 15, 2019 9:04 pm
Forum: General XML Questions
Topic: How do I concatenate date and time from xml document?
Replies: 0
Views: 305

How do I concatenate date and time from xml document?

I need help to concatenate HearingDate and StartTime in this format: YYYY-MM-DDT00:00:00-06:00. How do I do it in xslt? Xml document <Hearing> <Setting> <HearingDate>07/07/2105</HearingDate> <CourtSessionBlock> <StartTime>10:30 AM</StartTime> <EndTime>11:00 AM</EndTime> </CourtSessionBlock> <Timesta...
by winkimjr2
Thu Feb 07, 2019 7:57 pm
Forum: XSLT and FOP
Topic: How do I add a condition to NotificationEvents?
Replies: 1
Views: 365

How do I add a condition to NotificationEvents?

I need help to add a condition to my xslt. What I need is a condition for all NotificationEvents to have a HearingType/@Word='ACT' How do I do it? <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:output method="xml" encoding=...
by winkimjr2
Wed Oct 12, 2016 7:48 am
Forum: XSLT and FOP
Topic: How do I show output for protection order?
Replies: 0
Views: 2423

How do I show output for protection order?

My template is correctly displaying output when any CasePartyName has an Op='E'. It is also correctly displaying output when any CaseParty/ObservedRace has an Op='E' or CaseParty/ObeservedEthnicity has an Op='E' and Connection/@Word='RSP' Current output <NotificationEvent notificationType="CaseParty...
by winkimjr2
Thu Oct 06, 2016 6:25 pm
Forum: General XML Questions
Topic: How do I output 2 nodes with their children?
Replies: 1
Views: 2324

Re: How do I output 2 nodes with their children?

I do not need help for this........Thanks
by winkimjr2
Thu Oct 06, 2016 5:17 pm
Forum: General XML Questions
Topic: How do I output 2 nodes with their children?
Replies: 1
Views: 2324

How do I output 2 nodes with their children?

I am using a template to output NotificationEvent. My xml has 2 NotificationEvents. The problem is that I am not getting correct output Expected output <IntegrationConditions> <IntegrationCondition Word="CASEDETAIL" Description="CaseDetail/Security"> <NotificationEvent notificationType="CaseDetailsN...
by winkimjr2
Thu Jul 14, 2016 9:25 pm
Forum: General XML Questions
Topic: How add exception to xslt code?
Replies: 1
Views: 2413

How add exception to xslt code?

I have 4 TransactionTypeText being handled by xslt code which include TransactionTypeText='Charge', TransactionTypeText='Payment', TransactionTypeText='Credit', TransactionTypeText='Disbursement'. The problem is that, this code is not handling other types (TransactionTypeText) that are not one of th...
by winkimjr2
Mon Jun 13, 2016 7:54 pm
Forum: XSLT and FOP
Topic: How do I get the Status with the latest TimestampCreate?
Replies: 0
Views: 2897

How do I get the Status with the latest TimestampCreate?

I would like to get the Status with the latest TimestampCreate. How do I change my xslt to include the TimestampCreate instead of Date[/code]? My xml doc <?xml version="1.0" encoding="UTF-8"?> <Integration> <ProtectionOrder Op="E"> <Statuses> <Status Op="A"> <Active>No</Active> <Date Op="A">05/09/20...
by winkimjr2
Tue Sep 01, 2015 11:58 pm
Forum: XSLT and FOP
Topic: How do I display an Number attribute?
Replies: 0
Views: 2361

How do I display an Number attribute?

I have a xml document that I would like to display Number attribute from <CrossReferenceNumber> element In my xslt the Number is inside <ext:SupersededProtectionOrderID> element. Xml document can have <Type Op="A" Word="SBJO">Signed By Judicial Officer</Type> or <Type Op="A" Word="SBJO">Signed By Ju...
by winkimjr2
Tue Jun 02, 2015 8:26 pm
Forum: XSLT and FOP
Topic: How do I display CommercialVehicleFlag?
Replies: 0
Views: 2352

How do I display CommercialVehicleFlag?

I have modified this question by adding a more detailed xsl code showing two templates that I am using. CommercialVehicleFlag can be under Charge which is under Case or under Citation which is under Case. I want to check for CommercialVehicleFlag in both places that is under /Integration/Case/Charge...
by winkimjr2
Tue Jun 02, 2015 7:21 pm
Forum: XSLT and FOP
Topic: How do I display the most recent HearingDate?
Replies: 1
Views: 1261

Re: How do I display the most recent HearingDate?

I resolved this one

Code: Select all

<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>
by winkimjr2
Tue Jun 02, 2015 5:01 pm
Forum: XSLT and FOP
Topic: How do I display the most recent HearingDate?
Replies: 1
Views: 1261

How do I display the most recent HearingDate?

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 he...
by winkimjr2
Fri May 22, 2015 11:39 pm
Forum: XSLT and FOP
Topic: How do I get TicketDate from xml document?
Replies: 0
Views: 2374

How do I get TicketDate from xml document?

I would like to get TicketDate where ChargeID is the same as CitationCharge/ChargeID. There could be several ChargeIDs with several CitationIDs. So I will need to check where ChargeID matches CitationCharge/ChargeID so that I get the right TicketDate. Desired output should look like this <nc:Activit...
by winkimjr2
Mon May 11, 2015 9:25 pm
Forum: XSLT and FOP
Topic: How do I check State Code if it has four characters and then
Replies: 0
Views: 2340

How do I check State Code if it has four characters and then

What I am trying to do is check in the XML document for the element <DriversLicenseState Word="CDON">Ontario</DriversLicenseState>. If State word found has four characters and begins with ‘CD’ only display the last two characters. In this case (example) I would display <nc:JurisdictionCanadianProvin...
by winkimjr2
Fri May 08, 2015 4:40 pm
Forum: XSLT and FOP
Topic: How do I get TicketDate from xml doc?
Replies: 0
Views: 2403

How do I get TicketDate from xml doc?

What I want to do is use the xml document to get the TicketDate. The xml document could have more than one ChargeID. So I have to match the ChargeHistoryID a child of CitationCharge to the ChargeHistoryID a child of Charge. This ensures I get the right TicketDate for the right Charge and Citation. M...
by winkimjr2
Fri May 01, 2015 10:47 pm
Forum: XSLT and FOP
Topic: How do I loop through several Charges and then display value
Replies: 1
Views: 1304

How do I loop through several Charges and then display value

I have a xml document with several charges. I would like for each unique ChargeID evaluate the ChargeHistory records. If, Stage=”Disposition Event” is found verify the number of DispositionEventSequence. If only “1” populate Charge Information, otherwise use the highest DispositionEventSequence to p...
by winkimjr2
Mon Mar 23, 2015 8:42 pm
Forum: XSLT and FOP
Topic: How do I get GRD with lowest InternalPartyID?
Replies: 1
Views: 1434

Re: How do I get GRD with lowest InternalPartyID?

I have withdrawn this question. Should I delete it?
by winkimjr2
Thu Mar 19, 2015 11:57 pm
Forum: XSLT and FOP
Topic: How do I get GRD with lowest InternalPartyID?
Replies: 1
Views: 1434

How do I get GRD with lowest InternalPartyID?

I have xslt that I am running using xml doc and I want to display the GRD with the lowest InternalPartyID. The conditions are Find all Case/CaseParty/Connection@Word='GRD' and Case/CaseParty/Connection/RemoveDate does not exist. Then select CaseParty that has the lowest CaseParty@InternalPartyID. Af...
by winkimjr2
Mon Mar 02, 2015 9:28 pm
Forum: XSLT and FOP
Topic: I want to omit addressLine1 if Address element attribute has
Replies: 2
Views: 1795

I want to omit addressLine1 if Address element attribute has

If the type attribute of the Address element = “Standard With Attention” I do not want to display AddressLine1. Instead I want to only display AddressLine2, AddressLine3 and AddressLine4. My output: Attn: Michael, 134 W Broadway ST NW, APT 3B, Washington, DC, 12345 Expected output: 134 W Broadway ST...
by winkimjr2
Mon Mar 02, 2015 7:27 pm
Forum: XSLT and FOP
Topic: I do not want to display a comma after last element
Replies: 5
Views: 2790

Re: I do not want to display a comma after last element

Patrik, when I used this

Code: Select all

<xsl:value-of select="string-join((AddressLine1, AddressLine2, AddressLine3, AddressLine4), ', ')"/>
line of code in my xslt, I received this error:

XSL transformation failed due to following error: Expected token ')' found ','.
How do I resolve this?
by winkimjr2
Mon Mar 02, 2015 5:40 pm
Forum: XSLT and FOP
Topic: I do not want to display a comma after last element
Replies: 5
Views: 2790

Re: I do not want to display a comma after last element

Thanks to both lief.erickson and Patrik. I adopted lief.erickson solution and my problem has been solved!
by winkimjr2
Fri Feb 27, 2015 9:59 pm
Forum: XSLT and FOP
Topic: I do not want to display a comma after last element
Replies: 5
Views: 2790

I do not want to display a comma after last element

In my schema I have AddressLine1, AddressLine2, AddressLine3 and AddressLine4. When address is added to each AddressLine a comma is inserted to separate the AddressLines. However if only AddressLine1 and AddressLine2 have address, then there should not be a comma after the AddressLine2 because there...
by winkimjr2
Fri Feb 06, 2015 11:22 pm
Forum: XSLT and FOP
Topic: How do I find ChargeID for the Plea using InternalOffenseHis
Replies: 2
Views: 1836

Re: How do I find ChargeID for the Plea using InternalOffens

I have resolved this by adding 2 variables. XSLT code <xsl:variable name="vInternalOffenseHistoryID"> <xsl:value-of select="//Charge[@ID=$pChargeID]/ChargeHistory[@Stage='Plea Event'][last()]/@InternalOffenseHistoryID"/> </xsl:variable> <xsl:variable name="vPleaEventID"> <xsl:value-of select="//Plea...
by winkimjr2
Fri Feb 06, 2015 6:58 pm
Forum: XSLT and FOP
Topic: How do I find ChargeID for the Plea using InternalOffenseHis
Replies: 2
Views: 1836

Re: How do I find ChargeID for the Plea using InternalOffens

What I am trying to do is get the ChargeID=10485838 . To get this ChargeID, I need to look in the ChargeHistory element for the Stage="Plea Event" and find the PleaEventSequence value with the highest event number (for example PleaEventSequence="2") and then find the Plea in the PleaEvent node whos...
by winkimjr2
Thu Feb 05, 2015 10:06 pm
Forum: XSLT and FOP
Topic: How do I find ChargeID for the Plea using InternalOffenseHis
Replies: 2
Views: 1836

How do I find ChargeID for the Plea using InternalOffenseHis

What I am trying to do is to use InternalOffenseHistoryID to find and display Plea's ChargeID . I need to find the PleaEventSequence with the highest number (example 2) in ChargeHistory and then find the Plea's InternalOffenseHistoryID that matches that ChargeHistory's InternalOffenseHistoryID . How...
by winkimjr2
Mon Jan 05, 2015 9:32 pm
Forum: XSLT and FOP
Topic: How do I add false to a empty string?
Replies: 1
Views: 1454

Re: How do I add false to a empty string?

I fixed this by doing this:

Code: Select all

<xsl:attribute name="ext:currentIndicator">
<xsl:choose>
<xsl:when test="@PartyCurrent = 'true'">true</xsl:when>
<xsl:otherwise>false</xsl:otherwise>
</xsl:choose>
</xsl:attribute>
by winkimjr2
Fri Jan 02, 2015 7:19 pm
Forum: XSLT and FOP
Topic: How do I add false to a empty string?
Replies: 1
Views: 1454

How do I add false to a empty string?

I would like to display the word false instead of an empty string "" for the <ext:AddressReference ext:currentIndicator=""> . How do I do this? My output which is wrong <ext:AddressReference ext:currentIndicator="true"> <nc:LocationReference s:ref="INT10566286"/> </ext:AddressReference> <ext:Address...
by winkimjr2
Wed Dec 31, 2014 5:00 pm
Forum: XSLT and FOP
Topic: How do I display PersonEthnicityCode for the Respondent
Replies: 2
Views: 1755

Re: How do I display PersonEthnicityCode for the Respondent

sorin wrote:Hello,

There are many XSLT experts available on this mailing list who can help you with that. Did you try posting the example code there?
I did not know about that mailing list. I will post my question there. Thank you.
by winkimjr2
Wed Dec 31, 2014 12:13 am
Forum: XSLT and FOP
Topic: How do I display PersonEthnicityCode for the Respondent
Replies: 2
Views: 1755

How do I display PersonEthnicityCode for the Respondent

I have xml code with several CaseParties. I want to only display the ObservedEthnicity for the respondent. My xslt is displaying the ObservedEthnicity but for the first found CaseParty. How do I change it to display the correct ObservedEthnicity for the respondent? Here is my xml code <Integration x...
by winkimjr2
Tue Dec 30, 2014 9:47 pm
Forum: XSLT and FOP
Topic: How do I display PersonEthnicityCode
Replies: 1
Views: 1377

How do I display PersonEthnicityCode

In my xml I have an element <ObservedEthnicity Word="R">Refused</ObservedEthnicity> but I do not want it displayed in the output. What do I need to change in my xslt so that this is skipped? Right now it is being displayed in the output as this: <ext:Respondent> <nc:PersonEthnicityCode>R</nc:PersonE...