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

[Ruslan Zakirov]

There is Chart fnctionality in RT that allows you to do this.

For example use guest/guest credentials and the following link:
http://rt3.fsck.com/Search/Chart.html?Order=ASC&Query=Queue+%3D+%27rt3%27+AND+%28Status+%3D+%27new%27+OR+Status+%3D+%27open%27+OR+Status+%3D+%27stalled%27%29&Rows=50&OrderBy=id&Format=%0D%0A+++%27%3CB%3E%3CA+HREF%3D%22__WebPath__%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2FB%3E%2FTITLE%3A%23%27%2C%0D%0A+++%27%3CB%3E%3CA+HREF%3D%22__WebPath__%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2FB%3E%2FTITLE%3ASubject%27%2C%0D%0A+++Status%2C%0D%0A+++QueueName%2C+%0D%0A+++OwnerName%2C+%0D%0A+++Priority%2C+%0D%0A+++%27__NEWLINE__%27%2C%0D%0A+++%27%27%2C+%0D%0A+++%27%3Csmall%3E__Requestors__%3C%2Fsmall%3E%27%2C%0D%0A+++%27%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A+++%27%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E%27%2C%0D%0A+++%27%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A+++%27%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E%27&ChartStyle=bar&PrimaryGroupBy=CF.%7B49%7D

If you enable the query logging then you can steal SQL and figure out relations.

On Tue, Jun 2, 2009 at 2:00 AM, Christian Gilmore <cag at us.ibm.com> wrote:
>
> 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/
> -- ============================
>
>
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>



-- 
Best regards, Ruslan.