[rt-users] Chart grouped by customfield

[Jesse Vincent]

On Oct 10, 2007, at 9:38 AM, Emmanuel Lacour wrote:

> On Wed, Oct 10, 2007 at 09:09:58AM -0400, Jesse Vincent wrote:
>>
>
> Hi, dear RT primary Author ;)
>
>> what shows up in your error logs?
>
> That's the good question ... sorry I forgot to look here :(
>

I suspect that it has to do with "this was tested on mysql and pg"

Any oracle folks see what we're doing wrong with that SQL?

> There is DBD prepare errors:
>
> RT: RT::Handle=HASH(0x8134df1c) couldn't prepare the query 'SELECT  
> COUNT(main.id) AS id, ObjectCustomFieldValues_1.Content AS col1  
> FROM ( SELECT DISTINCT main.id 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.Status != 'deleted') AND (main.Status != 'resolved') AND  
> (main.Type = 'ticket') AND (main.EffectiveId = main.id)  )  
> distinctquery, Tickets main WHERE (main.id = distinctquery.id)   
> GROUP BY ObjectCustomFieldValues_1.Content
>
> 'ORA-00904: "OBJECTCUSTOMFIELDVALUES_1"."CONTENT": invalid identifier
> (DBD ERROR: error possibly near <*> indicator at char 596 in  
> 'SELECT COUNT(main.id) AS id, ObjectCustomFieldValues_1.Content AS  
> col1 FROM ( SELECT DISTINCT main.id FROM Tickets main LEFT JOIN  
> ObjectCustomFieldValues ObjectCustomFieldValues_1
>
>
> Here is more information on my setup:
>
> DBIx-SearchBuilder-1.49
> DBD-Oracle-1.19
> Oracle Xe 10.2.0.1
> Perl 5.8.8
>
> Thanks for your help :)
>
> _______________________________________________
> 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
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20071010/559ba461/attachment.sig>