Description
A list (glide_list) with a choice list cannot be filtered.
Steps to Reproduce
On a Helsinki or Istanbul instance using the List v3 plugin:
- Navigate to Incident > All.
- Click the Personalize list icon
.
- Add the Watch list column.
- Expand the quick search filter.
Note that the Watch list is grayed out and not searchable.
On a Fuji or Geneva instance using the List v2 plugin:
- Navigate to System Definition > Dictionary.
- Create the filter [Table] [is] [kb_knowledge].
- Click Run.
- Click New.
- Create the following dictionary entry:
- Type: List
- Column Label: Type of Agent
- Column Name: u_type_of_agent
- Click Submit.
- Navigate to Knowledge > All.
- Open any record.
- Right click on the Type of Agent field label.
- Select Configure Choices.
- Add three choice values.
- Click Save.
An alternative to steps 7-12 is to add hard-coded choice values on the Type of Agent sys_dictionary record. - In the Type of Agent field, select an option from the choice list.
- Click Update.
- Navigate to Knowledge > All.
- Attempt to filter on: [Type of Agent] [is] [<anything>].
Note the following errors:- Page not found
- The page you are looking for could not be found.
Workaround
This is expected behavior. All glide_list fields (for example, Watch list) need a reference value to a table and cannot be used in the quick filter list view (they appear grayed out).
Glide List columns can be queried in a list expanding the breadcrumb filter with only the operators 'is [not] empty' and '[does not] contain'.
The following article contains an example script that can be used to implement a more advanced filter on a Glide List:
Related Problem: PRB624779