After selection of the category Roles you can see ...
Syntax notes can be found under Section 6.1.1, “Fortran Syntax ” or Section 6.1.2, “SQL Syntax ”.
In some input fields Fortran syntax has to be used, in some SQL syntax. The respective note is found above each point.
Specify variables with their table name in addition.
ERPTABLE.ERP_PDM_NUMBER LINKTABLE.ACTIVE_STATE
For complex expressions use brackets. Unneeded brackets are ignored. In case of doubt, too many brackets are better than too few brackets.
Please remember to update the link database search index in case of relevant changes of role settings.