Is there a way to link List Types that already exists in the underlying database (such as Category, Status, Priority, etc) to the Pick List for a custom field?

For example:  I'd like Category to be a field within Enhancement and Defect, not just Task.  I could create 'category' pick list then a custom field called category on both Enhancement and Defect and link them to the 'category' pick list, however, this seems redundent and adds additional maintenance when there is already a Category List Type (and table) available.

Hello,

You can reference the built-in fields in custom picklists. For instance, you can create a custom picklist that uses the Category values by basing the picklist off of the stored procedure called "dbo.spS_CategoryTypes". For the column name you'd just have to use "Name", and after linking the picklist to a custom field you'll see those Category values populate in your picklist.

I'm glad you used the Category field as your example, as there's one thing to note about the field in particular. There are public and private Category values for that field. The values you configure in the 'Tools>Manage>Lists Types' are public, while if a user adds a category using the Quick Add option in the Task toolbar, those are considered private values. If you call the Category stored procedure directly, as in the example I gave, you'll pull all the values- public and private. The only way to avoid that would be to write your own stored procedure that references the Category stored procedure, which will filter only the public category fields.

Let me know if you have any further questions.

---

Thank you,

Tom Harder
Axosoft Support
support@axosoft.com
1.800.653.0024 option 3
--'Fear the Bug' Podcast--

How do you reference the built-in fields? When I select 'Tools > Manage > Pick Lists > Add New Pick List', the add dialog only allows me to add 'Standard' ones. Stored procedure is grayed out.

---

-- Sandi L.
Kingston, Jamaica

Oh. No worries. I found the option to turn on Stored Procedures in Tools > System Options.

---

-- Sandi L.
Kingston, Jamaica