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.
As an example, you could use a pre-filter to stop external clients from seeing internal issues as is done in screen grab above:
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 (as above) that restricts members of the group Client from seeing issues where InternalIssue is YES:
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.
