162 views

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:

  1. Navigate to Incident > All.
  2. Click the Personalize list icon .
  3. Add the Watch list column.
  4. 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:

  1. Navigate to System Definition > Dictionary.
  2. Create the filter [Table] [is] [kb_knowledge].
  3. Click Run.
  4. Click New.
  5. Create the following dictionary entry:
    • Type: List
    • Column Label: Type of Agent
    • Column Name: u_type_of_agent
  6. Click Submit.
  7. Navigate to Knowledge > All.
  8. Open any record.
  9. Right click on the Type of Agent field label.
  10. Select Configure Choices.
  11. Add three choice values.
  12. Click Save.
    An alternative to steps 7-12 is to add hard-coded choice values on the Type of Agent sys_dictionary record.
  13. In the Type of Agent field, select an option from the choice list.
  14. Click Update.
  15. Navigate to Knowledge > All.
  16. 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:

KB0596181: Interacting with a Glide List field


Related Problem: PRB624779

Seen In

Dublin Patch 7 Hot Fix 3

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2017-08-22 00:10:39
Published:2017-03-22