Skip to content
Pardaan.com Pardaan.com

If your work becomes your passion…

  • Home
  • Profile
  • Tags
  • LinkedIn
  • Facebook
  • X

Query

  • Home
  • Query
Posted inDynamics NAV & BC Tips & tricks

A forgotten corner of AL, saving Query Output

In this video, I travel down a rabbit hole while exporting BC data as JSON. Some operations in AL have not been modernized, so in order to accomplish my goal, I need to add a bit of creativity. Check out the video: Source : Hougaard.com Read…
Read More
12 June 2024
Posted inDynamics NAV & BC Tips & tricks

Can I query half a record in AL?

For decades, we have always retrieved full records from the database. Now we got an option to only query the fields we need. Check out this video: Source : Hougaard.com Read more...
Read More
12 October 2022
Posted inDynamics NAV & BC Tips & tricks

How to use the Query object as an API in Business Central

Queries are a compelling object type within Business Central, as they allow us to retrieve records from one or more tables and then combine them in rows and columns into a single dataset. This object type also allows you to perform calculations such as limiting the…
Read More
6 October 2022
Posted inDynamics NAV & BC Tips & tricks

Use a Query Object if you have an urge for SQL in Business Central

The Query Object is often overlooked in Business Central, but it does give SQL’ish access to creating queries, check it out: Source : Hougaard.com Read more...
Read More
25 August 2022
Posted inDynamics NAV & BC Tips & tricks

D365 Business Central : Using Query to Get Distinct Values

When working with table data, there will be times when we need to retrieve a unique record value from the table (also called SELECT DISTINCT). Unfortunately, D365 Business Central does not provide this logic out of the box. We will need to find a way to…
Read More
10 August 2022
Posted inDynamics NAV & BC Tips & tricks

Query Object: How Does It Work In Business Central?

In this post you will learn how to build a simple query in Microsoft Dynamics 365 Business Central. How to create advanced queries and how to use them via AL. Also, we will take a look at API queries and how to create them. Source :…
Read More
12 July 2022
Posted inDynamics NAV & BC Tips & tricks

Do you know what a QueryCategory is?

Here’s a cool little trick to use Query Objects to create user interface, check it out: Source : Hougaard.com Read more...
Read More
4 July 2022

Posts pagination

1 2 3 … 11 Next page

Menu
  • Profile
  • Tags
Categories
  • Data & Analysis
  • Dynamics NAV & BC
    • Functional
    • General
    • Technical
    • Tips & tricks
  • ERP general
  • Information management
  • Off-topic
  • Projectmanagement
  • Quote of the week
  • Visual C# / ASP.net
Stay Hungry, Stay Foolish
RSS Mibuso
  • How to call a procedure in Business Central from Power Automate
  • How to transfer custom field from service order , service line (items) to Warehouse Entry Table
  • Advice needed: Switching to AL-GO Github?
  • "all of your selections were processed" BC message
  • How to implement OIOUBL 2.1 in NAV 2017 (codeunit 13609)
  • Missing Codeunit 9998 and 9999 of Upgrade Routine NAV2017 to BC 14 Spring 19
  • How can I change my Mibuso E-mail address in my user profile?
  • Tenant Media
  • Amount on Check Ledger Entry does not match amount on Bank Account Ledger Entry
  • GST calculation issue
  • To provide Vendor Payment Bank upload file
  • Deepinserts not working
  • Adding new field to Base App Drop down field group view
  • Adding a new lookup field with a TableRelation to CRM Integration Table
  • Appending to the end of a file - BC v14, C/AL
  • How to save an ANSI file from Business Central?
  • E-Mails gets send but not moved to table Sent E-Mail
  • A part of page 13 Email Editor is not shown for some users, but for others
  • How to get Hash Certificate as Base 64 String in MS BC SaaS
  • What are the best AI coding IDEs for AL code
RSS Dynamics NAV Team Blog
  • Get started with agents for finance: Learnings from 2025 Gartner® CFO & Finance Executive Conference
  • The power of proactive engagement in Dynamics 365 Contact Center
  • Seamless scheduling across time zones in Dynamics 365 Field Service
  • Explore migration options for Microsoft Dynamics GP and Microsoft Dynamics SL customers
  • Unlock the power of record routing with real-time analytics
  • Agentic CRM systems: Learnings from organizations making the switch
  • Under the Hood: Building an AI-Driven Storefront with Dynamics 365 Commerce 
  • AI-powered proactive engagement and conversational journeys with Microsoft Dynamics 365 in public preview
  • Improve contact center operations with shift-based routing
  • Intent-based routing transforms customer support with AI
RSS Power BI
  • Open and edit any semantic model with Power BI tools
  • Power BI June 2025 Feature Summary
  • What’s New in SQL Server 2025 Analysis Services
  • Now available: two new Copilot experiences
  • Your Road to Power BI Certification Starts Here
  • Power BI Report Server May 2025 Feature Summary
  • Power BI May 2025 Feature Summary
  • The next era of Copilot in Power BI: Chat with your Data (Preview)
  • Translytical task flows (Preview)
  • Deep dive into selection expressions for calculation groups
Scroll to Top