Thanks! After tweaking your example, I think I have what I need for this particular exercise. I couldn't find much documentation on the built-in Chart feature. Is there any available?
Thanks, Christian Gilmore From: Ruslan Zakirov <ruslan.zaki...@gmail.com> To: Christian Gilmore/Austin/i...@ibmus Cc: rt-users@lists.bestpractical.com Date: 06/01/2009 05:29 PM Subject: Re: [rt-users] Custom Fields and Tickets in RT DB Schema 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 <c...@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 <t...@bitstatement.net> > To: Christian Gilmore/Austin/i...@ibmus > Cc: rt-users@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: sa...@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.
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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
