Custom field value from arbitrary SQL select

RT Users
1

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

2

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

3

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)

4

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

The rt-users Archives

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

–

5

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.