---
id: post/aardvarklabs-blog/1822
type: post
title: "Business Central Queries: Simplifying Complex Data"
summary: Business Central Query objects allow developers to combine data from multiple tables using joins and filters, similar to SQL queries. Queries simplify complex data retrieval by defining linked data items with columns and join types, and can be exposed in Business Central for analysis and reporting.
tier: community
language: en
tags:
  - queries
  - data retrieval
  - joins
  - al development
  - tables
  - reporting
system: development
review:
  state: reviewed
  by: opus
  at: "2026-10-08T02:00:31.053Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-post: 1
  input_hash: c5580e42d470767b2888f75e135ed7598f308efc4a26f81c514cedeea973480d
evidence:
  - kind: blog
    url: https://aardvarklabs.blog/2025/06/27/business-central-queries-simplifying-complex-data/
    title: "Business Central Queries: Simplifying Complex Data"
    date: "2025-06-27"
    commit: null
    t: null
    quote: null
  - kind: blog
    url: https://aardvarklabs.blog/2025/06/27/business-central-queries-simplifying-complex-data/
    title: "Business Central Queries: Simplifying Complex Data"
    date: "2025-06-27"
    commit: null
    t: null
    quote: Queries are a nested set of linked and filtered data items.
  - kind: blog
    url: https://aardvarklabs.blog/2025/06/27/business-central-queries-simplifying-complex-data/
    title: "Business Central Queries: Simplifying Complex Data"
    date: "2025-06-27"
    commit: null
    t: null
    quote: Left is the parent Data Item and Right is the dependent Data Item.
links:
  learn: []
  objects:
    - object/table/18
    - object/table/21
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
post_id: "1822"
source_id: aardvarklabs-blog
source_name: Aardvark Labs
url: https://aardvarklabs.blog/2025/06/27/business-central-queries-simplifying-complex-data/
published_at: "2025-06-27T12:00:00.000Z"
author: Marcel Chabot
full_text: false
words: 1231
quotes:
  - text: Queries are a nested set of linked and filtered data items.
    why_it_matters: This defines the core concept of how queries work as the fundamental unit for multi-table data retrieval
  - text: Left is the parent Data Item and Right is the dependent Data Item.
    why_it_matters: Understanding the directional concept of joins in Business Central is critical for developers to write correct query syntax
code_objects_mentioned:
  - query ARD_CustomerLedger
  - table Customer
  - table Cust. Ledger Entry
systems:
  - development
  - reporting
versions_mentioned: []
preview:
  embeddable: true
  frame_url: https://aardvarklabs.blog/2025/06/27/business-central-queries-simplifying-complex-data/embed/
  image: https://aardvarklabs.blog/wp-content/uploads/2025/06/querybot.jpeg
  image_alt: null
  image_w: 768
  image_h: 768
  site_name: Aardvark Labs
  favicon: https://aardvarklabs.blog/wp-content/uploads/2024/04/design-1.png?w=32
  probed_at: "2026-10-07T11:51:57.997Z"
---

# Business Central Queries: Simplifying Complex Data

[Read the post](https://aardvarklabs.blog/2025/06/27/business-central-queries-simplifying-complex-data/) · Aardvark Labs (Marcel Chabot) · 2025-06-27 · 1231 words · tier community · reviewed (checked by Opus)

> Business Central Query objects allow developers to combine data from multiple tables using joins and filters, similar to SQL queries. Queries simplify complex data retrieval by defining linked data items with columns and join types, and can be exposed in Business Central for analysis and reporting.

## Key points

- Query objects let AL developers combine and filter data from several tables, giving some SQL-like capabilities without direct SQL access
- A query starts with a source data item, and dependent data items are attached using DataItemLink, DataItemTableFilter and SqlJoinType
- Left means the parent data item and Right means the nested dependent one; the post covers inner, left outer, right outer, full outer and cross joins
- The example query joins Customer with Cust. Ledger Entry using a left outer join, filtered to invoices and credit memos
- With UsageCategory set, the query can be found through Tell Me, exported to Excel or analyzed in pivot mode

## Quotes

- "Queries are a nested set of linked and filtered data items." (This defines the core concept of how queries work as the fundamental unit for multi-table data retrieval)
- "Left is the parent Data Item and Right is the dependent Data Item." (Understanding the directional concept of joins in Business Central is critical for developers to write correct query syntax)

## AL objects mentioned

As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.

- query "ARD_CustomerLedger"
- [table 18 "Customer"](../../objects/table/18.md)
- [table 21 "Cust. Ledger Entry"](../../objects/table/21.md)

Not found in BC28-30: query "ARD_CustomerLedger".

## Context

- Features: Query objects, Data item linking, SQL join types, Table filtering, Column definition, Pivot analysis, Excel export

Source: Aardvark Labs, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.