2011-02-24 07:55:25,253 [http-0.0.0.0-8081-6] DEBUG com.lombardisoftware.server.ejb.api.ProcessSearchAPICore  - executeQuery: query IS
SELECT * FROM (SELECT i.bpd_instance_id AS instanceId, i.instance_name AS instanceName, bpd.name AS bpdName, i.due_date AS instanceDueDate, t.subject AS taskSubject, tpriority.name AS taskPriority, t.due_date AS taskDueDate, t.attached_form_id AS taskAttachedInfoPathFormId, t.attached_external_activity_id AS taskAttachedExternalActivityId, t.task_id AS taskId, tstatus.name AS taskStatus, tuser.user_name AS assignedToUser, istatus.name AS instanceStatus, bd.*, tpriority.ranking AS taskPriorityRanking FROM lsw_task t INNER JOIN lsw_bpd_instance i ON t.bpd_instance_id = i.bpd_instance_id LEFT JOIN lsw_task_status_codes tstatus ON t.STATUS = tstatus.status_value LEFT JOIN lsw_bpd_status_codes istatus ON i.execution_status = istatus.status_id LEFT JOIN lsw_priority tpriority ON t.priority_id = tpriority.priority_id LEFT JOIN lsw_bpd bpd ON i.bpd_id = bpd.bpd_id LEFT JOIN lsw_usr_xref tuser ON t.user_id = tuser.user_id LEFT JOIN (SELECT v.bpd_instance_id, MAX(CASE WHEN alias='firstKey' THEN STRING_VALUE ELSE NULL END) AS "PSAPI_D_0" FROM lsw_bpd_instance_variables v INNER JOIN lsw_task t ON v.bpd_instance_id=t.bpd_instance_id INNER JOIN lsw_bpd_instance i ON v.bpd_instance_id=i.bpd_instance_id LEFT JOIN lsw_task_status_codes tstatus ON t.STATUS = tstatus.status_value  WHERE ( UPPER(tstatus.name) IN ( UPPER('New'),UPPER('Received') ) AND  EXISTS (  SELECT 1 FROM lsw_bpd_instance_variables v  WHERE v.bpd_instance_id = i.bpd_instance_id AND  v.alias='firstKey' AND ( UPPER(v.STRING_VALUE) = UPPER('the rest') ) )  AND t.user_id = 1 )  GROUP BY v.bpd_instance_id) bd ON bd.bpd_instance_id=t.bpd_instance_id  WHERE ( UPPER(tstatus.name) IN ( UPPER('New'),UPPER('Received') ) AND  EXISTS (  SELECT 1 FROM lsw_bpd_instance_variables v  WHERE v.bpd_instance_id = i.bpd_instance_id AND  v.alias='firstKey' AND ( UPPER(v.STRING_VALUE) = UPPER('the rest') ) )  AND t.user_id = 1 )  UNION ALL SELECT i.bpd_instance_id AS instanceId, i.instance_name AS instanceName, bpd.name AS bpdName, i.due_date AS instanceDueDate, t.subject AS taskSubject, tpriority.name AS taskPriority, t.due_date AS taskDueDate, t.attached_form_id AS taskAttachedInfoPathFormId, t.attached_external_activity_id AS taskAttachedExternalActivityId, t.task_id AS taskId, tstatus.name AS taskStatus, tuser.user_name AS assignedToUser, istatus.name AS instanceStatus, bd.*, tpriority.ranking AS taskPriorityRanking FROM lsw_task t INNER JOIN lsw_bpd_instance i ON t.bpd_instance_id = i.bpd_instance_id LEFT JOIN lsw_task_status_codes tstatus ON t.STATUS = tstatus.status_value LEFT JOIN lsw_bpd_status_codes istatus ON i.execution_status = istatus.status_id LEFT JOIN lsw_priority tpriority ON t.priority_id = tpriority.priority_id LEFT JOIN lsw_bpd bpd ON i.bpd_id = bpd.bpd_id LEFT JOIN lsw_usr_xref tuser ON t.user_id = tuser.user_id LEFT JOIN (SELECT v.bpd_instance_id, MAX(CASE WHEN alias='firstKey' THEN STRING_VALUE ELSE NULL END) AS "PSAPI_D_0" FROM lsw_bpd_instance_variables v INNER JOIN lsw_task t ON v.bpd_instance_id=t.bpd_instance_id INNER JOIN lsw_bpd_instance i ON v.bpd_instance_id=i.bpd_instance_id LEFT JOIN lsw_task_status_codes tstatus ON t.STATUS = tstatus.status_value  WHERE ( UPPER(tstatus.name) IN ( UPPER('New'),UPPER('Received') ) AND  EXISTS (  SELECT 1 FROM lsw_bpd_instance_variables v  WHERE v.bpd_instance_id = i.bpd_instance_id AND  v.alias='firstKey' AND ( UPPER(v.STRING_VALUE) = UPPER('the rest') ) )  AND t.group_id IN (
              SELECT lsw_usr_grp_mem_xref.group_id AS group_id
              FROM lsw_usr_grp_mem_xref
                LEFT JOIN lsw_usr_grp_xref
                  ON lsw_usr_grp_mem_xref.group_id = lsw_usr_grp_xref.group_id
              WHERE lsw_usr_grp_mem_xref.user_id = 1
                AND lsw_usr_grp_xref.group_name NOT IN ('TWSecurityProviderUsers')
            ) )  GROUP BY v.bpd_instance_id) bd ON bd.bpd_instance_id=t.bpd_instance_id  WHERE ( UPPER(tstatus.name) IN ( UPPER('New'),UPPER('Received') ) AND  EXISTS (  SELECT 1 FROM lsw_bpd_instance_variables v  WHERE v.bpd_instance_id = i.bpd_instance_id AND  v.alias='firstKey' AND ( UPPER(v.STRING_VALUE) = UPPER('the rest') ) )  AND t.group_id IN (
              SELECT lsw_usr_grp_mem_xref.group_id AS group_id
              FROM lsw_usr_grp_mem_xref
                LEFT JOIN lsw_usr_grp_xref
                  ON lsw_usr_grp_mem_xref.group_id = lsw_usr_grp_xref.group_id
              WHERE lsw_usr_grp_mem_xref.user_id = 1
                AND lsw_usr_grp_xref.group_name NOT IN ('TWSecurityProviderUsers')
            ) ) )  ORDER BY taskDueDate, taskPriorityRanking, instanceId, taskId
