Zmiany pomiędzy wersją 37 and wersją 38 dla DeployerGuide/Customization/ProcessAutomation/Examples

Data i czas:

11/03/12 19:51:09 (12 years temu)

Autor:

JP (IP: 89.78.227.245)

Komentarz:

--

DeployerGuide/Customization/ProcessAutomation/Examples

@@ -155 +155 @@
 SELECT orunid as value, fullnm || ' - ' || ndenam as caption FROM orgtree_view WHERE orunid IN (3,14,15,16)
 
+-- Członkowie grupy o id 9
+SELECT o.orunid AS value, o.fullnm AS caption FROM users_link_group ulg INNER JOIN orgtree_view o ON o.usr_id = ulg.usr_id AND ulg.grp_id = 9 ORDER BY caption 
+
+-- 
+-- Wszyscy pracownicy (lista jednokrotnego wyboru)
+SELECT orunid as value, fullnm || ' - ' || ndenam as caption FROM orgtree_view WHERE ndetpe = 'POST' AND is_del IS FALSE AND usr_id IS NOT NULL
+}}}
+
 == DYNAMICZNE WARTOŚCI PARAMETRÓW KOMEND ==
-
+{{{
 -- Utwórz komentarz
 dscrpt="SQL::SELECT CASE WHEN (SELECT EXISTS(
@@ -171 +179 @@
 start_="SQL::SELECT fxterm - interval '3 days' FROM vindication.vind_proc_view WHERE prc_id = {PRC_ID}",dscrpt="Uwaga! Za 3 dni mija termin zapłaty za wierzytelność"
 
--- 
--- Wszyscy pracownicy
-SELECT orunid as value, fullnm || ' - ' || ndenam as caption FROM orgtree_view WHERE ndetpe = 'POST' AND is_del IS FALSE AND usr_id IS NOT NULL
 
 }}}