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

Data i czas:

06/19/16 11:31:21 (8 years temu)

Autor:

pwiacek (IP: 95.160.157.238)

Komentarz:

--

UserGuide/AdvancedConfiguration/DefiningReports/ReportParams

@@ -236 +236 @@
 == Przydatne kwerendy SQL do filtrów ==
 
+=== Drzewko miesięcy ===
+
+==== Data wystawienia faktury ====
+
+{{{
+crtdat {value}
+
+select coalesce(
+(select min(coalesce (d.adddat) -interval '1 day') ::date
+FROM 
+documents d
+where d.dctpid in (2) and d.is_del is false and d.gostof is null), current_date::date-interval '1 day')
+union
+select coalesce(
+(select max(d.adddat )::date
+FROM 
+documents d
+where d.dctpid in (2) and d.is_del is false and d.gostof is null),current_date::date)
+}}}
+
 === Filtr drzewka ===