Filtering on a field you are not exporting in XMLport
troy.harkness@hotmail.com
Member Posts: 11
Let me preface this by saying I am a beginner with XMLPorts and the supporting code. I see it I get it but I cannot always get it to do what I want.
I am trying to figure out how to export data using a filter but I do not want the field that I am filtering on to be exported.
Here is my example
I want to export Purchase Header data filter on Document Type. I do not want or need the Document Type field exported. This data will be passed to another program that cannot handle the Document Type field. The Document Types that I want to export are; Order, Credit Memo and Return Order.
Thank you,
Troy
I am trying to figure out how to export data using a filter but I do not want the field that I am filtering on to be exported.
Here is my example
I want to export Purchase Header data filter on Document Type. I do not want or need the Document Type field exported. This data will be passed to another program that cannot handle the Document Type field. The Document Types that I want to export are; Order, Credit Memo and Return Order.
Thank you,
Troy
0
Best Answer
-
I have my solution.
Once you add the Table Element in the Properties window you can Filter and Sort the Table in "SortTable" property.
Thank you Suresh for the help on this one.1
Answers
-
I have my solution.
Once you add the Table Element in the Properties window you can Filter and Sort the Table in "SortTable" property.
Thank you Suresh for the help on this one.1
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K 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
- 323 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