is(Dynamic) and additional condition in database view

[R_ana]

Hi All,

I am creating database view on asmt_metric_result, asmt_assessment_instance and incident.

I need the result to be visible to me for a specific incident survey and only if I am part of the Inc assignment group.

I need help to add the sys id of the survey and "is(Dynamic) One of my Groups" in database view conditions.

Can anyone please suggest how to implement these.

Any help is much appreciated.

Regards,

R'ana

[SanjivMeher]

I would suggest instead of adding the condition to the database view, which is difficult to do, create a report on the database view and add condition there using the report condition builder to see the results. That way you can add the report to a dashboard and share it to your users.

[R_ana]

Hi Sanjiv,

Thanks for the response.

But won't that allow any user to have access to other group's survey results? the report on the database view will bring up all the results, irrespective of the INC assignment group. However, we want them to be able to see ONLY their group's data. 

Please let me know if I am missing anything here. Thanks!

[SanjivMeher]

If you create a report, they wouldn't have access to modify the filter.

If you think they will access the database view some other way, you can probably add ACLs on the database view. 

[R_ana]

Hi Sanjiv,

Apologies if I am asking basic questions...

I created the report, shared with a user. Impersonated that user and the user is able to modify the filter conditions of the report. How can I restrict that?

Also, I tried with ACLS, but somehow we have custom ACLS which are clashing and giving access to asmt_assessment_instance. That is why I wanted to add those conditions in the Database view that data is restricted at the view level itself.

Please suggest. Thanks!