XMLPort Element Skip

pferreira
Member Posts: 22
Hi,
I have the following issue:
I have an XMLPort with this structure:

I wan to to export a document, and the values are filled with "code-behind".
When the "Percent" has the value of 0 I would like to bypass the hole "itemallowancesorcharges".
I've tried evaluating the value of "Percent" and do currXML.SKIP, but this makes me get on a loop... and the document doesn't stop it's growth!
My question is... how can I bypass the itemallowancesorcharges?
I have the following issue:
I have an XMLPort with this structure:

I wan to to export a document, and the values are filled with "code-behind".
When the "Percent" has the value of 0 I would like to bypass the hole "itemallowancesorcharges".
I've tried evaluating the value of "Percent" and do currXML.SKIP, but this makes me get on a loop... and the document doesn't stop it's growth!
My question is... how can I bypass the itemallowancesorcharges?
0
Comments
-
One suggestion is to make ItemAllowancesOrCharges element related to a table. It could be related to the Number table and then you could just apply filters to control how many records (i.e. how many copies of the element) are put in the file. This filter (i.e. decision to export) must be made before the opening tag of that element is created.
//Assume itemNumberTable is the variable name assigned //to ItemAllowancesOrCharges element if Percent = '0' then itemNumberTable.setrange(number,1,1) else itemNumberTable.setrange(number,1,0);
Note I haven't actually experimented with this particular case but this is the first thing that I would try.0 -
jlandeen,
Didn't understand your solution.
I think I'll go with a KISS solution. Replicate the XMLPort delete the itemallowancesorcharges element, and evaluate the "Percent" field before calling anyXMLPort so it "routs" to the correct one.
A bit to much "KISS" but.. it will do the job! :whistle:0 -
My KISS solution turns out to be a bit to much "stupid" #-o
I was thinking about it, and it won't do! On the same file, I can have records that must have that element and others that don't. ](*,)0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions