Forms, reports, and queries

The ENFORCE_GUI_LEVEL_QUERY_SECURITY property in the TRIRIGAWEB.properties file controls form-level security in reports and queries. When this property is N, the default, queries and reports do not consider form-level security.

When this property is Y, the user's group controls whether the user can access records in reports and queries. If a user does not have access to records being queried, no results are returned. If at least one of a user's groups has at least read access, the data is returned to the form. For module queries, only data for the forms in the module to which the user has access are returned.