Zmiany pomiędzy wersją 16 and wersją 17 dla DeployerGuide/Customization/AdvancedReporting

Data i czas:

05/07/11 14:08:54 (13 years temu)

Autor:

JP (IP: 89.72.141.179)

Komentarz:

--

DeployerGuide/Customization/AdvancedReporting

@@ -115 +115 @@
 AND e.start_ <= d.adddat) AS spotkania,
 -- wartość pola featid 98
-f3.data__::int AS odwedok
+f3.data__::int AS odwedok,
+f4.ftopnm AS cecha4
 FROM documents d
-INNER JOIN features_text_view f3 ON d.doc_id = f3.tbl_id AND f3.featid = 98;
+INNER JOIN features_text_view f3 ON d.doc_id = f3.tbl_id AND f3.featid = 98
 -- cecha z listy wyboru
-INNER JOIN features_opt_view f3 ON d.is_del IS NOT true AND d.gostof IS NULL AND d.doc_id = f3.tbl_id AND f3.ftopid = 119
+INNER JOIN features_opt_view f4 ON d.doc_id = f4.tbl_id AND f4.ftopid = 119
+WHERE d.is_del IS NOT true AND d.gostof IS NULL 
 
 --