Zmiany pomiędzy wersją 19 and wersją 20 dla DeployerGuide/Custumization/AdvancedReporting/SQLExamples

Data i czas:

06/06/14 14:50:23 (10 years temu)

Autor:

JP (IP: 188.146.29.243)

Komentarz:

--

DeployerGuide/Custumization/AdvancedReporting/SQLExamples

@@ -265 +265 @@
 WHERE orunid > 0 AND ndetpe = 'ORGCELL' AND orunsm IS NOT NULL
 
+
+-- Select listy dokumentów do których uprawniona jest grupa użytkownika
+SELECT * FROM documents_view WHERE is_del IS NOT TRUE AND (SELECT prtpid = 11) 
+AND doc_id IN (
+  SELECT doc_id FROM doc_link_users dlu   
+  WHERE dlu.grp_id IN (SELECT grp_id FROM users_link_group glu WHERE glu.usr_id = 2)
+  AND dlu.doc_id = doc_id 
+)
+
 }}}