gistfile1.txt

SELECT id AS "id", activationtime AS "activationtime", actualowner AS "actualowner", createdby AS "createdby", createdon AS "createdon", deploymentid AS "deploymentid", description AS "description", duedate AS "duedate", lastmodificationdate AS "lastmodificationdate", name AS "name", parentid AS "parentid", priority AS "priority", processid AS "processid", processinstanceid AS "processinstanceid", processsessionid AS "processsessionid", status AS "status", taskid AS "taskid", workitemid AS "workitemid", entity_id AS "entity_id", taskid 
FROM (select ti.*, oe.id entity_id from audittaskimpl ti, peopleassignments_potowners po, organizationalentity oe where ti.taskid = po.task_id and po.entity_id = oe.id) 
AS "dbSQL" 
WHERE ((entity_id IS NULL OR entity_id <> 'pamAdmin') AND 
	(((id = 'kiemgmt' OR id = 'manager' OR id = 'admin' OR id = 'rest-all' OR id = 'analyst' OR id = 'kie-server' OR id = 'user' OR id = 'pamAdmin') AND (actualowner = '' OR actualowner IS NULL)) OR actualowner = 'pamAdmin')) 

GROUP BY taskid, id, activationtime, actualowner, createdby, createdon, deploymentid, description, duedate, lastmodificationdate, name, parentid, priority, processid, processinstanceid, processsessionid, status, workitemid, entity_id