R: [rt-users] Chart grouped by customfield

[Ruslan Zakirov]

It's an experimental and untested patch that may help.

When a query has a "group by" part we really don't want to make it
distinct as I don't see any way it can have not unique entries in the
result set.

Patch is for DBIx::SearchBuilder, to try it use the following steps:
1) untar DBIx::SB's tarball
2) apply patch
3) install it
4) stop/start server
5) test, collect errors if any
6) reinstall clean DBIx::SB
7) stop/start server

On 10/10/07, Joop van de Wege <JoopvandeWege at mococo.nl> wrote:
> Emmanuel Lacour wrote:
> > On Wed, Oct 10, 2007 at 05:46:31PM +0200, Gianluca Cecchi wrote:
> >> Sorry main was an alias for Tickets table....
> >>
> >> If I use the same query on mysql 9without the comma...) I get:
> >>
> >> ERROR 1054 (42S22): Unknown column 'ObjectCustomFieldValues_1.Content' in 'field list'
> >>
> >> And the oracle error 904 is "invalid column name" too
> >>
> >
> > Here is the SQL for the same Graph on a MySQL RT, gived by StatementLog (graph by CustomFields works with MySQL):
> >
> > SELECT DISTINCT COUNT(main.id) AS id, ObjectCustomFieldValues_1.Content AS col1 FROM (Tickets main  LEFT JOIN ObjectCustomFieldValues ObjectCustomFieldValues_1  ON ((ObjectCustomFieldValues_1.CustomField = '1')) AND ( (ObjectCustomFieldValues_1.ObjectType = 'RT::Ticket')) AND ( (ObjectCustomFieldValues_1.Disabled = '0')) AND ( ObjectCustomFieldValues_1.ObjectId = main.id))   WHERE ((main.EffectiveId = main.id)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ((main.Created < '2007-10-31 23:00:00') AND (main.Created > '2007-09-29 22:00:00'))  GROUP BY ObjectCustomFieldValues_1.Content ;
> Weird, this one works without modification on Oracle XE.
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>


-- 
Best regards, Ruslan.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: dbix-sb-oracle.patch
Type: application/octet-stream
Size: 609 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20071011/33beee48/attachment.obj>