User cant see asmt_metric_result.asmt_metric.category when viewing table

[Stephie Soo]

Hi all,

I am trying to create a dashboard to view survey data. 

However, as an admin, i have no issues viewing all needed data from asmt_metric_result
- data wanted 

But, as a user, they seem to not be able to view Metric.Category.Name as well as Metric.Question (it appears as blank) - i can query those fields but it is just not visible.

Note, i have already created the needed read acls for asmt_metric table as well as asmt_metric_result and i have ensured they can see the category and question data when viewing the asmt_metric table itself. 

So the issue here is, the users are just unable to view referenced data when viewing from asmt_metric_result table.

Does anyone know what may be causing this issue and how to fix it?

It's very frustrating because i feel i did everything there is.. unless somehow dotwalking referenced value requires additional works? 

[Bhuvan]

@Stephie Soo 

Check if you have any custom ACLs on asmt_metric_result.field or asmt_metric_result.*

In my PDI, I just created these 2 ACLs and shared the dashboard with role and the user was able to see the dashboard fine. Data shown in my sample are dot-walked fields and mimic your requirements of metric.category.name, metric.question, string value

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Stephie Soo · Accepted solution]

Hi all @Chaitanya ILCR @Bhuvan  ,

Thank you for all your help but turns out:

I found out the cause. Apparently, for my asmt_metric.NONE ACL, i previously placed a condition to only filter specific survey type cause i only wanted that role to see the contents of said survey. I removed that condition "for fun" and turns out it finally allowed me to see the data.  

Am not sure why only after removing the condition is the data visible for the user. But anyway, issue is solved thus will proceed to close this ticket but for those who knows why that happens, please do share here! 

[Bhuvan]

@Stephie Soo 

My earlier response mentioned the same about ACLs that might be modified or not out of box. 

If my response helped to answer your query, please mark it helpful & accept the solution. As per community guidelines, you can accept more than one answer as accepted solution.

Thanks,

Bhuvan

[Bhuvan]

@Stephie Soo 

Did you get a chance to review this ?

If my response helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan