Data of Dot-walked fields fields are showing blank when exported from HR Agent Workspace

[Bhavani13]

Hi,

we have created my own list under My list on Workforce admin table in HR Agent workspace and we have a Case Data field, which is referencing the Case Data table (sn_hr_core_case_data). I have added the fields of the Case Data table in my list through dot-walking. 

When I tried to export the list in HR Agent Workspace using the Export button, the data of the Case Data table is empty/not showing only Workforce admin table related data is showing. 

I checked the ACL's of the Case Data table, it is not having any field level ACL's. As per the table level ACL's the user are having access. 

The users are able to see the data of dot-walked fields in HR Agent workspace. The issue is only while exporting the data. 

Can anyone help me, how to fix the issue. 

Regards,

Bhavani.

[HrishabhKumar]

Hi @Bhavani13 ,

You might wanna check this kb article : https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0864086

Thanks.

Hope it helps.

If my response turns useful mark it helpful and accept solution.

[Bhavani13]

Hi @HrishabhKumar, 

In HR Agent workspace view, we are able to see the data for dot-walked fields. The issue we are facing is while exporting the data. When we export the list in excel format. The data of  dot walked fields is not showing in the excel document. 

Regards,

Bhavani

[Mike McCall]

I'm having the same issue with the Involved Party table and dot-walked values on the Legal Matter table:

1. User 1 can view and report on all Involved Party records/fields
2. User 1 can view and report on all Legal Matter records/fields (e.g., Legal Matter.State)
3. User 1 cannot report on any dot-walked fields from Involved Party.Legal Matter (e.g., Involved Party.Legal Matter.State)

In my situation, I've noticed that the person assigned to a Legal Matter (User 2) can report on Involved Party.Legal Matter.State. I'm looking into read and report_view ACLs, but I haven't found anything yet. I'll post here if I find a resolution, and I'll watch for anyone else with tips!

------

NOTE: we discovered this issue when exporting from a list in the legacy Legal Counsel Center Classic workspace. However, I've found that the issue is easy to recreate right in the report UI; just build that same list with dot-walked fields, and you'll see that the ones failing to export don't even show values! 😬

[Mike McCall]

Closing the loop for my use case: without updating the "partial_record_materializer" system property, I fixed my Involved Party list by adding Legal Matter.Assignment group permission. 👨‍🔬

My users don't really want that field on their list or in their export, but including it makes all of the other fields work perfectly. If you can find the magic field for your use case, you can also avoid the system property. 🔍 Good luck! 😅