You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

User security level is for creating filters for each user. Acording to this filter each user will be able to see only part of defined data from dataset

Only users with data manager role are allowed to create and manage user security level.

Open the Data sets page from main menu on the top of the screen.

  1. Click "User Security Levels" in the left submenu.
  2. Add new level

Here you can create new user security query. Query acts like a filter Where response is equal to set filter.

Applied columns is where your SQL answer will be compared as filter

If multiple columns is in use Delimiter should be chosen. | (pipe sign) is recommended

While configuring the user security levels the following rules must be kept during the configuration:

- Only attributes are allowed

- Attributes in WHERE need to come from the main dataset

- Main dataset alias needs to be "PT"

- ON condition and WHERE condition needs to be in parenthesis

- Main dataset has to come first in the JOIN

- Variables can be used as '$date(now)' or '$user(info)' or '${@var1}'


 Example: select MDS74.L_RESTRICTION from $mainDataset(78) PT JOIN $dataset(74) MDS74 ON (PT.L_EXTENDED=MDS74.L_ADDINFO) where (PT.L_MAIN = '$user(info)' AND PT.L_START<= '$date(now)')

  • No labels