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 - 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.

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