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

[Addam Schroll]

Eynat,

Thanks for the pointer.  I applied your fix to my environment and it did
indeed correct the issue.  I'll keep an eye on the bug report to watch
for an official fix later.

Addam

Eynat Nir Mishor wrote:
> 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
> 
>