|
|
|
 |
-
openacs-4/.../list1a/index-oracle.xql
(+7 -6)
-
| |
1 |
1 |
<?xml version="1.0"?> |
| |
2 |
2 |
<queryset> |
| |
3 |
3 |
<rdbms><type>oracle</type><version>8.1.6</version></rdbms> |
| |
4 |
4 |
|
| |
5 |
5 |
<fullquery name="template_demo_notes"> |
| |
6 |
6 |
<querytext> |
| |
7 |
|
select template_demo_note_id, title, body, |
| |
8 |
|
decode(acs_permission.permission_p(template_demo_note_id, |
| |
|
7 |
select n.template_demo_note_id, |
| |
|
8 |
n.title, |
| |
|
9 |
n.body, |
| |
|
10 |
decode(acs_permission.permission_p(n.template_demo_note_id, |
| |
9 |
11 |
:user_id, |
| |
10 |
12 |
'write'), |
| |
11 |
13 |
't', 1, |
| |
12 |
14 |
'f', 0) as write_p, |
| |
13 |
|
decode(acs_permission.permission_p(template_demo_note_id, |
| |
|
15 |
decode(acs_permission.permission_p(n.template_demo_note_id, |
| |
14 |
16 |
:user_id, |
| |
15 |
17 |
'admin'), |
| |
16 |
18 |
't', 1, |
| |
17 |
19 |
'f', 0) as admin_p, |
| |
18 |
|
decode(acs_permission.permission_p(template_demo_note_id, |
| |
|
20 |
decode(acs_permission.permission_p(n.template_demo_note_id, |
| |
19 |
21 |
:user_id, |
| |
20 |
22 |
'delete'), |
| |
21 |
23 |
't', 1, |
| |
22 |
24 |
'f', 0) as delete_p |
| |
23 |
25 |
from template_demo_notes n, acs_objects o |
| |
24 |
26 |
where n.template_demo_note_id = o.object_id |
| |
25 |
|
and o.context_id = :package_id |
| |
26 |
27 |
and exists (select 1 |
| |
27 |
28 |
from acs_object_party_privilege_map |
| |
28 |
|
where object_id = template_demo_note_id |
| |
|
29 |
where object_id = n.template_demo_note_id |
| |
29 |
30 |
and party_id = :user_id |
| |
30 |
31 |
and privilege = 'read') |
| |
31 |
32 |
order by creation_date |
| |
32 |
33 |
</querytext> |
| |
33 |
34 |
</fullquery> |
| |
34 |
35 |
|
| |
35 |
36 |
</queryset> |
|