Work items query support both work item type fields
Background
With [Cells 1.0] Default Work Item Types: Ensure wor... (&15272 - closed) we need to make sure values from work_item_types.id are sequential values 1 - 9. This affects the issues table, as we currently have a foreign key issues.work_item_type_id that relies on these values.
The work items index indexes the work_item_type_id field and will need to adjust to accommodate ensuring work item type IDs are constant sequential 1-9 values.
Proposal
- change search
by_work_item_type_idsfilter to do an should (OR) operation to look for bothwork_item_type_idorcorrect_work_item_type_id- this will need to be done for both types of options
not_work_item_type_idsandwork_item_type_ids
- this will need to be done for both types of options
- validate search, aggregation, filters work
- Update specs as needed
Edited by Terri Chu