myCRM-Kalender nur für eigene Aktivitäten einschränken

Sollen Selektionen auf Aktivitätenebene so eingeschränkt sein, dass ein Anwender nur seine eigenen Aktivitäten einsehen darf (Delegiert an, Delegiert von = USER), so kann man das für den Kalender über SQL-Statements einstellen.

SQL-Statements

MSSQL

— Weitere Mitarbeiter deaktivieren —

SQL

INSERT INTO PropertyMapper( Pk, id, property, propertyValue, propertyType, principal, isCustomizing, CustLayer, Active, CreateDate, CreateUser, UpdateDate, UpdateUser, Status, WFInstanceId, RightPk, ClientNo, MassData, OfflineData)
VALUES ( 'SYSTEM.DisableScheduleFurtherEmployees', '/de/cursor/jevi/common/schedule/ScheduleHelperCommon$!!$DisableFurtherEmployees', '', 'true', 'SYSTEM', '', 0, 'CN', 1, getDate(), 'TECH_USER', getDate(), 'TECH_USER', null, null, null, null, 0, 0)

— Team-Auswahl deaktivieren —

SQL

INSERT INTO PropertyMapper( Pk, id, property, propertyValue, propertyType, principal, isCustomizing, CustLayer, Active, CreateDate, CreateUser, UpdateDate, UpdateUser, Status, WFInstanceId, RightPk, ClientNo, MassData, OfflineData)
VALUES ( 'SYSTEM.DisableScheduleTeamLists', '/de/cursor/jevi/common/schedule/ScheduleHelperCommon$!!$DisableTeamLists', '', 'true', 'SYSTEM', '', 0, 'CN', 1, getDate(), 'TECH_USER', getDate(), 'TECH_USER', null, null, null, null, 'false', 'false')

ORACLE

— Weitere Mitarbeiter deaktivieren —

SQL

INSERT INTO PropertyMapper( Pk, id, property, propertyValue, propertyType, principal, isCustomizing, Active, CreateDate, CreateUser, UpdateDate, UpdateUser, Status, WFInstanceId, RightPk, ClientNo, MassData, OfflineData, CustLayer)
VALUES ('SYSTEM.DisableScheduleFurtherEmployees', '/de/cursor/jevi/common/schedule/ScheduleHelperCommon$!!$DisableFurtherEmployees', '', 'true', 'SYSTEM', '', 0, 1, sysdate, 'TECH_USER', sysdate, 'TECH_USER', null, null, null, null, 0, 0, 'CN')

— Team-Auswahl deaktivieren —

SQL

INSERT INTO PropertyMapper( Pk, id, property, propertyValue, propertyType, principal, isCustomizing, Active, CreateDate, CreateUser, UpdateDate, UpdateUser, Status, WFInstanceId, RightPk, ClientNo, MassData, OfflineData, CustLayer)
VALUES ('SYSTEM.DisableScheduleTeamLists', '/de/cursor/jevi/common/schedule/ScheduleHelperCommon$!!$DisableTeamLists', '', 'true', 'SYSTEM', '', 0, 1, sysdate, 'TECH_USER', sysdate, 'TECH_USER', null, null, null, null, 0, 0, 'CN')