Ok finally got it.
If someone else has this Problem.
Here is my solution.
Make 2 Tables:
Then use this Script:
function onUnknownSqlMacroIdentifier(name)
{
// log('sn = ' + session['Login.sn'] + '');
// log('uidNumber = ' + session['Login.uidNumber'] + '');
// log('cn =' + session['Login.cn'] + '');
// log('gidNumber = ' + session['Login.gidNumber'] + '');
if (name === 'filter')
return "C_NO IN (SELECT DISTINCT CAMP_NO FROM RPL$GROUPS_RIGHTS WHERE
GROUP_NO = (SELECT GROUP_NO FROM RPL$GROUPS WHERE `gidNumber` = '" + session['Login.gidNumber'] + "') )";
}
Shalom
Manfred
PS: Thanks again for the Support Crew