Project

General

Profile

metacat / test / test-queries / doc1.sql @ 5397

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