Lookup first name and last name in datalist

 
1
0
-1

Hi


I have a form with a select box looking up the user options binder to get the users so a user can be selected in the form. I have it displaying by name. This is then stored as usernames. 

When displaying a datalist I cant figure out how to get that column to display as a first name and last name and not the username.

I have tried making a JDBC sql with an inner join to the dir_user table which keeps coming up with an error in the logs "duplicate id"

I have tried a hidden field using a nested has such as

#user.{form.formname.completed_by}.firstName# #user.{form.formname.completed_by}.lastName#

but this saves as the hash code above and doesnt look it up.


Any ideas? I'm sure its simple but I'm missing something and have searched everywhere.


Thanks

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi, you might want to check the form data hash variable in your hidden field. According to the docs Hash Variable#FormDataHashVariable it should be form.tableName.fieldId.

      1. Jason

        Hi

        I have put the below into my hidden field default value. The field "completed_by" is a select box of all Joget users. 

        #user.{form.app_fd_hse_inspect_workshop.completed_by}.firstName# #user.{form.app_fd_hse_inspect_workshop.completed_by}.lastName#

        The above is hash code inserted into the hidden cell and not the look up of the hash. 


        Interesting I have the below as a hash in an email as part of the process and it works fine:

        #user.{form.hse_inspect_workshop.completed_by}.firstName# #user.{form.hse_inspect_workshop.completed_by}.lastName#

      CommentAdd your comment...