is(Dynamic) and additional condition in database view

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