[rt-users] Custom Fields and Tickets in RT DB Schema

[Christian Gilmore]

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 <toml at bitstatement.net>
To:
Christian Gilmore/Austin/IBM at IBMUS
Cc:
rt-users at lists.bestpractical.com
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/
-- ============================


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090601/e0171eea/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 7911 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090601/e0171eea/attachment.bin>