|
|
|
 |
-
openacs-4/.../templates/project-ae-oracle.xql
(+41)
-
| |
|
1 |
<?xml version="1.0"?> |
| |
|
2 |
<queryset> |
| |
|
3 |
<fullquery name="project_query"> |
| |
|
4 |
<querytext> |
| |
|
5 |
SELECT p.item_id as project_item_id, |
| |
|
6 |
p.parent_id, |
| |
|
7 |
p.project_id, |
| |
|
8 |
p.title as project_name, |
| |
|
9 |
p.project_code, |
| |
|
10 |
p.goal, |
| |
|
11 |
p.description, |
| |
|
12 |
p.customer_id, |
| |
|
13 |
p.status_id, |
| |
|
14 |
to_char(p.planned_start_date,'YYYY-MM-DD') as planned_start_date, |
| |
|
15 |
to_char(p.planned_end_date,'YYYY-MM-DD') as planned_end_date, |
| |
|
16 |
p.ongoing_p |
| |
|
17 |
p.dform |
| |
|
18 |
FROM pm_projectsx p |
| |
|
19 |
WHERE p.item_id = :project_item_id and |
| |
|
20 |
p.project_id = :project_id |
| |
|
21 |
</querytext> |
| |
|
22 |
</fullquery> |
| |
|
23 |
|
| |
|
24 |
<fullquery name="do_nothing"> |
| |
|
25 |
<querytext> |
| |
|
26 |
SELECT sysdate |
| |
|
27 |
from dual |
| |
|
28 |
</querytext> |
| |
|
29 |
</fullquery> |
| |
|
30 |
|
| |
|
31 |
<fullquery name="get_status_codes"> |
| |
|
32 |
<querytext> |
| |
|
33 |
SELECT description, |
| |
|
34 |
status_id |
| |
|
35 |
FROM pm_project_status |
| |
|
36 |
ORDER BY status_type desc, |
| |
|
37 |
description asc |
| |
|
38 |
</querytext> |
| |
|
39 |
</fullquery> |
| |
|
40 |
|
| |
|
41 |
</queryset> |
|