Skip to content

Instantly share code, notes, and snippets.

@marianogonzalez

marianogonzalez/dynamicquery.xml

Created October 12, 2017 22:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save marianogonzalez/ef2896a2a5f7a7fbc7fdce2e8ca03563 to your computer and use it in GitHub Desktop.
Save marianogonzalez/ef2896a2a5f7a7fbc7fdce2e8ca03563 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
dynamicquery.xml
<set-variable variableName="table" value="PLANET"/>
<db:select config-ref="dbConfig">
<db:sql>#["SELECT * FROM $(vars.table) WHERE name = :name"]</db:sql>
<db:input-parameters>
#[{'name' : payload}]
</db:input-parameters>
</db:select>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment