How to search, group, and sort on a Glide List field in a list view - Support and Troubleshooting

How to search, group, and sort on a Glide List field in a list view Issue .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Learn about the limitations of interacting with a Glide List (glide_list) field in a list view and how to work around them.

The following limitations apply to Glide List fields in a list view:

The search box at the top of the list is not available for Glide List fields, such as the Watch list field on Incident.

The Group By option is not available for a Glide List field. Alphabetical sorting is not available on a Glide List field.

Release .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } All supported releases

Cause .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } A Glide List (glide_list) field stores the sys_id values of referenced records, similar to a reference field. However, a Glide List field can store multiple sys_id values and email addresses as a comma-delimited string in the database.

For example, a script that retrieves the value of the Watch list field on an incident record returns output similar to the following:

*** Script: 62826bf03710200044e0bfc8bcbe5df1,5137153cc611227c000bbd1bd8cd2007,sampleuser@test.com

Because the field stores sys_id values rather than display values, searches using display values do not return results. For example, the query watch_listLIKEAbel Tuter does not match the stored value watch_listLIKE62826bf03710200044e0bfc8bcbe5df1 . For this reason, sorting is disabled on this field type.

This behavior also affects grouping. Grouping is based on the stored value, and no two records are guaranteed to have the same arrangement of referenced values. For example, one record might store Abel Tuter and David Loo in that order, while another record stores David Loo and Abel Tuter.

Resolution .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } There is no resolution to these limitations because of how Glide List fields store data. However, the following workarounds are available depending on what you are trying to achieve.

Searching

To search on a Glide List field in a list view:

Expand the list filter. Select the Glide List field to search. Only the following operators are available: contains, does not contain, is empty, and is not empty. Select an operator. In the reference search box, select a referenced record using the Lookup icon. Run the search. Note : If a Glide List field is displayed in the list view layout, the search results show all values stored in the Glide List field for each matching record, not just the value you searched for. The search is working as expected because it returns records where the Glide List matches the search criteria.

Grouping

To enable grouping on a Glide List field, add the can_group=true attribute to the field's dictionary entry. This makes the Group By option available.

Note : Because grouping is based on stored sys_id values and their order, the grouped output may not appear to be logically organized. See the Cause section for details.

Scripting

When working with Glide List fields in scripts, refer to the following product documentation:

Referencing a Glide list from a script Using indexOf("searchString") When filtering with addQuery or addEncodedQuery , search against the sys_id value rather than the display value. You can create a helper function that looks up the display value and returns the sys_id. The following example searches for incidents where Abel Tuter is on the Watch list:

var inc = new GlideRecord('incident'); inc.addEncodedQuery('watch_listLIKE' + getUserSID('Abel Tuter')); inc.query();

while (inc._next()) { gs.print(inc.number + " | " + inc.watch_list); }

function getUserSID(name) { var user = new GlideRecord('sys_user'); if (user.get('name', name)) { return user.sys_id; } }

To display the referenced record names instead of sys_id values, use the getDisplayValue function. For example, change:

gs.print(inc.number + " | " + inc.watch_list);

to:

gs.print(inc.number + " | " + inc.watch_list.getDisplayValue());

Related Links .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Add users to a watch list

Lists in the classic environment

Classic business rules