Filtering page API

AitorEG
Member Posts: 342
Hi everyone,
I've published a page that is consumed from an external application. The source table of this page, is "Item".
I need to aplly one filter, not to send al the items to the external aplication. The filters logic is this:
Thank you all, and merry christmas!!
I've published a page that is consumed from an external application. The source table of this page, is "Item".
I need to aplly one filter, not to send al the items to the external aplication. The filters logic is this:
IF "Item Category Code" = 'XXX' THEN SETFILTER("Product Group Code",'<>%1&<>%2&<>%3','00','100','99');I don't want to send items from category XXX and with the indicated product group code. Where and how can I locate that filter?
Thank you all, and merry christmas!!
0
Best Answer
-
Hi,
You can use the "SourceTableTemporary" of the page. Set this property to TRUE and then populate the temporary table with the lines you need, by looping through your records and applying the above logic.
Regards5
Answers
-
Hi,
You can use the "SourceTableTemporary" of the page. Set this property to TRUE and then populate the temporary table with the lines you need, by looping through your records and applying the above logic.
Regards5 -
Thanks for your answer. We finally solved this issue withoutneeding the filters, but I will make a research on what you are talking about, seems really interesting...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