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


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.


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.