Dear All,

I am running a Joget cloud instance ;

Have two questions around the below scenarios;

A- trying to populate a select box value using 'user options binder' inside a form (which fetches the user information from 'dir_user' table).However, it only sets 'username' for respective selection. I need to get first name & last name instead, but didn't have much joy.

Test Procedure:

i) Create a form > define a select box ('batch owner" in my case)  with 'user options binder' > choose organization-department-group with handful of users in it. > set first name /last name for the label

ii) Create Datalist including the select box field in the above form 

iii) Launch the app and open the form > you may see the user first name/last name populated against select box field while creating form. select a value and submit form

iv) launch the fatalist > you will always see the username against the field linked with the select box in question.

Question1: Can any one suggest any easier way to achieve the above

B)The work around I am pursuing  for the above scenario is to access the backend DB table to pull the desired field with a SQL query. But unable to get the backend DB connected and successfully tested. I tried this via 'JDBC Datalist Database Binder'.

Test Procedure: {{ THIS CAN ONLY BE REPRODUCED on JOGET Cloud instance}}

i) Create a Data list

ii) Instead of form data binder, pick 'JDBC Datalist Database Binder'

iii) choose custom data source and note the JDBC connection details there

iv) The default value out there seems to be not right for the backend DB instance.

Question2: Anybody have idea on what would be the JDBC URL and credentials if I wanna access my Joget instance's schema/db?

Thanks in advance for your time.

Cheers,

Rash.