Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Trac: Users
Query options of a custom field
 

Index | Next | Previous | View Flat


ryano at physiosonics

Jun 29, 2009, 5:51 PM


Views: 215
Permalink
Query options of a custom field

Hi,

I would like to list the options of a custom field in a wiki page.
Using the WikiTable macro [1] I've been able to do this for fields of
a ticket that have their own table or exist in a table of the
database, such as component and resolution.

SELECT name, description FROM component ORDER BY name

SELECT name FROM enum WHERE type = 'resolution'

However, I don't understand from looking at the database schema [2] if/
where the options of a custom field or stored, though I think that I
understand that the actual value of a custom field is stored in the
database rather than a key.

[1] http://trac-hacks.org/wiki/WikiTableMacro
[2] http://trac.edgewall.org/wiki/TracDev/DatabaseSchema

Thanks!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users[at]googlegroups.com
To unsubscribe from this group, send email to trac-users+unsubscribe[at]googlegroups.com
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Subject User Time
Query options of a custom field ryano at physiosonics Jun 29, 2009, 5:51 PM
    Re: Query options of a custom field DWinslow at aiminstitute Jun 30, 2009, 5:00 AM
    Re: Query options of a custom field ryano at physiosonics Jul 1, 2009, 11:21 AM
    Re: Query options of a custom field yoheeb at gmail Jul 1, 2009, 12:13 PM
    Re: Query options of a custom field DWinslow at aiminstitute Jul 1, 2009, 12:44 PM

  Index | Next | Previous | View Flat
 
 


Interested in having your list archived? Contact lists@gossamer-threads.com
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.