Skip to main content
Users can also have User Restrictions. User Restrictions tab This works like the variables tab: click the Add icon to create a new restriction. This time, you’ll be presented with a pop-up list of the data connections the user has access to. Data connection selection pop-up Once you’ve selected a data connection, select the data object in it that you want to restrict on. In the following example, we’re using the Job Role object from the HR Data Connection. The next step is to add the restriction value. Click the magnifying glass at the end of the line for the restriction value to open a pop-up screen showing all values within the selected data object. You can select as many values as you want, then click Apply at the bottom of the screen to confirm the selection. Selecting restriction values
These restrictions will only apply to charts that contain the data object of HR.Job Role or any data objects that contain a WHERE clause that links to the selected object.
Effectively what this means is that for all charts in the HR Data Connection an extra line of SQL will be added if the Job Role is, in this example, Healthcare Representative. SQL restriction applied to charts For other users, this SQL line will either be:
  • Replaced with their name if they also have a User Restriction configured
  • Removed completely, showing data for all Job Roles, if they don’t have any User Restriction on this object