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 10:44] 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 = 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: | ||
| - | SELECT country_code, item_id, ... FROM <db objet of catalog id 1000> WHERE **%%(%%(country_code = 'AU') AND (item_id = 1234)%%)%%** ...; | + | SELECT country_code, item_id, ... FROM <db objet of catalog id 1000> WHERE **%%(%%(country_code in('AU')) AND (item_id = 1234)%%)%%** ...; |
niota-docs/niota_grid_config_rls.1696927489.txt.gz · Last modified: 2025/07/17 14:11 (external edit)