Re: [rt-users] Is there a statistic that lists tickets per requestor?
Am 19.08.2008 um 14:11 schrieb Kevin Falcone: > > Can you take the query (from Advanced) that you're using and then > send instructions on what you did to get this error and mail it to > [EMAIL PROTECTED] along with all your version information > and stack trace from this email so we can have a look? > > -kevin OK, it's #12125 Rainer ___ 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
Re: [rt-users] Is there a statistic that lists tickets per requestor?
On Aug 19, 2008, at 5:08 AM, Rainer Duffner wrote:
> 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:
Can you take the query (from Advanced) that you're using and then
send instructions on what you did to get this error and mail it to
[EMAIL PROTECTED] along with all your version information
and stack trace from this email so we can have a look?
-kevin
>
>
>
> [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', '\'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', '\'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,
> 'PrimaryGr
Re: [rt-users] Is there a statistic that lists tickets per requestor?
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', '\' _...', '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', '\' _...', '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', '\' _...', ...) 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
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xbc32400)',
'ChartStyle', 'bar', 'Order', 'ASC|ASC|ASC|ASC', 'Query', 'Statu
Re: [rt-users] Is there a statistic that lists tickets per requestor?
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. You can then save this chart to replay it when wanted. For more complex analysis you can also use the spreadsheet export of search results and any spreadsheet software (gnumeric, oocalc, excel) to get the wanted stats. ___ 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
Re: [rt-users] Is there a statistic that lists tickets per requestor?
If you find something like this I would also be interested in it. It would make things very interesting for my reporting and finding serial supportees Greg Evans Hood Canal Communications (360) 898-2481 ext.212 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rainer Duffner Sent: Saturday, August 16, 2008 2:26 PM To: RT Users Subject: [rt-users] Is there a statistic that lists tickets per requestor? Hi, I'd like to have statistics that list - per queue - which requestors requested how many tickets. Is that possible? Rainer ___ 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 ___ 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
