Custom field value from arbitrary SQL select

Is there a way to create a “select one value” custom field that gets its
valid values from some SQL query, rather than build the list manually?

Thanks

Mathieu Longtin
1-514-803-8977

Is there a way to create a “select one value” custom field that gets its
valid values from some SQL query, rather than build the list manually?

You could create a web interface that exposes your values, and uses
the external API
provided. Though that seems to dynamically load values, and you seem
to want to do
it once only?

Cambridge Energy Alliance: Save money & the planet

Is there a way to create a “select one value” custom field that gets its
valid values from some SQL query, rather than build the list manually?

In RT 3.8, have a look at lib/RT/CustomFieldValues/External.pm (And
Groups.pm for an example of its use)

Thanks, that looks exactly like what I wanted.

Mathieu Longtin
1-514-803-8977On Wed, Sep 17, 2008 at 10:39 AM, Jesse Vincent jesse@bestpractical.comwrote:

On Wed, Sep 17, 2008 at 10:19:06AM -0400, Mathieu Longtin wrote:

Is there a way to create a “select one value” custom field that gets its
valid values from some SQL query, rather than build the list manually?

In RT 3.8, have a look at lib/RT/CustomFieldValues/External.pm (And
Groups.pm for an example of its use)

Thanks


Mathieu Longtin
1-514-803-8977


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Is there a way to create a “select one value” custom field that gets its
valid values from some SQL query, rather than build the list manually?

In RT 3.8, have a look at lib/RT/CustomFieldValues/External.pm (And
Groups.pm for an example of its use)

Also “perldoc docs/creating_external_custom_fields.pod” to understand
how to enable your new CFV source.