05/04/2023 01:06 AM
Hi,
when we use an SQL ENUM dynamic attribute we need an id column and can additionally use inlinedescription, e.g.:
SELECT userkey AS id, CONCAT(firstname, ' ', lastname) AS inlinedescription FROM ....
This would result in an entry in the drop down that looks like this:
12345: John Doe
We'd like to only display the inlinedescription part, so:
John Doe
Is this possible?
Solved! Go to Solution.
05/04/2023 02:13 AM
I assume that you only need John Doe as value in drop down. So you can try as below.
SELECT CONCAT(firstname, ' ', lastname) AS id FROM ..
05/04/2023 03:11 AM
But I need a certain id for the mapping to user column like manager or owner.
06/06/2023 02:29 AM
Hi @ASA
Without the id column as user key its not possible to update and there is no way to hide it. But you can use username instead of user key which can be okay for users and use the owner column in the mapping.
Sql:
SELECT username AS id, CONCAT(firstname, ' ', lastname) AS inlinedescription FROM ....
Thanks
Darshan
06/06/2023 03:30 AM
Hi Darshan,
this is a good alternative to use the username. Didn't know about the "owner" column.
Thanks a lot!