Dot walk to Glide List field to generate Report

[manish123]

Hi All,

In my instance there is a customised table called Applications and it has got fields as Expert, which is glide list and allows more than one user to attached. Now, we are trying to run a report to find out which Expert's user is no more active in the system and needs to be replaced.

I know that you can't do dot walk to the glide list values.

Therefore, Is there any way I could able to generate the report and get the list of such application with user details? either going from User table or outbox any type of customized solution.

Has anyone came across such issue and if you can guide me through the solution then that would be great?

Quick reply will be much appreciated!!!

[Aman Kumar S · Accepted solution]

Hi @manish123 ,

What you can do here, is to glide through the table and fetch the list value, which essentially will provide you the list of sys_id of the users, now glide the user table and pass on the sys_ids one by one and check if user is inactive or not then accordingly perform the pop operation to remove the users from list of experts.

Look at below links for refernece:

https://www.servicenow.com/community/developer-forum/list-collector-reference-dot-walking/m-p/165695...

https://www.servicenow.com/community/developer-forum/dot-walking-list-type-field-in-scripting/m-p/20...

[Saurav11 · Accepted solution]

Hello,

What I can think of is you can create a script include and use that as a filter.

This is the only thing i can think of right now:-

Something like below:-

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0832058

Please mark my answer as correct based on Impact.

[Aman Kumar S · Accepted solution]

Hi @manish123 ,

What you can do here, is to glide through the table and fetch the list value, which essentially will provide you the list of sys_id of the users, now glide the user table and pass on the sys_ids one by one and check if user is inactive or not then accordingly perform the pop operation to remove the users from list of experts.

Look at below links for refernece:

https://www.servicenow.com/community/developer-forum/list-collector-reference-dot-walking/m-p/165695...

https://www.servicenow.com/community/developer-forum/dot-walking-list-type-field-in-scripting/m-p/20...

[Saurav11 · Accepted solution]

Hello,

What I can think of is you can create a script include and use that as a filter.

This is the only thing i can think of right now:-

Something like below:-

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0832058

Please mark my answer as correct based on Impact.

[Saurav11 · Accepted solution]

Hello,

If my answer helped you can you also mark it as correct.

Thanks.