Thu, 24 Sep 2026
Login

JDBC LOAD BINDER plugins question

Confluence User - 25 Oct, 2016

Dear Expert,

How can I specific the where clause to match the form ID. I have try the following and it seem not working

select c_data1, c_data2 from app_fd_table where c_refKey = '#form.table.id#';

 

jdbc;plugins

2

Confluence User •
25 Oct, 2016 •
confluenceUser •
1 •
confluenceUser •

Ok, I got the Answer

the statement should be 

select c_data1, c_data2 from app_fd_table where c_refKey = ?

Simple enough!!!!

Thanks

Confluence User •
11 Jul, 2018 •
confluenceUser •
•
confluenceUser •

If I have multiple condition e.g select c_data1, c_data2 from app_fd_table where c_refKey = ? AND c_data1 = *some other variable on the form but not stored yet* Then, please explain how it can work?

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Plugin for PDF Editor
How do I authenticate to an external API?
API Connector builder
I have installed Joget Generative AI and requested the API Key from Joget Intelligence. But I'm not sure why it show 404 Invalid Issuer when I type my response?
Joget Plugin Static File Paths (JS/CSS) Returning 404
DX8 Communityand LDAP Plugin
is roulette available for add on?
Twilio SmS
how to change image editor or add marking functionality
plugins question for google calender API
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print