This option allows custom SQL code to be inserted before the regular RMTrack issue filtering rules. It can be used to further restrict the list of issues shown to users.
For example, you could use a pre-filter to stop external clients from seeing internal issues:
Create a custom issue field (yes/no type) called InternalIssue.
Use this field on your data entry form to indicate internal and external issues.
Create a pre-filter that restricts members of the group Client from seeing issues where Internal Issue is YES:
----------------------------------------
(
(exists(select * from UserGroups as ug
where ug.UserId = @CurrentUserId and ug.GroupCode = 'Client')
and Issues.InternalIssue = 0)
or
(not exists(select * from UserGroups as ug
where ug.UserId = @CurrentUserId and ug.GroupCode = 'Client'))
)
----------------------------------------
NOTE: This option requires advanced knowledge of both SQL and of the RMTrack database. It is recommended that you contact support@rmtrack.com for assistance with this feature.
