[rt-users] Chart grouped by customfield

[Emmanuel Lacour]

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 :(

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 :)