Report not populating User's location

[MadelineA747953]

Hello- New ServiceNow Platform Owner here!  We recently imported the location user attribute into our platform. When we run a report and add the location field, the user's location is returning as empty. 

[AshishKM · Accepted solution]

Seems like you are trying to get data from Incident table and location column is emptry there, this location field is not auto populate for caller location.

We need to udpate the incident's location field with respective caller's location either manually or using some script when new incident created. 

E.g. you can edit the location value in any of Incident and then check the report, this will display the value.

-

[AshishKM]

Hi @MadelineA747953,

Can you share the report configuration part, that how you are applying the dot walking path from User->Location table. 

• If you shift this Location[+] field on right side, it will show the location value for users as configured. 
• If you are looking for some other column from Location table then clik on hierarchy button above the ">" this will open the location table columns and you can select and shift to seleted side.

-Thanks,

AshishKM

[MadelineA747953]

Thank you!  I followed your instructions and this resolved incidents being submitted on the classic view however, incidents being submitted through the Employee Center continues to show user location as empty.  Any thought on how to resolve this?

[AshishKM]

This can be resolve by adding one line code in record producer [on Incident table]

current.location = gs.getUser().getRecord().getValue('location');

Result:

Note: You need to check the record producer name which is used for creating incident from Employee Center Portal in your instance.