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:[email protected]] Sent: Monday, 16 March 2009 11:04 PM To: [email protected] 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 [email protected] _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
