Register User Form // Update User // Display the value of user.employeeclass for acutal user

[Volker]

Hi,

I have an use case for user form.

We would like to display the actual value of the users employeeclass in the form.

The field is configured:

• as type "Single Select From SQL Query" / "SQL ENUM".
• Values: select DISTINCT employeeclass as id from users where employeeclass <> "EMP"
• Default Values:select employeeclass as id from users where username = {username}

In create use case it works with that statement, in update use case no default value is displayed. The field "username" exist as well on the form and is linked with the "User Column" "username"

Any hint how to accomplish that task?

Thanks and best regards

[rushikeshvartak]

In case of create account default value works for update user value is picked from user column configuration under dynamic attribute.

make sure employee class is updated for user 

[Volker · Accepted solution]

Thanks for your answer.

The root cause was the data quality in test environment. Additionally the statement has missed a "$" .

I have changed the SQL to do a check for existing value first and now I get the expected result:

select case when u.employeeclass is null or u.employeeclass = '' then "Please Select" else u.employeeclass end as id from users u where u.username = ${username}