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

#10367 [Quality Management] Add OptimizeForTextSearch to searchable Qlty. Inspection Header fields (AB#620381)

Two searchable fields in Quality Management's Inspection Header table now use optimized text search to improve performance on large datasets.

Open in Claude10367.mdPull request #10367

Pull request · merged into main (BC30) on 2026-08-19 by alexei-dobriansky · 1 file (+2 -0), 1 AL · performance · tier official · reviewed (checked by Opus)

What changed

  • Added OptimizeForTextSearch property to Description and Source Task No. fields
  • Enables optimized SQL search path instead of unindexed LIKE scans
  • Improves list-page search performance
  • Aligns Source Task No. with sibling source-identity fields
  • Metadata-only change with no behavior or data impact

AL objects touched

Context

  • Work items: AB#620381
  • Labels: AL: Apps (W1), Team: SCM
  • Systems: development

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