• (select) Lista pracowników (usr_id) ze wskazanej grupy

{
  "sql": "SELECT o.usr_id AS value, o.lasfir AS caption FROM users_link_group ulg INNER JOIN orgtree_view o ON o.usr_id = ulg.usr_id AND ulg.grp_id = 1 ORDER BY 2"
}

• (select) Lookup pracowników (multiselect)

{
  "sql": "SELECT orunid, lasfir, 'USER' AS clsnam FROM orgtree_view WHERE usr_id > 0 AND {FILTER_STRING} ORDER BY lasfir",
  "sql_filter": "lasfir ~* E'^{SEARCH_TEXT}'",
  "valueField": "orunid",
  "labelField": "lasfir",
  "multiselect": true
}

• (select) Pole wyboru niepowiązanych faktur PROFORM

{
    "sql": "SELECT v.doc_id, 'Nr:' || COALESCE(v.number, 'brak nr') || ' - ' || COALESCE(v.amount, 0) || ' ' || COALESCE(v.cursmb, '') || ' Wystawiona ' || seldat::DATE AS clsnam FROM vatnote v JOIN types_of_accountants_doc typ USING (accdid) JOIN documents doc USING (doc_id) WHERE doc.is_del IS FALSE AND (typ.dscrp4 = 'PRO' OR typ.isprfm IS TRUE) AND v.frctid = (SELECT frctid FROM vatnote WHERE doc_id = {DOC_ID}) AND v.doc_id NOT IN (SELECT v.doc_id AS doc_id FROM vatnote v JOIN types_of_accountants_doc typ USING (accdid) JOIN documents doc USING (doc_id) JOIN doc_link_doc doc1 ON doc1.doc_id = v.doc_id JOIN vatnote vdoc1 ON vdoc1.doc_id = doc1.rel_to WHERE (typ.dscrp4 = 'PRO' OR typ.isprfm IS TRUE) AND v.frctid = (SELECT frctid FROM vatnote WHERE doc_id = {DOC_ID}) AND vdoc1.doc_id IS NOT NULL AND doc.is_del IS FALSE UNION SELECT v.doc_id AS doc_id FROM vatnote v JOIN types_of_accountants_doc typ USING (accdid) JOIN documents doc USING (doc_id) JOIN doc_link_doc doc2 ON doc2.rel_to = v.doc_id JOIN vatnote vdoc2 ON vdoc2.doc_id = doc2.doc_id WHERE (typ.dscrp4 = 'PRO' OR typ.isprfm IS TRUE) AND v.frctid = (SELECT frctid FROM vatnote WHERE doc_id = {DOC_ID}) AND vdoc2.doc_id IS NOT NULL AND doc.is_del IS FALSE)",
    "valueField": "doc_id",
    "labelField": "clsnam"
}