How to search for a specific subfield in a table.

Bhojraj Chauhan · ‎01-12-2024

Hi, I am new to service-now and wanted suggestions as to how can we search for a specific sub-field in a table. Example: I wanted to add filter as assignment group is "ABC" but assignment group is not a field in the table. I had to dot walk like "inst.task.assignment_group". I didn't know that I can find "assignment group" under "inst.task" How to find the right field to dot walk to.

Dr Atul G- LNG · ‎01-12-2024

Hi @Bhojraj Chauhan

If I speak , it is something you learn from experience.

Have a alook OOTB Tables

Like

user

group

role#

task

incident

change

cmdb

cmdb_ci

These tables give you more clarity.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

AndersBGS · ‎01-14-2024

Hi @Bhojraj Chauhan ,

If you see screendump below, I have dot-waked from the asmt_assessment_instance table to task to assignment group:

You can also dot-walk directly to the incident associated with the assessment, and filter on the assignment group:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards
Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

Dr Atul G- LNG · ‎01-12-2024

Hi @Bhojraj Chauhan

If I speak , it is something you learn from experience.

Have a alook OOTB Tables

Like

user

group

role#

task

incident

change

cmdb

cmdb_ci

These tables give you more clarity.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Bhojraj Chauhan · ‎01-14-2024

I got it thanks for your advice I will look into it.

Dr Atul G- LNG · ‎01-14-2024

Thanks @Bhojraj Chauhan for marking my answer helpful.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Bhojraj Chauhan · ‎01-15-2024

Hi @Dr Atul G- LNG Thanks for the advice it helps a lot.