= $P{startDate} AND acts.activity_start_time <= date_add($P{endDate}, INTERVAL "23:59:59" HOUR_SECOND) AND (acts.arch_short_name LIKE "act.customerAccount%item") GROUP BY clinician_name ORDER BY clinician_name ASC]]>