fm:query – Recap

 

• SQL executed for each element located on run-query match attribute (Subject Element)
• Input Bind variables are evaluated for each execution relative to the Subject Element
• Output result rows are written to target-path that is relative to Subject Element

EXAMPLE

1. Query fields:

1. fm:db-interface declaration

<fm:db-interface-list>
  <fm:db-interface name="dbint-fields">
    <fm:query name="qry-fields">
    <fm:target-path match="/S29G_ADDFIELD/RESULTS_LIST/S29_FIELD"/>
    <fm:select>
SELECT
f.field_identifier "FIELD/FIELD_IDENTIFIER"
, f.name "FIELD/NAME"
, drc.rv_meaning "STATUS"
, '' "TICKBOX"
FROM  appenv.fields f, appenv.devuk_ref_codes drc
WHERE f.status = drc.rv_low_value
AND   drc.rv_domain = 'FLDSTS' 
ORDER BY f.name, f.status
    </fm:select>
    </fm:query>
  </fm:db-interface>
</fm:db-interface-list>

2. fm:run-query command

<fm:run-query interface="dbint-fields" query="qry-fields"/>