---
id: change/bcapps/10367
type: change
title: "#10367 [Quality Management] Add OptimizeForTextSearch to searchable Qlty. Inspection Header fields (AB#620381)"
summary: Two searchable fields in Quality Management's Inspection Header table now use optimized text search to improve performance on large datasets.
tier: official
language: en
tags:
  - performance
  - main
  - bc30
  - table qlty. inspection header
system: development
review:
  state: reviewed
  by: opus
  at: "2026-10-08T02:08:11.545Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-change: 1
  input_hash: de075302bfd10174bc8ec737e406112dbe546704
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/pull/10367
    title: "microsoft/BCApps#10367: [Quality Management] Add OptimizeForTextSearch to searchable Qlty. Inspection Header fields (AB#620381)"
    date: "2026-08-19"
    commit: de075302bfd10174bc8ec737e406112dbe546704
    t: null
    quote: null
links:
  learn: []
  objects:
    - object/table/20405
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes: []
number: 10367
repo: microsoft/BCApps
source_id: bcapps-prs
url: https://github.com/microsoft/BCApps/pull/10367
kind: pr
base_branch: main
major: "30"
merged_at: "2026-08-19T20:12:36Z"
author: alexei-dobriansky
author_type: User
community_contribution: false
labels:
  - "AL: Apps (W1)"
  - "Team: SCM"
change_class: code
change_kind: performance
behavior_change: false
breaking: false
files:
  count: 1
  additions: 2
  deletions: 0
  al: 1
apps:
  - Quality Management
objects_touched:
  - key: table/20405
    page: table/20405
    type: table
    id: 20405
    name: Qlty. Inspection Header
    app: Quality Management
    status: modified
objects_unjoined: []
obsoletions: []
backports: []
fixes_issues: []
work_items:
  - 620381
systems:
  - development
quote: null
joined_against:
  major: "30"
  commit: ecbc028c25dbe83b61313bc566e6c1d41184bb1c
---

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

[Pull request](https://github.com/microsoft/BCApps/pull/10367) · 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

- [Table 20405 "Qlty. Inspection Header"](../../objects/table/20405.md), Quality Management: modified

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