Access filters

Access filters can be used to limit the records that a query returns based on the user's permissions in Infor Operations and Regulations Access Control. For example, a building inspection query might only include inspection types for which the user is assigned the View Inspection permission.

To define access filters, add an AccessFilters node to the appropriate query node. The AccessFilters node has one or more AccessFilter nodes as children. An access filter is defined by these attributes:

• The accessTemplate attribute specifies the path to a permission in Access Control that the user must be granted, such as CDR/Building/Application Types/{APTYPE.APTYPE}/Inspection/{INSPTYPE.INSPTYPE}/View Inspection. Each part of the path specifies a node in the Permissions tree. Because it uses placeholders for the application type and inspection type, the template applies to the View Inspection permission for all building inspection types.
• The alias attribute specifies an identifier that will be used for the access filter within the query SQL. The alias should be added to the query's WHERE clause and enclosed in curly brackets, such as {AccessFilter}.