JDBC Select get column output and put into a form? for e.g. a user login page

 
1
0
-1

Hi,


I have a pre-existing database with data in it, I need to be able to edit these fields and to do so I need to pull that data back into a form, edit the data then submit the form to update the table in the database.


I have been trying to figure out how to get the output from the select statement for process builder, and forms to get the data into a form, or into a new process. Is there anyone that is able to help me or jump on discord and give me some tips?

Regards

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Joget process creates new records based on a predetermined id pattern, so it won't work with an external database as the primary table unless you add the form for your external table as a Subform to the parent Joget form (and the Subform has its own JDBC Form Binder to read/write the records back to the external table).

        CommentAdd your comment...