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

Data i czas:

06/19/16 11:27:14 (9 years temu)

Autor:

pwiacek (IP: 95.160.157.238)

Komentarz:

--

UserGuide/AdvancedConfiguration/DefiningReports/ReportParams

@@ -50 +50 @@
  7. [#typ_opcji Typ opcji]
  8. [#powiazania Jeden filtr wiele raportów]
+ 
 
 
@@ -235 +236 @@
 == Przydatne kwerendy SQL do filtrów ==
 
+=== Filtr drzewka ===
+
+==== MPK na fakturach ====
+
+Filtr pozwala na znajdowanie faktur kosztowych ze względu na wybrane MPK
+
+{{{
+keyval in (select doc_id from vatnote_costs where povcid in ({value}))
+
+select povcid as keyval, prn_id,  place_||' '||coalesce (dscrpt,'') name__, 'FOLDER' AS icon__ FROM places_of_vcosts where year__ = 
+EXTRACT(year FROM current_date)  and is_del is false
+order by name__
+}}}
+
+==== RK na fakturach ====
+Filtr pozwala na znajdowanie faktur kosztowych ze względu na wybrane RK
+
+{{{
+keyval in (select doc_id from vatnote_costs where tovcid in ({value}))
+
+select tovcid as keyval, prn_id,  type__||' '||coalesce (dscrpt,'') name__, 'FOLDER' AS icon__ FROM types_of_vcosts where year__ = 
+EXTRACT(year FROM current_date)  and is_del is false
+order by name__
+}}}
+
+
+=== Inne ===
 MAGAZYNY
 {{{