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 —
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 —
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 —
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 —
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')