Search found 62 matches

by winkimjr2
Fri Aug 09, 2019 3:15 pm
Forum: XSLT and FOP
Topic: How do I add conditions to XSLT if statement
Replies: 4
Views: 179

Re: How do I add conditions to XSLT if statement

Thank you so much Adrian. I spent 3 days on this and your code is now working as expected. you have no idea how happy and satisfied I am right now! You are a miracle worker.
by winkimjr2
Fri Aug 09, 2019 7:04 am
Forum: XSLT and FOP
Topic: How do I add conditions to XSLT if statement
Replies: 4
Views: 179

Re: How do I add conditions to XSLT if statement

Hi Adrian, I was also asked to return true when CompDate has @Op="E" or "A". So the above XML should return false because TimeStampChange has an @Op="E" and CompDate has @Op="E". I tried the following but it is returning true instead of false. Please help. <xsl:if test="(@Op='E') and (((CompDate[@Op...
by winkimjr2
Wed Aug 07, 2019 4:45 pm
Forum: XSLT and FOP
Topic: How do I add conditions to XSLT if statement
Replies: 4
Views: 179

How do I add conditions to XSLT if statement

How do I check TimeStampChange node is the only node with Op code AND in CaseEvent there are no Op codes on any other child nodes? i.e. CaseEvent\TimeStampChange Op="E" and there are no Op codes on any other child elements. If statement will be True when TimeStampChange is the only node in CaseEvent...
by winkimjr2
Mon Aug 05, 2019 7:25 pm
Forum: General XML Questions
Topic: How do I add conditions to xslt?
Replies: 0
Views: 155

How do I add conditions to xslt?

I have a xslt that I need help with. How do I check CompDate has an @Op of E or A? OR TimeStampChange is the only element with @Op code AND CaseEvent has no CompDate child element i.e. \Integration\Case\CaseEvent\TimeStampChange@Op='E' and CompDate does not exist Here is the xml that I am reading <I...
by winkimjr2
Wed Jul 03, 2019 10:49 pm
Forum: General XML Questions
Topic: How do I fix xslt if condition?
Replies: 3
Views: 328

Re: How do I fix xslt if condition?

I think my solution is this
<xsl:if test="((/Integration/ControlPoint/@UserID!='Integration_Admin') and (/Integration/ControlPoint/@UserID!='IntegrationAdmin'))">

I should not use the word or between the two conditions.
by winkimjr2
Wed Jul 03, 2019 10:37 pm
Forum: General XML Questions
Topic: How do I fix xslt if condition?
Replies: 3
Views: 328

Re: How do I fix xslt if condition?

I think I had posted wrong xml document. Here is the correct xml document code <Integration xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:tsg="http://tsgweb.com" xmlns=""> <ControlPoint Timestamp="7/2/2019 3:38:03 PM" UserID="IntegrationAdmin">SAVE-PR-EVENT</ControlPoint> <Case xmlns:user="http...
by winkimjr2
Wed Jul 03, 2019 12:40 am
Forum: General XML Questions
Topic: How do I fix xslt if condition?
Replies: 3
Views: 328

How do I fix xslt if condition?

I have a simple xml document. I want to check if UserID is not equal to IntegrationAdmin or Integration_Admin My xslt is Here is the sample xml document <Integration xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:tsg="http://tsgweb.com" xmlns:IXML="http://tsgweb.com" xmlns=""> <ControlPoint Time...
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: 395

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: 457

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: 2458

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: 2364

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: 2364

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: 2460

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: 2931

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: 2398

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: 2407

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: 1300

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: 1300

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: 2411

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: 2372

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: 2471

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: 1342

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: 1466

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: 1466

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: 1841

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: 2907

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: 2907

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: 2907

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: 1889

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...