Zmiany pomiędzy wersją 5 and wersją 6 dla DeployerGuide/Custumization/AdvancedReporting/SQLExamples

Data i czas:

12/18/13 00:33:04 (11 years temu)

Autor:

JP (IP: 89.70.109.53)

Komentarz:

--

DeployerGuide/Custumization/AdvancedReporting/SQLExamples

@@ -186 +186 @@
 WHERE clsnam = 'DOCUMENT|2' ORDER BY state_
 
+-- Osoby z cech do których użytkownik ma prawo
+SELECT ftopid, ftopnm
+FROM 
+features_options 
+INNER JOIN features_options_def USING(fodfid)
+LEFT JOIN users u ON u.initls = ftopnm
+LEFT JOIN orgtree_view ov ON ov.usr_id = u.usr_id
+WHERE featid = 91
+AND (CASE WHEN (SELECT count(*) > 0 FROM users_link_group WHERE grp_id = 29 AND usr_id = {LOGGED_USR_ID}) THEN 1 = 1 ELSE chkUsrOrgAcc({LOGGED_USR_ID}, ov.orunid) IS TRUE END)
+ORDER BY ftopnm
+
 }}}