Database Update Tool Question

 
1
0
-1

Hi, I was wondering if it is possible to update the main dir_user directory using the database update tool in the Processes Map Tools to Plugin option. I tried including my query

 

INSERT dbo.dir_user SET
active = '1',
email = '#form.useraccount.email#',
firstName = '#form.useraccount.firstName#',
id = '#form.useraccount.username#',
lastName = '#form.useraccount.lastName#',
password = MD5('#form.useraccount.password#'),
timeZone = '#form.useraccount.timeZone#',
locale = '1',
username = '#form.useraccount.username#';

 

but when I submit my form the data from my form is not inserted into my dir_user in MS SQL

    CommentAdd your comment...

    3 answers

    1.  
      1
      0
      -1

      You can try to use the Directory Form Binder instead of composing your own SQL statement.

      1. John Smith

        Using this method worked too but is it possible to capture the data inputted in my form to multiple database tables? Using the Directory Form Binder causes data in my Form Table to be NULL, I'm trying to get both data inputted in my Form table and dir_user.

      2. Walter

        Yes, it is possible to call multiple store binder with one set of form data. You can check out the example used in https://dev.joget.org/community/display/KBv5/Bean+Shell+Programming+Guide#BeanShellProgrammingGuide-8.Reuseexistingpluginsinyourcodetomakeitcleanerandeasytomaintain

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

      Hi Matthew,

      I am actually trying to create an additional form so that new users would be able to create accounts for themselves thus removing the need for me to create new users individually. The Database Update Tool can add data to other tables other than the default ones created by Joget.

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

        Hi John Smith

        Do download and try out the free Joget app to create user account in Joget Marketplace which emulate what you are trying to do above. You can examine the forms and processes, including examples on using the Database Update Tool in your workflow.

        Tip: Ensure you use the "Run Process" menu to execute the workflow, and not the CRUD Add menu.

          CommentAdd your comment...