How to dot walk a glide_list field?

Poompozhil
Tera Contributor

Hello,

 

How to dot walk a glide_list field in business rule

4 REPLIES 4

Anil Lande
Kilo Patron

Hi,

We cannot dot walk on glide_list field or List Collector variable.

Can you please share what exactly you are trying to achieve and what values you want read from referenced records?

 

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

Ankur Bawiskar
Tera Patron
Tera Patron

@Poompozhil 

you can't dot walk glide list field.

you need to query the table with the sysIds and then get the field value

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Ahmmed Ali
Mega Sage

Hello @Poompozhil 

 

You cannot dot walk on list type fields. You will need to query the reference table with sys_ids from the list field and then get the required data from there.

 

For example: if you want locations of all watchlist users, you will have to write a GlideRecord on user table with condition as sys_id IN WATCH_LIST_FIELD_VALUE, then read the location value from user table.

 

Let me know if I misunderstood the question.

 

Thank you,

Ali

 

If I could help you with your Query then, please hit the Thumb Icon and mark my answer as Correct!!

Thank you,
Ali

POOJA SINGH18
Mega Guru

Hi @Poompozhil 

 

We can do the scripting on glide_list. either as a part of query, update in form of array etc. Could you elaborate your use case.