Question & Answer > View Question

Lookup first name and last name in datalist

Confluence User - 29 Apr, 2020

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

datalists;user

2

Confluence User •

30 Apr, 2020 •

confluenceUser •

•

confluenceUser •

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.

Confluence User •

30 Apr, 2020 •

confluenceUser •

•

confluenceUser •

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#

1

CSV | Excel | XML | PDF

Your answer

Print

Lookup first name and last name in datalist

2

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

2.builder-style-db7918f6-53f6-4807-897c-633fcf09377f{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-20ec1dea-a4d9-46bd-bc10-7441f0c0ed54{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

2

Your answer