[rt-users] CreatedMonthly Graphs broken with Custom Field parameter?

[Eynat Nir Mishor]

I,'m sorry I'm replying just now - I had a very large mailing list
backlog...

I filed such a bug with BPS a few weeks ago.
It includes a fix for the problem (add hard-coded "main." prefix to some
fields in lib/RT/Report/Tickets.pm)

http://rt3.fsck.com//Ticket/Display.html?id=13258 CreatedDaily (et al)
charts not working when query by CF or by requestor 
(login with guest/guest)

Eynat

-----Original Message-----
From: Addam Schroll [mailto:addam at purdue.edu] 
Sent: Monday, 16 March 2009 11:04 PM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] CreatedMonthly Graphs broken with Custom Field
parameter?

I have a RT 3.8.2 instance setup and I like to use the CreatedMonthly
bar graph to see ticket histories.  The graph, however, appears to break
if you try to use it with a search that includes a custom field parameter.

For example, if I search for all tickets in our firewall queue with the
Request Type custom Field set to any valid value, I get a blank graph
with no totals at the bottom.  I also see the following warnings in the
RT logs.

[Mon Mar 16 20:56:28 2009] [warning]: DBD::mysql::st execute failed:
Column 'Created' in field list is ambiguous at
/usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505.
(/usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)

[Mon Mar 16 20:56:28 2009] [warning]: RT::Handle=HASH(0x985ec6c)
couldn't execute the query 'SELECT DISTINCT COUNT(main.id) AS id,
SUBSTR(Created,1,7) AS createdmonthly FROM Tickets main JOIN
ObjectCustomFieldValues ObjectCustomFieldValues_1  ON (
ObjectCustomFieldValues_1.CustomField = '7' ) AND (
ObjectCustomFieldValues_1.ObjectType = 'RT::Ticket' ) AND (
ObjectCustomFieldValues_1.Disabled = '0' ) AND (
ObjectCustomFieldValues_1.ObjectId = main.id )  WHERE (main.Status !=
'deleted') AND (main.Queue = '4' AND  (  (  (
ObjectCustomFieldValues_1.Content LIKE '%Host Add Request%' OR  (  (
ObjectCustomFieldValues_1.Content = '' OR
ObjectCustomFieldValues_1.Content IS NULL )  AND
ObjectCustomFieldValues_1.LargeContent LIKE '%Host Add Request%' )  )  )
 ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id)  GROUP
BY SUBSTR(Created,1,7) ' at
/usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518

Has anyone else run into this issue?  Anyone found a workaround or solution?

Thanks,
Addam

--
Addam Schroll
IT Security and Privacy Analyst
IT Networks & Security, Purdue University
addam at purdue.edu