Zmiany pomiędzy wersją 12 and wersją 13 dla DeployerGuide/Custumization/AdvancedReporting/SQLExamples

Data i czas:

04/29/14 15:02:02 (11 years temu)

Autor:

JP (IP: 78.31.141.182)

Komentarz:

--

DeployerGuide/Custumization/AdvancedReporting/SQLExamples

@@ -259 +259 @@
 ORDER BY data__
 
+-- Wybór komórek
+select orunid, COALESCE(orunsm, '') || ' - ' || ndenam AS stanowisko
+from orgtree_view 
+WHERE orunid > 0 AND ndetpe = 'ORGCELL' AND orunsm IS NOT NULL
 
 }}}