Query – Page 8 – Pardaan.com

Using Query Object to Calculate the Cue Data

Today we will learn to create a query to update Cue data. Creating a Query for Calculating the Cue Data First, we will create a query object to calculate the number of open sales invoices from table 21 Cust. Ledger Entry. Bron : Ashwini Tripathi Lees…

25 August 2015

Dynamics NAV & BC Tips & tricks

Query and Excel Report – NAV2013

As you know Microsoft Excel has tremendous capabilities such as Formula, Chart, Power Pivot, Slicer, and Condition Format ... help you build stunning dashboards and reports. Now with our solution, user without programming skill can push data to Excel and make real time reports directly from…

16 July 2015

Dynamics NAV & BC Tips & tricks

Application Design Pattern: SELECT DISTINCT with Queries

This pattern explains how to perform SELECT DISTINCT by using queries in Microsoft Dynamics NAV. It is brought to you by Bogdana Botez from the Dynamics NAV team here at Microsoft Development Center Copenhagen (MDCC). When you work with tables, sometimes you must perform a SELECT…

9 March 2015

Dynamics NAV & BC Tips & tricks

Query-Based FactBoxes in Dynamics NAV 2013 R2

In this demonstration we will explore how to utilize query objects to provide visual statistical data in FactBoxes. For this purpose we will be using Dynamics NAV 2013 R2 version. Bron : Dynamics 101 Lees meer...

22 January 2015

Dynamics NAV & BC Tips & tricks

Using C/AL Query Objects Instead of Nested Loops

After a bit of a delay, here is the latest Microsoft Dynamics NAV design pattern, brought to you by the NAV Design Patterns team. Meet the Pattern This pattern shows how the new query object type introduced in Microsoft Dynamics NAV 2013 allows you to replace…

20 May 2014

Dynamics NAV & BC Tips & tricks

Table vs. Query | Performance Battle

NAV2013 introduced the Query object. Frankly I think that this new object type deserves more attention from bloggers. We have been nagging Microsoft for years to deliver this and now it is there and what happens? Quietness. I have at least two blogs around Queries. This…

16 September 2013

Dynamics NAV & BC Tips & tricks

TIP #35 | Using Queries in Pages & Reports

This post is an extention of the post I did yesterday about Queries and performance. As I said Queries deserve more attention. Unfortunately this is another post about what Queries cannot be used for, but with a workaround. Bron : Mark Brummel Lees meer...

12 September 2013