4.7.3.1.5.  Filter condition for data records - plinkgroups.cfg -> [role name] -> key "CONDITION"

[Note]Note

Filter condition for data records [Filter condition for datasets] is role-dependent and must therefore be defined separately for each role.

Function: Show table row but hide LinkDB content. The reason for using this feature could be data protection, for example, if certain roles (users, departments) should not see certain LinkDB information. However, the row itself is displayed

Setting in the configuration file $CADENAS_SETUP/plinkgroups.cfg:

Example:

[Note]Note

Please use SQL syntax for this setting.

[Role_name]
CONDITION=(LINKTABLE.ACTIVE_STATE=1)

Meaning: Data records that contain the entry '1' in the ACTIVE_STATE column correspond to the condition. These table rows are displayed with all LinkDB entries. In addition, all other table rows without LinkDB content are also displayed.

For LinkDB datasets which do not meet the condition the LinkDB content is hidden. However, the dataset itself is displayed.

Setting in the user interface under PARTadmin -> Category Roles -> General tab -> Filter condition for data records [Filter condition for datasets]

-> Display in PARTdataManager:

Role A has no restrictions and can see the complete LinkDB content.

Role A has no restrictions and can see the complete LinkDB content.

Role B cannot see the LinkDB content of a certain table row, because it does not meet the condition, because the value of ACTIVE_STATE is '0' (locked).

Role B cannot see the LinkDB content of a certain table row, because it does not meet the condition, because the value of ACTIVE_STATE is '0' (locked).