Custom Tickets Select Box Auto-generation
|Reported by:||Owned by:|
|Severity:||normal||Keywords:||tickets custom field|
It would be nice if instead of specifying all the available options for a select box like:
in trac.ini, which could run into hundreds, if instead you could specify some kind of query so that this list is automatically generated from the database and keeps up to date. For example, if you had 'is associated with customer' as a select box and the customers are generated from a 'Customers' table in the database. e.g. 'select name from Customer where active=1' so that only customers who are still active (assuming this list changes quite often) are shown in the list.
Apologies for the poor example.
At the moment I have written a script that reads trac.ini and modifies this manually but it is far from ideal as it only runs once a day so the data isnt always up-to-date