Wishing you all a happy and prosperous New year 2019!
First question is why query? Lets see the advantage of queries.
- First you can limit the amount of data you retrieve from the server by defining only the specific columns you need
- You can join multiple tables into one query saving loop code pattern.
- They are also light weight than Table Queries.
Below is the article which gives step wise procedure how to fetch data using a query and how to link it to a part page
Microsoft Dynamics NAV 2017
- Create a table with a field Entry No with datatype as Integer as primary key.
- I know what you are thinking… why a table ? A new table will cost me a customer licence but… hey! you would require a licence if you use it as a Temporary table. Yes, I’ll be using SourceTableTemporary property.
- So here, I’ve created a table as below. This table will be used as a Buffer so don’t worry about the cost
- Create a query using DataItem from where we will populate out temporary table.
- Finally create a page with SourceTableTemporary property set as Yes.
- Now, in my case I’m creating a this Part page for Page Purchase Order(50).So navigate to page 50 and add the part page as follows
- A call is made to a function in our custom Page Test Page from Page 50. The call is written on the trigger OnAfterGetCurrRecord. Here in the function only top 6 records should be visible
- Now launch Microsoft Dynamics NAV RTC and navigate to purchase order click on edit button of Purchase Order. The Test page will be visible.