Thu, 24 Sep 2026
Login

Hashvariable In JdbcFormBinder

Confluence User - 14 Jun, 2023

Hi, I uesd Hashvariable in JdbcFormBinder (eg. select 'string' from tableA where 1=1 or id = #form.tableName.id?sql#), record is empty so hashvariable is not porceeed. correct sql output is 'string' .  But in jdbcbinder, sql contains ? is treated as not set primarykey, so return directly,  actual output is empty.  I wonder how to avoid this problem ?

(I had debuged the platform source code found this problem)

forms

1

Confluence User •
15 Jun, 2023 •
confluenceUser •
•
confluenceUser •

Simple use the following SQL guide, for example in a process tool:

select from app_fd_tableA where id = '#form.tableName.id#'

Read Hash Variable

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Error storing data
How to generate unique ID using Textfield?
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print