How to query glide list

[Raghu9]

Hi,

I am trying to query a Glide list field in group table.

I am trying to print list of records whose group type is not catalog. Here group type is glide_list.

How to achieve this.

[Raghu9]

Hi,

No luck. It is not working.

[Alikutty A]

It did work for me, What issue you are facing?

[Alikutty A]

I tried this from background scripts module and it returned me all groups with empty types and types which are not catalog

var group = new GlideRecord("sys_user_group");
group.addEncodedQuery("typeISEMPTY^ORtypeNOT LIKE74af88c6c611227d0066386e74dc853d");
group.query();
while(group.next()){
gs.log(group.name  + "-"+ group.manager.getDisplayValue() + "-" +group.type.getDisplayValue());
}