Project

General

Profile

1 2230 jones
SELECT docid,docname,doctype,date_created, date_updated, rev
2
  FROM xml_documents
3
 WHERE docid IN ((SELECT DISTINCT docid FROM xml_nodes WHERE  UPPER(nodedata) LIKE '%' ))
4
   AND
5
   (docid IN
6
      (SELECT docid FROM xml_documents WHERE lower(user_owner) ='public')
7
   OR
8
   (docid IN
9
         (SELECT docid from xml_access
10
           WHERE (
11
                 (lower(principal_name) = 'public'
12
                 AND perm_type = 'allow'
13
                 AND (permission='4' OR permission='7'))
14
                 OR (lower(principal_name) = 'public'
15
                 AND perm_type = 'allow'
16
                 AND (permission='4' OR permission='7')))
17
                 AND subtreeid IS NULL)
18
                 AND docid NOT IN
19
                 (SELECT docid from xml_access
20
                 WHERE( (lower(principal_name) = 'public'
21
                 AND perm_type = 'deny'
22
                 AND perm_order ='allowFirst'
23
                 AND (permission='4' OR permission='7'))
24
                 OR (lower(principal_name) = 'public'
25
                 AND perm_type = 'deny'
26
                 AND perm_order ='allowFirst'
27
                 AND (permission='4' OR permission='7')))
28
                 AND subtreeid IS NULL )))
29
/