Thanks, Tom, for the reply. Based on your recommendation, I searched for the REST documentation and found http://wiki.bestpractical.com/view/REST. I probably should have mentioned what I want to do. I'd like to be able to get a report on the breakdown of tickets by a particular custom field's values. I don't see an obvious way to do that through the REST interface. I don't see a way through the standard web search interface to do it wholesale, just one-by-one. Any ideas on how best to get these metrics?
Thanks, Christian From: Tom Lahti <[email protected]> To: Christian Gilmore/Austin/i...@ibmus Cc: [email protected] Date: 06/01/2009 04:40 PM Subject: Re: [rt-users] Custom Fields and Tickets in RT DB Schema Christian Gilmore wrote: > I've been trying to understand how custom fields relate to tickets in the > RT3 schema, and I can't make that connection. I see transactions related > to the ticket and the setting of custom fields, but it doesn't seem to > have the custom field value in the transaction. I need some help making > this db-level connection. My advice: don't. Use the REST interface. It's guaranteed* not to change, even in RT 4.0 where the schema will most assuredly be completely different. * Based on previous emails on the list from Jesse. -- -- ============================ Tom Lahti BIT Statement LLC (425)251-0833 x 117 http://www.bitstatement.net/ -- ============================
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
