Retrieved data from different table MSQL Server 2014

 
1
0
-1

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.

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      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! 

        CommentAdd your comment...
      1.  
        1
        0
        -1

        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

          CommentAdd your comment...