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:
Is this possible?
Solved! Go to Solution.
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.
SELECT username AS id, CONCAT(firstname, ' ', lastname) AS inlinedescription FROM ....