<br><font size=2 face="sans-serif">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?<br>
</font>
<br><font size=2 face="sans-serif">Thanks,</font>
<br><font size=2 face="sans-serif">Christian Gilmore</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">From:</font>
<td><font size=1 face="sans-serif">Ruslan Zakirov <ruslan.zakirov@gmail.com></font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">To:</font>
<td><font size=1 face="sans-serif">Christian Gilmore/Austin/IBM@IBMUS</font>
<tr>
<td valign=top><font size=1 color=#5f5f5f face="sans-serif">Cc:</font>
<td><font size=1 face="sans-serif">rt-users@lists.bestpractical.com</font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">Date:</font>
<td><font size=1 face="sans-serif">06/01/2009 05:29 PM</font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">Subject:</font>
<td><font size=1 face="sans-serif">Re: [rt-users] Custom Fields and Tickets
in RT DB Schema</font></table>
<br>
<hr noshade>
<br>
<br>
<br><tt><font size=2>There is Chart fnctionality in RT that allows you
to do this.<br>
<br>
For example use guest/guest credentials and the following link:<br>
</font></tt><a href="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"><tt><font !
 size=2>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</font></tt></a><tt><font!
  size=2><br>
<br>
If you enable the query logging then you can steal SQL and figure out relations.<br>
<br>
On Tue, Jun 2, 2009 at 2:00 AM, Christian Gilmore <cag@us.ibm.com>
wrote:<br>
><br>
> Thanks, Tom, for the reply.  Based on your recommendation, I
searched for<br>
> the REST documentation and found </font></tt><a href=http://wiki.bestpractical.com/view/REST><tt><font size=2>http://wiki.bestpractical.com/view/REST</font></tt></a><tt><font size=2>.
I<br>
> probably should have mentioned what I want to do. I'd like to be able
to get<br>
> a report on the breakdown of tickets by a particular custom field's
values.<br>
> I don't see an obvious way to do that through the REST interface.
I don't<br>
> see a way through the standard web search interface to do it wholesale,
just<br>
> one-by-one. Any ideas on how best to get these metrics?<br>
><br>
> Thanks,<br>
> Christian<br>
><br>
><br>
> From: Tom Lahti <toml@bitstatement.net><br>
> To: Christian Gilmore/Austin/IBM@IBMUS<br>
> Cc: rt-users@lists.bestpractical.com<br>
> Date: 06/01/2009 04:40 PM<br>
> Subject: Re: [rt-users] Custom Fields and Tickets in RT DB Schema<br>
> ________________________________<br>
><br>
><br>
> Christian Gilmore wrote:<br>
>> I've been trying to understand how custom fields relate to tickets
in the<br>
>> RT3 schema, and I can't make that connection. I see transactions
related<br>
>> to the ticket and the setting of custom fields, but it doesn't
seem to<br>
>> have the custom field value in the transaction. I need some help
making<br>
>> this db-level connection.<br>
><br>
> My advice: don't.  Use the REST interface.  It's guaranteed*
not to change,<br>
> even in RT 4.0 where the schema will most assuredly be completely
different.<br>
><br>
> * Based on previous emails on the list from Jesse.<br>
><br>
> --<br>
> -- ============================<br>
>   Tom Lahti<br>
>   BIT Statement LLC<br>
><br>
>   (425)251-0833 x 117<br>
>   </font></tt><a href=http://www.bitstatement.net/><tt><font size=2>http://www.bitstatement.net/</font></tt></a><tt><font size=2><br>
> -- ============================<br>
><br>
><br>
><br>
> _______________________________________________<br>
> </font></tt><a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users"><tt><font size=2>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</font></tt></a><tt><font size=2><br>
><br>
> Community help: </font></tt><a href=http://wiki.bestpractical.com/><tt><font size=2>http://wiki.bestpractical.com</font></tt></a><tt><font size=2><br>
> Commercial support: sales@bestpractical.com<br>
><br>
><br>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>
> Buy a copy at </font></tt><a href=http://rtbook.bestpractical.com/><tt><font size=2>http://rtbook.bestpractical.com</font></tt></a><tt><font size=2><br>
><br>
<br>
<br>
<br>
-- <br>
Best regards, Ruslan.<br>
</font></tt>
<br>
<br>