| |
7 |
7 |
select * from (SELECT distinct |
| |
8 |
8 |
p.item_id as project_item_id, |
| |
9 |
9 |
p.project_id, |
| |
10 |
10 |
p.status_id, |
| |
11 |
11 |
p.parent_id as folder_id, |
| |
12 |
12 |
p.object_type as content_type, |
| |
13 |
13 |
p.title as project_name, |
| |
14 |
14 |
p.project_code, |
| |
15 |
15 |
to_char(p.planned_end_date, 'YYYY-MM-DD HH24:MI:SS') as planned_end_date, |
| |
16 |
16 |
p.ongoing_p, |
| |
17 |
17 |
p.customer_id as customer_id, f.package_id |
| |
18 |
18 |
FROM pm_projectsx p, |
| |
19 |
19 |
cr_items i, |
| |
20 |
20 |
$extra_role_tables |
| |
21 |
21 |
cr_folders f |
| |
22 |
22 |
WHERE |
| |
23 |
23 |
p.project_id = i.live_revision |
| |
24 |
24 |
and i.parent_id = f.folder_id |
| |
25 |
25 |
$extra_role_where_clause |
| |
26 |
26 |
$extra_query |
| |
27 |
|
and f.package_id in ($package_ids)) proj |
| |
|
27 |
) proj |
| |
28 |
28 |
where exists (select 1 from acs_object_party_privilege_map ppm |
| |
29 |
29 |
where ppm.object_id = proj.project_id |
| |
30 |
30 |
and ppm.privilege = 'read' |
| |
31 |
31 |
and ppm.party_id = :user_id) |
| |
32 |
32 |
[template::list::filter_where_clauses -and -name "projects"] |
| |
33 |
33 |
order by planned_end_date desc |
| |
34 |
34 |
</querytext> |
| |
35 |
35 |
</fullquery> |
| |
36 |
36 |
|
| |
37 |
37 |
</queryset> |
