Can I use the Resolutions table as the options for a Custom Field?

[Liam Routt]

I'd like to create a custom field that stores a "possible resolution" for an issue.

I can see how I would create a Custom List field and add a set of options to it, but what I want is for the list to exactly match the items in the Resolutions table, especially if I decide to add a new resolution.

Is there any way to do this?

Thanks for any advice.

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

There is no built in type to do the job. The easiest thing probably will be to write a service that sets the custom field options at every interval.

[Liam Routt]

Thanks for that - thinking laterally, always useful!

[Nic Brough -Adaptavist-]

You could also use the "database values field" plugin, which can generate a select list from a database table. The resolutions live in a database table :-)