CreatedMonthly Graphs broken with Custom Field parameter?

RT Users
1

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@purdue.edu

2

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@purdue.edu]
Sent: Monday, 16 March 2009 11:04 PM
To: rt-users@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@purdue.edu

3

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: