Skip to main content
Skip table of contents

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


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.