How to search for a specific subfield in a table.

[Bhojraj Chauhan]

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 · Accepted solution]

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. 

[AndersBGS]

hi @Bhojraj Chauhan ,

assignment group is located on the task level. Which table are you making the report from?

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

Best regards

Anders

[Bhojraj Chauhan]

Hi @AndersBGS , I am looking it in survey response table.

[AndersBGS · Accepted solution]

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