Zmiany pomiędzy wersją 23 and wersją 24 dla UserGuide/AdvancedConfiguration/DefiningReports/ReportParams

Data i czas:

06/19/16 11:44:02 (8 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]
- 9. [#dynamiczne Dynamiczne powiązanie]
+ 9. [#dynamiczne Dynamiczne grupowanie]
  10. [#filtrysql Przydatne kwerendy SQL do filtrów]
   a) [#miesiecy Drzewko miesięcy]
@@ -261 +261 @@
 }}}
 
+==== Filtr okresu urlopu ====
+
+{{{
+pocz_urlop in (select s FROM generate_series('2008-03-01 00:00'::timestamp,'2050-03-04 00:00', '1 day') as S where s {value})
+or
+kon_urlop in (select s FROM generate_series('2008-03-01 00:00'::timestamp,'2050-03-04 00:00', '1 day') as S where s {value})
+or
+(pocz_urlop < (select min(s) FROM generate_series('2008-03-01 00:00'::timestamp,'2050-03-04 00:00', '1 day') as S where s {value})
+and
+kon_urlop > (select max(s) FROM generate_series('2008-03-01 00:00'::timestamp,'2050-03-04 00:00', '1 day') as S where s {value}))
+
+select coalesce(
+(select min(CAST(f1.data__ AS date)  -interval '1 day') ::date
+FROM documents doc
+LEFT JOIN features_text_view f1 ON doc.doc_id = f1.tbl_id AND f1.featid = 4 /*data od*/
+where dctpid = 24 AND gostof IS NULL and  copyof is null AND  doc.is_del IS FALSE and f1.data__ is not null), current_date::date-interval '1 day')
+union
+select coalesce(
+(select max(CAST(f1.data__ AS date))::date
+FROM documents doc
+LEFT JOIN features_text_view f1 ON doc.doc_id = f1.tbl_id AND f1.featid = 4 /*data od*/
+where dctpid = 24 AND gostof IS NULL and  copyof is null AND  doc.is_del IS FALSE and f1.data__ is not null),current_date::date)
+}}}
+
+
+
 === Filtr drzewka === #drzewka