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? 

[Chaitanya ILCR]

Hi @Stephie Soo 

Check the ACLs on Category table and the All the tables involved 

Make sure to

Look for new Query Range ACL and see if the users have access to this ACL

Use Access analyser for quick results 

Regards 

Chaitanya 

[Stephie Soo]

Hi @Chaitanya ILCR ,

Thanks for the quick response. 

Can check if needed to grant "query_range" for asmt_metric.* only or need for asmt_metric.none too?
As I've already granted query_range to asmt_metric.*

Also i checked there is no existing query_range for asmt_metric.category, there is for asmt_metric.question (but even if i deactivated that, still no visibility).

Lastly, also able to share how to use access analyser for this situation as when i analyze on asmt_metric_result, i am unable to dot walk to .category and .question. while when i analyze on asmt_metric, as previously mention, it is visible for that user when viewing via that table itself.

[Bhuvan]

@Stephie Soo 

Create a read and report_view ACL on asmt_metric_result.NONE for a role [for example, I added the role 'survey_reader' in my ACLs]

Share the dashboard you created with 'survey_reader' role as a Viewer

Sample user with only role 'survey_reader' added can see the dashboard

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

Thanks,

Bhuvan

[Stephie Soo]

Hi @Bhuvan  

I just did exactly as your screenshot however, nothing changed.
I even changed the role to survey_reader to mimic yours but its still not visible.

Also note all this time i can view asmt_metric_result.metric but just not asmt_metric_result_metric.category/question 😞 

Why are they not allowing me to view dotwalked data sigh.