User Tools
niota-docs:niota_grid_config_rls
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
niota-docs:niota_grid_config_rls [2023/10/10 11:04] admin |
niota-docs:niota_grid_config_rls [2025/07/17 14:11] (current) |
||
|---|---|---|---|
| Line 33: | Line 33: | ||
| ^ usergroupname ^ tokenname ^ tokenvalue ^ description ^ ind_active ^ | ^ usergroupname ^ tokenname ^ tokenvalue ^ description ^ ind_active ^ | ||
| | my-group | COUNTRY | AU | string definition | 1 | | | my-group | COUNTRY | AU | string definition | 1 | | ||
| + | | my-group | COUNTRY | HU | string definition | 1 | | ||
| | my-group | ITEMID | (1234) | numeric definition | 1 | | | my-group | ITEMID | (1234) | numeric definition | 1 | | ||
| | my-group | NUMBERASSTR | 1234 | number will be treated as string | 1 | | | my-group | NUMBERASSTR | 1234 | number will be treated as string | 1 | | ||
| Line 43: | Line 44: | ||
| Configuration upwards leads to a SELECT stmt like this if the user is part of //my-group//: | Configuration upwards leads to a SELECT stmt like this if the user is part of //my-group//: | ||
| - | SELECT country_code, ... FROM <db objet of catalog id 1000> WHERE **(country_code in ('AU'))** ...; | + | SELECT country_code, ... FROM <db objet of catalog id 1000> WHERE **(country_code in ('AU', 'HU'))** ...; |
| Sample stmt with tokens COUNTRY and ITEMID applied: | Sample stmt with tokens COUNTRY and ITEMID applied: | ||
niota-docs/niota_grid_config_rls.1696928653.txt.gz · Last modified: 2025/07/17 14:11 (external edit)