To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69678 Issue #|69678 Summary|Query designer not allowing groub by on concat field Component|Database access Version|OOo 2.0.4 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|atjensen
------- Additional comments from [EMAIL PROTECTED] Tue Sep 19 09:20:56 -0700 2006 ------- This is for 2.0.4 RC2 In the attached database please find Query7 SELECT CONCAT( CONCAT( CAST ( MONTH( "DATE_IN" ) AS "VARCHAR" ), ' / ' ), YEAR( "DATE_IN" ) ) AS "Orders For" , COUNT( "ID" ) AS "Total work orders", AVG( DATEDIFF( 'dd', "DATE_IN", "DATE_OUT" ) ) AS "Average days to fix"FROM "ORDERS" GROUP BY CONCAT( CONCAT( CAST ( MONTH( "DATE_IN" ) AS "VARCHAR" ), ' / ' ), YEAR( "DATE_IN" ) ) This should be allowed in the designer - it is not. In fact it will not run without escape processing being turned off. The part that is not accepted by either is the GROUP BY clause. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]