How to fetch data in Part type page using a Query in NAV?

First question is why query? Lets see the advantage of queries.
1.First you can limit the amount of data you retrieve from the server by defining only the specific columns you need
2.You can join multiple tables into one query saving loop code pattern.
3.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

Bron : Chris D’silva’s Blog
Lees meer…

How To Tell Whether Query Folding Is Taking Place When Importing Data From Analysis Services In Power BI And Excel Power Query

As a quick follow-on from last week’s post on how to detect whether query folding is taking place when importing from OData data sources, if you’re importing data from Analysis Services you have a similar problem: how do you know whether query folding is taking place? Ensuring that query folding takes place for as many of the steps in your query – especially those that filter or otherwise reduce the amount of data returned – is very important for data refresh performance.

Bron : Chris Webb’s BI Blog
Lees meer…

Procedure to create a custom Cue based on a query and a normal field in Dynamics NAV

To show visual representation of aggregated data in Microsoft Dynamics NAV client, tiles are created in NAV which are called Cues. Cues are more user-friendly. It helps the user to get quick details of aggregated data like the total number of open sales orders, total number of customers with a particular status, etc.

Bron : Cloudfronts
Lees meer…