Zmiany pomiędzy wersją 7 and wersją 8 dla UserGuide/AdvancedConfiguration/DefiningReports/ReportParams

Data i czas:

06/16/14 14:00:39 (10 years temu)

Autor:

JP (IP: 46.204.162.214)

Komentarz:

--

UserGuide/AdvancedConfiguration/DefiningReports/ReportParams

@@ -223 +223 @@
 SELECT tpstid, dscrpt FROM  types_of_processes_states WHERE clsnam = 'PROCESS' ORDER BY state_
 }}}
+
+KOMÓRKI ORGANIZACYJNE 
+{{{
+SELECT orunid, orunsm AS caption 
+FROM organization_units 
+WHERE is_del IS FALSE 
+AND orunid > 0 
+AND ndetpe = 'ORGCELL'
+AND chkUsrOrgAcc({LOGGED_USR_ID}, orunid) - ten filtr ogranicza do tych do których user ma prawo
+ORDER BY orunsm
+}}}