Edgewall Software

Opened 16 years ago

Last modified 7 years ago

#4374 new enhancement

Custom Tickets Select Box Auto-generation

Reported by: a.rodger@… Owned by:
Priority: low Milestone: next-major-releases
Component: ticket system Version: 0.10.2
Severity: normal Keywords: tickets custom field
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:


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

Attachments (0)

Change History (6)

comment:1 by Christian Boos, 15 years ago

Milestone: 2.0

That could be an idea related idea to #2464… The possible values for a field could depend on those of other fields, for example.

However, the interface will necessarily be much more complex in this case (either use XHR, or without javascript, it would be necessary to update the page after a change, as when adding a filter in custom queries).

For the reason, I'm moving this to 2.0, although the idea is interesting.

comment:2 by Christian Boos, 15 years ago

For a static generation of options (i.e. a list which wouldn't change depending on the other selected fields like the alternative I discussed in comment:1), see #4549.

comment:3 by Christian Boos, 15 years ago

Keywords: field added

comment:4 by Christian Boos, 12 years ago

Milestone: 2.0unscheduled

Milestone 2.0 deleted

comment:5 by Christian Boos, 12 years ago

Milestone: triagingnext-major-0.1X
Priority: normallow

FieldRefactoring related.

comment:6 by Ryan J Ollos, 7 years ago

Owner: Jonas Borgström removed

Modify Ticket

Change Properties
Set your email in Preferences
as new The ticket will remain with no owner.
The ticket will be disowned.
as The resolution will be set. Next status will be 'closed'.
The owner will be changed from (none) to anonymous. Next status will be 'assigned'.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.