Třídová akce

Kód:

10

Tělo:

SELECT DisplayName, ID, SheduledStart$Date, SheduledEnd$Date, SolverRole_ID, ActQueue_ID, ActivityType_ID, IsParticipant 
FROM (
SELECT
  (SELECT OUT_DISPLAYNAME FROM CRMGetActivityTimeSheetName(A.ID, :TitleModifier)) as DisplayName,
  A.ID as ID, 
  A.SheduledStart$Date as SheduledStart$Date,   
  A.SheduledEnd$Date as SheduledEnd$Date,   
  P.ParticipantRole_ID as SolverRole_ID, 
  A.ActQueue_ID as ActQueue_ID, 
  A.ActivityType_ID as ActivityType_ID,
  'A' as IsParticipant
  FROM CRMActivities A JOIN CRMActivityParticipants P ON (P.Parent_ID = A.ID) and (P.VisibleInTimeSheet='A') and (P.ParticipantRole_id <> A.SolverRole_ID)
WHERE
  P.ParticipantRole_ID in {SolverRoles} and
  A.ActQueue_ID in {ActQueues} and
  Not (A.SheduledStart$Date >= :DateTo or A.SheduledEnd$Date <= :DateFrom)
UNION 
SELECT
  (SELECT OUT_DISPLAYNAME FROM CRMGetActivityTimeSheetName(A.ID, :TitleModifier)) as DisplayName,
  A.ID as ID, 
  A.SheduledStart$Date as SheduledStart$Date, 
  A.SheduledEnd$Date as SheduledEnd$Date,
  A.SolverRole_ID AS SolverRole_ID, 
  A.ActQueue_ID as ActQueue_ID, 
  A.ActivityType_ID as ActivityType_ID,
  'N' as IsParticipant
  FROM CRMActivities A LEFT JOIN CRMActivityParticipants P ON (P.Parent_ID = A.ID) and (P.ParticipantRole_ID = A.SolverRole_ID)
WHERE
  A.SolverRole_ID in {SolverRoles} and
  A.ActQueue_ID in {ActQueues} and
  Not (A.SheduledStart$Date >= :DateTo or A.SheduledEnd$Date <= :DateFrom)
)

Generated by ABRA Software a.s. 27.10.2021 16:34:54