Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Query building questions
grouic
Member Posts: 34
Hello,
I have to questions about queries :
- Is it possible to allow a user to run a query in RTC ? I can't add an Item in menusuite with type Query (I got an error when saving). Type Query is not allowed on page control actions neither.
- How to filter on a date in the dataItem filter ? If I put >=WORKDATE, the system replace WORKDATE with the hard value of today ...
Thx for the help,
Grouic
I have to questions about queries :
- Is it possible to allow a user to run a query in RTC ? I can't add an Item in menusuite with type Query (I got an error when saving). Type Query is not allowed on page control actions neither.
- How to filter on a date in the dataItem filter ? If I put >=WORKDATE, the system replace WORKDATE with the hard value of today ...
Thx for the help,
Grouic
0
Answers
1) Create a buffer table that you can use as a temporary table - this should have all the fields that are returned by your query
2) Create a page to run the query and the show the results. The SourceTable property should be set to your buffer table and the SourceTableTemporary should be set to "yes"
3) In the OnPageOpen Trigger you would have a variable for your query object, set the filter using SETFILTER on the appropriate field of your query object and then call the OPEN method and READ all entries and then insert records to the Rec variable (which is your temporary table)
4) Add the page to your menusuite