2011-02-24 07:55:25,534 [http-0.0.0.0-8081-6] DEBUG com.lombardisoftware.server.ejb.api.ProcessSearchAPICore  - executeCountQuery: query IS
SELECT COUNT (DISTINCT instanceId) FROM (SELECT i.bpd_instance_id AS instanceId, bd.* FROM lsw_task t INNER JOIN lsw_bpd_instance i ON t.bpd_instance_id = i.bpd_instance_id LEFT JOIN lsw_task_status_codes tstatus ON t.STATUS = tstatus.status_value LEFT JOIN (SELECT v.bpd_instance_id, MAX(CASE WHEN alias='firstKey' THEN STRING_VALUE ELSE NULL END) AS "PSAPI_D_0" FROM lsw_bpd_instance_variables v INNER JOIN lsw_task t ON v.bpd_instance_id=t.bpd_instance_id INNER JOIN lsw_bpd_instance i ON v.bpd_instance_id=i.bpd_instance_id LEFT JOIN lsw_task_status_codes tstatus ON t.STATUS = tstatus.status_value  WHERE ( UPPER(tstatus.name) IN ( UPPER('New'),UPPER('Received') ) AND  EXISTS (  SELECT 1 FROM lsw_bpd_instance_variables v  WHERE v.bpd_instance_id = i.bpd_instance_id AND  v.alias='firstKey' AND ( UPPER(v.STRING_VALUE) = UPPER('the rest') ) )  AND t.user_id = 1 )  GROUP BY v.bpd_instance_id) bd ON bd.bpd_instance_id=t.bpd_instance_id  WHERE ( UPPER(tstatus.name) IN ( UPPER('New'),UPPER('Received') ) AND  EXISTS (  SELECT 1 FROM lsw_bpd_instance_variables v  WHERE v.bpd_instance_id = i.bpd_instance_id AND  v.alias='firstKey' AND ( UPPER(v.STRING_VALUE) = UPPER('the rest') ) )  AND t.user_id = 1 )  UNION ALL SELECT i.bpd_instance_id AS instanceId, bd.* FROM lsw_task t INNER JOIN lsw_bpd_instance i ON t.bpd_instance_id = i.bpd_instance_id LEFT JOIN lsw_task_status_codes tstatus ON t.STATUS = tstatus.status_value LEFT JOIN (SELECT v.bpd_instance_id, MAX(CASE WHEN alias='firstKey' THEN STRING_VALUE ELSE NULL END) AS "PSAPI_D_0" FROM lsw_bpd_instance_variables v INNER JOIN lsw_task t ON v.bpd_instance_id=t.bpd_instance_id INNER JOIN lsw_bpd_instance i ON v.bpd_instance_id=i.bpd_instance_id LEFT JOIN lsw_task_status_codes tstatus ON t.STATUS = tstatus.status_value  WHERE ( UPPER(tstatus.name) IN ( UPPER('New'),UPPER('Received') ) AND  EXISTS (  SELECT 1 FROM lsw_bpd_instance_variables v  WHERE v.bpd_instance_id = i.bpd_instance_id AND  v.alias='firstKey' AND ( UPPER(v.STRING_VALUE) = UPPER('the rest') ) )  AND t.group_id IN (
              SELECT lsw_usr_grp_mem_xref.group_id AS group_id
              FROM lsw_usr_grp_mem_xref
                LEFT JOIN lsw_usr_grp_xref
                  ON lsw_usr_grp_mem_xref.group_id = lsw_usr_grp_xref.group_id
              WHERE lsw_usr_grp_mem_xref.user_id = 1
                AND lsw_usr_grp_xref.group_name NOT IN ('TWSecurityProviderUsers')
            ) )  GROUP BY v.bpd_instance_id) bd ON bd.bpd_instance_id=t.bpd_instance_id  WHERE ( UPPER(tstatus.name) IN ( UPPER('New'),UPPER('Received') ) AND  EXISTS (  SELECT 1 FROM lsw_bpd_instance_variables v  WHERE v.bpd_instance_id = i.bpd_instance_id AND  v.alias='firstKey' AND ( UPPER(v.STRING_VALUE) = UPPER('the rest') ) )  AND t.group_id IN (
              SELECT lsw_usr_grp_mem_xref.group_id AS group_id
              FROM lsw_usr_grp_mem_xref
                LEFT JOIN lsw_usr_grp_xref
                  ON lsw_usr_grp_mem_xref.group_id = lsw_usr_grp_xref.group_id
              WHERE lsw_usr_grp_mem_xref.user_id = 1
                AND lsw_usr_grp_xref.group_name NOT IN ('TWSecurityProviderUsers')
            ) ) )
2011-02-24 07:55:25,690 [http-0.0.0.0-8081-6] DEBUG com.lombardisoftware.server.ejb.api.ProcessSearchAPICore  - END: executeQuery, RESULT = com.lombardisoftware.DATA.api.QueryResultWithCount@d05e663c