BC Observatoryunofficial, made by waldo
code change · featureAL Developmentofficial - Microsoftreviewed - checked by Opus

#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.

Open in Claude186.mdPull request #186

Pull request · 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).