Add new fields in work_items index

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

• Close this issue

Problem to solve

Supporting the work items custom status implementation for advanced search: &17575 (comment 2480612473)

New fields must be added to Advanced search to support filtering work items by custom status

Proposal

Follow the documentation on how to add new fields to the work_items index, populate the new fields and keep the records in sync.

Note: Backfilling will happen in another issue

https://docs.gitlab.com/development/advanced_search/#adding-a-field

field	type
system_defined_status_id	long
custom_status_id	long
status_name	keyword

Technical notes

• System defined custom status changes must keep in sync with advanced search indexed data
  • Stored in an ITEMS constant and must be handled differently
  • When the values changes, it should be combined with an Advanced search migration to update all existing status_name fields for the changed system_defined_status_id. This will affect search and filtering by these fields. The search needs to send both fields in a SHOULD clause until the search migration is completed.
  • This information should be documented in: the code, gitlab contribution documentation about how to update system defined custom status. The documentation should be created as a part of this issue
• Custom defined fields must keep in sync with advanced search indexed data, these are regular association records and can use existing guidelines