Query Based Dropdown List - choose a different column for the result


#1

The Query Based Dropdown List is great - but I’d like to be able to choose from something human readable but pick a different column (ie a numeric ID) for the result.

Such that I might have a query:

select concat(firstname, " “, surname, " (”, company, “)”) name, id from users;

and when I pick “Joe Smith (Aardvark Ltd)” from the list then the parameter will be populated by that persons numeric id from the id column.


#2

That’s already possible. If the query you use as input for a dropdown has a column named name and a column named value, they will be used as the name and value columns in the dropdown.