---
id: change/bcquality/186
type: change
title: "#186 Add Query filter semantics guidance"
summary: Documentation added explaining how DataItemTableFilter and ColumnFilter behave with runtime filters in queries, with examples and validation through the Query review skill.
tier: official
language: en
tags:
  - feature
  - main
system: development
review:
  state: reviewed
  by: opus
  at: "2026-10-08T02:05:03.351Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-change: 1
  input_hash: 861f53dd97fcc25cc797e79902884c7bbb612178
evidence:
  - kind: code
    url: https://github.com/microsoft/BCQuality/pull/186
    title: "microsoft/BCQuality#186: Add Query filter semantics guidance"
    date: "2026-09-15"
    commit: 861f53dd97fcc25cc797e79902884c7bbb612178
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes: []
number: 186
repo: microsoft/BCQuality
source_id: bcquality-prs
url: https://github.com/microsoft/BCQuality/pull/186
kind: pr
base_branch: main
major: null
merged_at: "2026-09-15T10:51:16Z"
author: demiliani
author_type: User
community_contribution: false
labels: []
change_class: code
change_kind: feature
behavior_change: false
breaking: false
files:
  count: 8
  additions: 225
  deletions: 3
  al: 7
apps: []
objects_touched: []
objects_unjoined:
  - path: microsoft/knowledge/query/dataitemtablefilter-cannot-be-overwritten-at-runtime.bad.al
    status: added
    reason: not-in-snapshot
  - path: microsoft/knowledge/query/dataitemtablefilter-cannot-be-overwritten-at-runtime.good.al
    status: added
    reason: not-in-snapshot
  - path: microsoft/knowledge/query/dataitemtablefilter-cannot-be-overwritten-at-runtime.md
    status: added
    reason: not-in-snapshot
  - path: microsoft/knowledge/query/setfilter-overwrites-query-columnfilter.bad.al
    status: added
    reason: not-in-snapshot
  - path: microsoft/knowledge/query/setfilter-overwrites-query-columnfilter.good.al
    status: added
    reason: not-in-snapshot
  - path: microsoft/knowledge/query/setfilter-overwrites-query-columnfilter.md
    status: added
    reason: not-in-snapshot
  - path: microsoft/skills/review/al-query-review.md
    status: modified
    reason: not-in-snapshot
obsoletions: []
backports: []
fixes_issues: []
work_items: []
systems:
  - development
quote: null
joined_against:
  major: null
  commit: null
---

# #186 Add Query filter semantics guidance

> Documentation added explaining how DataItemTableFilter and ColumnFilter behave with runtime filters in queries, with examples and validation through the Query review skill.

[Pull request](https://github.com/microsoft/BCQuality/pull/186) · merged into `main` on 2026-09-15 by demiliani · 8 files (+225 -3), 7 AL · feature · tier official · reviewed (checked by Opus)

## What changed

- DataItemTableFilter remains active when runtime filters target the same field
- Runtime SetFilter and SetRange calls overwrite ColumnFilter on the same query column
- Added focused bad/good AL code samples for both filter scenarios
- Integrated both checks into the Query review skill
- All Query knowledge articles now covered in review fixtures

## AL objects touched

- `microsoft/knowledge/query/dataitemtablefilter-cannot-be-overwritten-at-runtime.bad.al`: added, not in the BC? snapshot yet
- `microsoft/knowledge/query/dataitemtablefilter-cannot-be-overwritten-at-runtime.good.al`: added, not in the BC? snapshot yet
- `microsoft/knowledge/query/dataitemtablefilter-cannot-be-overwritten-at-runtime.md`: added, not in the BC? snapshot yet
- `microsoft/knowledge/query/setfilter-overwrites-query-columnfilter.bad.al`: added, not in the BC? snapshot yet
- `microsoft/knowledge/query/setfilter-overwrites-query-columnfilter.good.al`: added, not in the BC? snapshot yet
- `microsoft/knowledge/query/setfilter-overwrites-query-columnfilter.md`: added, not in the BC? snapshot yet
- `microsoft/skills/review/al-query-review.md`: modified, not in the BC? snapshot

## Context

- Systems: development

Source: metadata of a merged pull request in microsoft/BCQuality (bcquality): title, labels, changed paths and counts, with a summary in our words. No source text and no description beyond one short quote (D10, D61).