Question & Answer > View Question

How can we add a query(Jdbc Binder) in textfield

Confluence User - 05 Jan, 2018

Hi All,

I created one form i kept select box for my requestor name field,Based on the requestor name i have to auto- capture some fields like division,designation,grade,company location.So i kept all fields as select box and i used JDBC binder and i wrote queries to get those fields but i need to put TextField instead of select box,if i put textfield how shall i write a query.

joget5

3

Confluence User •

05 Jan, 2018 •

confluenceUser •

•

confluenceUser •

Hi

Just assign the current user hash variable into 'hidden fields' or 'textfield' and set default "value" field to store the logged in user's org, dept, grade, group etc. Place this in the first form of your process as it will be executed by the requester of the process/task.

Example: value: #currentUser.department.id#

Do try out the Joget Marketplace Tutorial App: Hash Variable that demonstrate the many uses of Joget hash variables.

Confluence User •

08 Jan, 2018 •

confluenceUser •

•

confluenceUser •

Hi,

based upon the query i have to recapture those fields when i kept hash variables i am not getting .

thanks

Confluence User •

25 Feb, 2021 •

confluenceUser •

•

confluenceUser •

Any one have answer same problem I am facing

1

CSV | Excel | XML | PDF

Your answer

Print

How can we add a query(Jdbc Binder) in textfield

3

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

3.builder-style-e1dc9b16-2956-447e-9260-2b6f2d0a2903{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-598935d6-c393-4ceb-bb45-494d84ad8dbf{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

3

Your answer