Zmiany pomiędzy wersją 24 and wersją 25 dla DeployerGuide/AdvancedConfiguration/CustomRegisters

Data i czas:

01/08/15 18:08:27 (9 years temu)

Autor:

MK (IP: 31.61.136.98)

Komentarz:

--

DeployerGuide/AdvancedConfiguration/CustomRegisters

@@ -211 +211 @@
 
 {{{
-{"sql":"select usr_id,usrnam FROM users WHERE {FILTER_STRING}","sql_filter":"firnam ~* E'^{SEARCH_TEXT}'","valueField":"usr_id","labelField":"usrnam"}
+{"sql":"select usr_id, usrnam, 'USER' as clsnam FROM users WHERE {FILTER_STRING}","sql_filter":"firnam ~* E'^{SEARCH_TEXT}'","valueField":"usr_id","labelField":"usrnam"}
 
 {"sql":"SELECT devcid, name__ || ' - ' || COALESCE(sernum) AS device FROM cregisters.creg_devices WHERE {FILTER_STRING}","sql_filter":"sernum ~* E'^{SEARCH_TEXT}' OR name__ ~* E'^{SEARCH_TEXT}'","valueField":"devcid","labelField":"device"}
 
-{"sql":"SELECT contid, COALESCE(name_2, name_1) || ' ' || f_addr AS caption FROM contacts_view WHERE is_del IS FALSE AND {FILTER_STRING} ORDER BY caption","sql_filter":"name_1 ~* E'^{SEARCH_TEXT}' OR name_2 ~* E'^{SEARCH_TEXT}'","valueField":"contid","labelField":"caption"}
-
-}}}
+{"sql":"SELECT contid, COALESCE(name_2, name_1) || ' ' || f_addr AS caption, 'CONTACT' as clsnam FROM contacts_view WHERE is_del IS FALSE AND {FILTER_STRING} ORDER BY caption","sql_filter":"name_1 ~* E'^{SEARCH_TEXT}' OR name_2 ~* E'^{SEARCH_TEXT}'","valueField":"contid","labelField":"caption"}
+
+}}}
+Kolumna clsnam w zapytaniu spowoduje pokazanie ikony "i" umożliwiającej otwarcie formularza powiązanego z danym clsnam (np. 'CONTACT' as clsnam da możliwość otwarcia panelu klienta). Ikona pojawi się po kliknięciu na lupkę (jeśli wyszukanie zakończyła się sukcesem).[[BR]]
 Znacznik {SEARCH_TEXT} zostanie zastąpiony wpisanym w pole tekstem[[BR]]
 Znacznik {FILTER_STRING} zostanie zastąpiony wartością z parametru "sql_filter"[[BR]]