WorkItem filter comparison for GLQL and Advanced search

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

• Close this issue

Background

There is a proof of concept to hook GLQL to Advanced search in #524326 (closed)

For GLQL to fully utilize advanced search, all existing filters will need to be available. This issue documents the current state for work items

Comparison

GLQL filter list: https://docs.gitlab.com/user/glql/fields/

WorkItem search mappings: https://gitlab.com/gitlab-org/gitlab/blob/26f246180df48f1296a66d38cfa3975b92b24318/ee/lib/search/elastic/types/work_item.rb#L77-77

filter name	GLQL	GLQL operators	advanced search	advanced search operators
Type	type	=, in	work_item_type_id	in , !in
Assignees	assignee	=, in, !=	assignee_id ❗note: indexed as array of ids, not available in search
Author	author	=, in, !=	author_id	=, !=
Cadence	cadence	=, in, !=	❌
Closed at	closed	=, >, <	❌
Confidential	confidential	=, !=	confidential	=
Created at	created	=, >, <	created_at ❗note: indexed but not available in queries
Due date	due	=, >, <	due_date ❗note: indexed but not available in queries
Group	group	=	namespace_id	=
Health status	health	=	❌
Id	id	=, in	id note: iid is also available	=
Include subgroups	includeSubgroups	=, !=	Group searches always search in the sub group hierarchy
Iteration	iteration	=, in, !=	❌
Labels	label	=, in, !=	label_ids note: label ids are stored in an array	in
Milestone	milestone	=, in, !=	❌
Project	project	=	project_id	=
State	state	=	state	=
Updated at	updated	=, >, <	updated_at ❗note: indexed but not available in queries
Weight	weight	=, !=	❌