Zmiany pomiędzy wersją 18 and wersją 19 dla UserGuide/AdvancedConfiguration/DefiningReports/ReportParams

Data i czas:

05/10/16 20:19:45 (8 years temu)

Autor:

JP (IP: 37.47.3.104)

Komentarz:

--

UserGuide/AdvancedConfiguration/DefiningReports/ReportParams

@@ -332 +332 @@
 WHERE c2.prn_id = c.strcid) > 0 THEN 'FOLDER' ELSE 'ITEM' END AS icon__ 
 FROM cregisters.creg_structure_elements c WHERE c.is_del IS FALSE
+
+
+-- Filtr grupy produktów dla CRM
+-- filtry typu lista wielokrotnego wyboru
+SELECT prc_id FROM processes WHERE prc_id IN (SELECT prc_id FROM processes
+ INNER JOIN fk_elements fe USING(prc_id)
+ INNER JOIN depository dep USING (depoid) 
+ WHERE fe.is_del IS FALSE
+ AND dep.pgr_id IN (13))
+
+--wartości dla listy
+SELECT pgr_id, name__ FROM product_groups WHERE is_act IS TRUE AND is_del IS FALSE ORDER BY name__