Not able to bring "Business area" field from user table to Call table

phr
Tera Contributor

Hi All,

 

I have a requirement to bring "Business Area" under user table to "new_call" table through report. I did select "new_call" as a table name in the report. Will the Business area field can be brought in here? How to achieve this?

 

 

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@phr 

since your report is on new_call table, is there any field on that table which refers to User table?

if yes then using dot walking you can bring the field on report

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

View solution in original post

2 REPLIES 2

Ankur Bawiskar
Tera Patron
Tera Patron

@phr 

since your report is on new_call table, is there any field on that table which refers to User table?

if yes then using dot walking you can bring the field on report

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

Hi Ankur,

 

We had a check and there was "company" filed , so we were able to achieve this.

 

Thank you.