Emmanuel Lacour schrieb:
On Sat, Aug 16, 2008 at 11:26:04PM +0200, Rainer Duffner wrote:
Hi,
I'd like to have statistics that list - per queue - which requestors
requested how many tickets.
Is that possible?
Yes, make a search for all tickets in the wanted queue on the web UI,
then at the bottom of the result (list of tickets), you will see Chart
'bar' by 'status'. Changes status to requestor and click on Go.
You will get a chart on the count of tickets per requestor for this
queue.
OK, this works for e.g. Status.
But when I select Requestor from the drop-down, I get a quasi-empty
chart and this in the log:
[Tue Aug 19 08:50:12 2008] [warning]: DBD::Pg::st execute failed:
ERROR: column users_5.name must appear in the GROUP BY clause or be
used in an aggregate function at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line
505. (/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)
[Tue Aug 19 08:50:12 2008] [warning]: RT::Handle=HASH(0xb75825c)
couldn't execute the query 'SELECT DISTINCT COUNT(main.id) AS id,
Users_5.Name AS col1 FROM Tickets main JOIN Groups Groups_1 ON (
Groups_1.Domain = 'RT::Ticket-Role' ) AND ( Groups_1.Type = 'Requestor'
) AND ( Groups_1.Instance = main.id ) LEFT JOIN CachedGroupMembers
CachedGroupMembers_2 ON ( CachedGroupMembers_2.GroupId !=
CachedGroupMembers_2.MemberId ) AND ( CachedGroupMembers_2.GroupId =
Groups_1.id ) LEFT JOIN CachedGroupMembers CachedGroupMembers_4 ON (
CachedGroupMembers_4.GroupId != CachedGroupMembers_4.MemberId ) AND (
CachedGroupMembers_4.GroupId = Groups_1.id ) LEFT JOIN Users Users_3 ON
( Users_3.id = CachedGroupMembers_2.MemberId ) LEFT JOIN Users Users_5
ON ( Users_5.id = CachedGroupMembers_4.MemberId ) WHERE (main.Status !=
'deleted') AND (main.Status != 'rejected' AND main.Created '2008-07-31
22:00:00') AND (main.Type = 'ticket') AND (main.EffectiveId = main.id)
GROUP BY Users_3.Name ' at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xb75825c)',
'SELECT DISTINCT COUNT(main.id) AS id, Users_5.Name AS col1 FR...')
called at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm
line 238
DBIx::SearchBuilder::_DoSearch('RT::Report::Tickets=HASH(0xc54732c)')
called at /usr/local/rt38/bin/../lib/RT/Report/Tickets.pm line 164
RT::Report::Tickets::_DoSearch('RT::Report::Tickets=HASH(0xc54732c)')
called at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm
line 498
DBIx::SearchBuilder::Next('RT::Report::Tickets=HASH(0xc54732c)')
called at /usr/local/rt38/bin/../lib/RT/Report/Tickets.pm line 228
RT::Report::Tickets::Next('RT::Report::Tickets=HASH(0xc54732c)')
called at /usr/local/rt38/share/html/Search/Elements/Chart line 71
HTML::Mason::Commands::__ANON__('ChartStyle', 'bar', 'Order',
'ASC|ASC|ASC|ASC', 'Query', 'Status != \'rejected\' AND Created
\'2008-08-01\'', 'Rows', 50, 'SecondaryGroupBy', ...) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xc5474e8)',
'ChartStyle', 'bar', 'Order', 'ASC|ASC|ASC|ASC', 'Query', 'Status !=
\'rejected\' AND Created \'2008-08-01\'', 'Rows', 50, ...) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1278
eval {...} called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp('undef', 'undef', 'ChartStyle', 'bar',
'Order', 'ASC|ASC|ASC|ASC', 'Query', 'Status != \'rejected\' AND Created
\'2008-08-01\'', 'Rows', ...) called at
/usr/local/rt38/share/html/Search/Chart.html line 70
HTML::Mason::Commands::__ANON__('Rows', 50, 'PrimaryGroupBy',
'Requestor', 'Format', '\' ba
href=__WebPath__/Ticket/Display.html?id=__id___...', 'Order',
'ASC|ASC|ASC|ASC', 'ChartStyle', ...) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xc2bc8d4)',
'Rows', 50, 'PrimaryGroupBy', 'Requestor', 'Format', '\' ba
href=__WebPath__/Ticket/Display.html?id=__id___...', 'Order',
'ASC|ASC|ASC|ASC', ...) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1278
eval {...} called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp('undef', 'undef', 'undef', 'Rows', 50,
'PrimaryGroupBy', 'Requestor', 'Format', '\' ba
href=__WebPath__/Ticket/Display.html?id=__id___...', ...) called at
/usr/local/rt38/share/html/autohandler line 308
HTML::Mason::Commands::__ANON__('ChartStyle', 'bar', 'Order',
'ASC|ASC|ASC|ASC', 'Query', 'Status != \'rejected\' AND Created
\'2008-08-01\'', 'Rows', 50, 'PrimaryGroupBy', ...) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
