postgresql7.2
select t.task_id,
t.title,
t.description,
t.mime_type,
t.priority,
t.party_id,
p.title as process_title,
p.process_id,
tasks__relative_date(t.due_date) as due_date,
tasks__relative_date(t.completed_date) as completed_date,
t.status_id,
t.process_instance_id,
t.assignee_id,
contact__name(t.assignee_id) as assignee_name,
contact__name(t.party_id) as contact_name,
CASE WHEN t.due_date < now() THEN 't' ELSE 'f' END as due_date_passed_p,
s.title as status,
t.object_id
from
t_task_status s,
acs_objects ao,
t_tasks t
left outer join t_process_instances pi
on (pi.process_instance_id = t.process_instance_id)
left outer join t_processes p
on (p.process_id = pi.process_id)
where s.status_id = t.status_id
and t.status_id <> 2
and ao.object_id = t.task_id
and ao.package_id = :package_id
and t.start_date < now()
and t.due_date < ( now() + '$tasks_interval days'::interval )
and t.assignee_id = :user_id
and t.party_id in ( select parties.party_id
from parties
left join cr_items on (parties.party_id = cr_items.item_id)
left join cr_revisions on (cr_items.latest_revision = cr_revisions.revision_id),
group_distinct_member_map
where parties.party_id = group_distinct_member_map.member_id
$group_where_clause
[contact::search_clause -and -search_id $search_id -query $query -party_id "parties.party_id" -revision_id "revision_id"] )
[template::list::page_where_clause -and -name tasks -key t.task_id]
[template::list::filter_where_clauses -and -name tasks]
[template::list::orderby_clause -orderby -name tasks]
select t.task_id
from t_task_status s, acs_objects ao, t_tasks t
where s.status_id = t.status_id
and t.status_id <> 2
and ao.object_id = t.task_id
and ao.package_id = :package_id
and t.start_date < now()
and t.due_date < ( now() + '$tasks_interval days'::interval )
and t.assignee_id = :user_id
and t.party_id in ( select parties.party_id
from parties
left join cr_items on (parties.party_id = cr_items.item_id)
left join cr_revisions on (cr_items.latest_revision = cr_revisions.revision_id),
group_distinct_member_map
where parties.party_id = group_distinct_member_map.member_id
$group_where_clause
[contact::search_clause -and -search_id $search_id -query $query -party_id "parties.party_id" -revision_id "revision_id"] )
[template::list::filter_where_clauses -and -name tasks]
[template::list::orderby_clause -orderby -name tasks]
select t.task_id,
t.title,
t.description,
t.mime_type,
t.priority,
t.party_id,
p.title as process_title,
p.process_id,
tasks__relative_date(t.due_date) as due_date,
tasks__relative_date(t.completed_date) as completed_date,
t.status_id,
t.process_instance_id,
t.assignee_id,
contact__name(t.assignee_id) as assignee_name,
contact__name(t.party_id) as contact_name,
CASE WHEN t.due_date < now() THEN 't' ELSE 'f' END as due_date_passed_p,
s.title as status,
t.object_id
from
t_task_status s,
acs_objects ao,
t_tasks t
left outer join t_process_instances pi
on (pi.process_instance_id = t.process_instance_id)
left outer join t_processes p
on (p.process_id = pi.process_id)
where s.status_id = t.status_id
and t.status_id <> 2
and ao.object_id = t.task_id
and ao.package_id = :package_id
and t.start_date < now()
$employee_where_clause
[template::list::page_where_clause -and -name tasks -key t.task_id]
[template::list::filter_where_clauses -and -name tasks]
[template::list::orderby_clause -orderby -name tasks]
select t.task_id
from t_task_status s, acs_objects ao, t_tasks t
where s.status_id = t.status_id
and t.status_id <> 2
and ao.object_id = t.task_id
and ao.package_id = :package_id
and t.start_date < now()
$employee_where_clause
[template::list::filter_where_clauses -and -name tasks]