Question & Answer > View Question

Retrieved data from different table MSQL Server 2014

Confluence User - 20 Oct, 2015

Hi,

I'm using MSQL Server 2014 to store user's information from joget workflow v4. And i noticed that we can use hash variables to retrieved the data back to de displayed into joget form. The question is, how can i retrieved the data from different table and show it into one sentence inside joget form. Example, i have userid on table dir_userid, and username on table dir_username. I want to retrieved userid and username from database inside MSSQL Server but they are on different tables, and show it into one sentence inside joget form. What hash variables that i must use? Or there have another way to achieve it? (Sorry for my bad english).

Huge thanks.

forms;retrieved;database

2

Confluence User •

20 Oct, 2015 •

confluenceUser •

•

confluenceUser •

Hi,

you can check on available hash variables Here: Default Hash Variable

Others than that, I think you have to create a plugin.

Cheers,

Yonathan

Confluence User •

20 Oct, 2015 •

confluenceUser •

•

confluenceUser •

Hi there,

It seems that the available Hash Variables won't work in your scenario.
You could try to create a Hash Variable plugin for yourself to achieve this or you could simply use a Bean Shell Load Binder inside your form to load the data via JDBC.

Hope this helps.

Thanks!

1

CSV | Excel | XML | PDF

Your answer

Print

Retrieved data from different table MSQL Server 2014

2

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

2.builder-style-edf187f1-16ce-4743-8587-26c3d58f1c7e{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-f800d266-d07d-43e7-9969-1d4f964ebdfd{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

2

Your answer