using current field value in a jdbc clause
Confluence User - 15 Dec, 2019
Hi - I am trying bind a select box with a jdbc query that references a drop down value on the same form:
drop down name: sku
form : lookupproduct
form: product
I tried the following:
SELECT c_VariantPrice, c_VariantPrice
FROM aimsware.app_fd_products
WHERE c_VariantSku = #binder.product.Sku#
but It doesnt populate....
any hints on how to reference the value from the Sku dropdown in the query?
jdbc;clause;dropdown