metacat/test/test-queries/doc4.sql @ 6025
1 |
SELECT DISTINCT xd.docid,xd.docname,xd.doctype,xd.date_created, xd.date_updated, xd.rev |
---|---|
2 |
FROM xml_documents xd, xml_nodes xn, |
3 |
(
|
4 |
SELECT docid from xml_access |
5 |
WHERE ( |
6 |
(
|
7 |
lower(principal_name) = 'public' |
8 |
AND perm_type = 'allow' |
9 |
AND (permission='4' OR permission='7') |
10 |
)
|
11 |
OR
|
12 |
(
|
13 |
lower(principal_name) = 'public' |
14 |
AND perm_type = 'allow' |
15 |
AND (permission='4' OR permission='7') |
16 |
)
|
17 |
)
|
18 |
AND subtreeid IS NULL |
19 |
MINUS
|
20 |
SELECT docid from xml_access |
21 |
WHERE ( |
22 |
(
|
23 |
lower(principal_name) = 'public' |
24 |
AND perm_type = 'deny' |
25 |
AND perm_order ='allowFirst' |
26 |
AND (permission='4' OR permission='7') |
27 |
)
|
28 |
OR
|
29 |
(
|
30 |
lower(principal_name) = 'public' |
31 |
AND perm_type = 'deny' |
32 |
AND perm_order ='allowFirst' |
33 |
AND (permission='4' OR permission='7') |
34 |
)
|
35 |
)
|
36 |
AND subtreeid IS NULL |
37 |
) xa |
38 |
WHERE xd.rootnodeid = xn.rootnodeid |
39 |
AND xd.docid = xa.docid |
40 |
AND UPPER(xn.nodedata) LIKE '%' |
41 |
/
|