|
|
|
 |
-
/tcl/bug-tracker-procs-postgresql.xql
(+2 -2)
-
| |
1 |
1 |
<?xml version="1.0"?> |
| |
2 |
2 |
|
| |
3 |
3 |
<queryset> |
| |
4 |
4 |
<rdbms><type>postgresql</type><version>7.1</version></rdbms> |
| |
5 |
5 |
|
| |
6 |
6 |
<fullquery name="bug_tracker::bug_notify.bug"> |
| |
7 |
7 |
<querytext> |
| |
8 |
8 |
|
| |
9 |
9 |
select b.bug_id, |
| |
10 |
10 |
b.bug_number, |
| |
11 |
11 |
b.summary, |
| |
12 |
12 |
b.project_id, |
| |
13 |
13 |
o.creation_user as submitter_user_id, |
| |
14 |
14 |
submitter.first_names as submitter_first_names, |
| |
15 |
15 |
submitter.last_name as submitter_last_name, |
| |
16 |
16 |
submitter.email as submitter_email, |
| |
17 |
17 |
b.component_id, |
| |
18 |
18 |
c.component_name, |
| |
19 |
19 |
o.creation_date, |
| |
20 |
|
to_char(o.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty, |
| |
|
20 |
to_char(o.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty, |
| |
21 |
21 |
st.pretty_name as status, |
| |
22 |
22 |
b.resolution, |
| |
23 |
23 |
b.user_agent, |
| |
24 |
24 |
b.found_in_version, |
| |
25 |
25 |
b.fix_for_version, |
| |
26 |
26 |
b.fixed_in_version, |
| |
27 |
|
to_char(now(), 'fmMon/DDfm/YYYY') as now_pretty |
| |
|
27 |
to_char(now(), 'YYYY-MM-DD HH24:MI:SS') as now_pretty |
| |
28 |
28 |
from bt_bugs b, |
| |
29 |
29 |
acs_objects o, |
| |
30 |
30 |
bt_components c, |
| |
31 |
31 |
cc_users submitter, |
| |
32 |
32 |
workflow_cases cas, |
| |
33 |
33 |
workflow_case_fsm cfsm, |
| |
34 |
34 |
workflow_fsm_states st |
| |
35 |
35 |
where b.bug_id = :bug_id |
| |
36 |
36 |
and b.project_id = :package_id |
| |
37 |
37 |
and o.object_id = b.bug_id |
| |
38 |
38 |
and c.component_id = b.component_id |
| |
39 |
39 |
and submitter.user_id = o.creation_user |
| |
40 |
40 |
and cas.object_id = b.bug_id |
| |
41 |
41 |
and cfsm.case_id = cas.case_id |
| |
42 |
42 |
and cfsm.current_state = st.state_id |
| |
43 |
43 |
|
| |
44 |
44 |
</querytext> |
| |
45 |
45 |
</fullquery> |
| |
46 |
46 |
|
| |
47 |
47 |
|
|