Query – Page 2 – Pardaan.com

Business Central API – Filter Child Array Values Using $filter Query Option

I had a difficult time finding an example of this type of API filtering using the OData $filter query option, so I wanted to share an example that I needed for a project. For context, this is a very simple example of a Business Central API…

24 December 2021

Dynamics NAV & BC Tips & tricks

Calling GraphQL queries in Dynamics NAV using RESTSharp

In my last project I had, once again, the task to develop an external webservice connection. The goal was to fetch orders from an external interface in dynamics nav and write back some states. In itself this is of course a simple story. Source : Jens…

29 November 2021

Dynamics NAV & BC Tips & tricks

Views and Queries in Business Central

While reviewing options to alter existing queries, I felt trap to the fact that now queries do not need a new page to display results, but can be connected to existing List pages. Below, highlighted are all queries connected to Customer List page. Source : NAV…

21 May 2021

Data & Analysis

Using Power BI Dynamic M Parameters In DAX Queries

As I’m sure you’ve guessed by now I’m a big fan of dynamic M parameters in Power BI. They’re easy to use in Power BI Desktop but what if you want to use them in your own DAX queries? Documentation for this is coming soon, but…

17 December 2020

Dynamics NAV & BC Tips & tricks

Inline Query | SQL like Queries in Business Central

Inline Query is a library that can execute SQL like Queries in Business Central AL Language. This is a small compiler in AL that compiles and executes SQL like queries in text constants or text variables. Source : msnJournals Read more...

19 November 2020

Dynamics NAV & BC Tips & tricks

Business Central Execute Queries from Pages

With the QueryCategory property we can execute a query object from a page (also available in Smartlists) by defining a query in AL; it is possible to declare with a comma separated list where the object can be used, in practice it is added to the…

22 October 2020

Data & Analysis

View Native Query Now Works For Analysis Services Data Sources

If you’re familiar with the topic of query folding in Power Query, you’ll know that the View Native Query right-click option in the Applied Steps pane of the Power Query Editor can be used to show the native query that is run against the data source.…

13 October 2020