Can "select" type be a lookup into the database?

[jerry2038]

I installed CustomFieldAdmin tonight, and it seems very handy. I would like to suggest that the select type be either a list of options as it is now that produces a dropdown box, OR, a SQL statement that produces a list of {key, label} pairs used to populate the dropdown.

(That way we could tie trac into other aspects of our projects and have the dropdowns always be as accurate as our other web database applications... If that makes sense.)

Example:

Select:

select key, name from software_version; or select test_case_id, test_case_name from test_case;

[osimons]

Sorry, but no: All this plugin does is edit the trac.ini file. Without support for dynamic lookup in Trac there is nothing the plugin can do as it does not (and should not) replace Trac ticket and query code.