quarter seems to be a reserved word for OQL, just like year. It needs to be surrounded by quotes in the query.
The query would work if changed from
“SELECT afe8e15a8.Quarter AS Quarter0, afe8e15a8."Year" AS Year0,
to something like:
“SELECT afe8e15a8."Quarter" AS Quarter0, afe8e15a8."Year" AS Year0,
If you add |quarter to the following source from the ExcelExporter it will work:
\javasource\xlsreport\report\DataOQL.java line 36:
static final Pattern PATTERN_RESERVED_OQL = Pattern.compile("\\b(quarter|select|distinct|as|avg|count|max|min|sum|from|inner|left|right|full|outer|join|on|where|and|or|group|by|limit|offset|order|asc|desc|having|cast|coalesce|like|in|exists|not|case|when|then|else|end|boolean|datetime|float|integer|long|string|null|year|month|day|hour|minute)\\b", Pattern.CASE_INSENSITIVE);
Better: Contact Mendix support and report it as a bug, so it can be fixed in the ExcelExporter module.
Maybe the following dateparts might need to be added as reserved pattern too in that case?
QUARTER
DAYOFYEAR
WEEK
WEEKDAY
SECOND
Offcourse: a quick workaround could be renaming the attribute “Quarter” to something else in your domain model.
Regards,
Edwin van Elk
The main hint to what is going wrong is in the following section of your log:
“SELECT afe8e15a8.Quarter AS Quarter0, afe8e15a8."Year" AS Year0, afe8e15a8.Excels_at_the_quality_of_work AS Excels_at_the_quality_of_work0, ace330095.FullName AS FullName0 FROM "QuarterlyFeedback"."EmployeeQuarterlyFeedback" AS afe8e15a8 INNER JOIN afe8e15a8/"QuarterlyFeedback"."EmployeeQuarterlyFeedback_EmployeeMaster"/"QuarterlyFeedback"."EmployeeMaster" AS ace330095 INNER JOIN "afe8e15a8"/"QuarterlyFeedback"."EmployeeQuarterlyFeedback_EmployeeQuarterlyFeedbackDoc"/"QuarterlyFeedback"."EmployeeQuarterlyFeedbackDoc" AS refobject ON refobject/ID = 38280596832649717 ;
Error on line 1 character 17: no viable alternative at input 'Quarter'”
Specifically the reference ‘no viable alternative at input ‘Quarter’: not sure how you are using your Excel Exporter, but somewhere you seem to reference an attribute called ‘Quarter’ which does not exist for that entity.
Jaya,
Problem has been solved in Excel Exporter module v 7.0.2:
Release Notes
Changes
* Fixed an issue where exporting attributes with reserved names (such as quartier, second or week) would result in an error. Attributes names are now always escaped in the generated OQL, so there is no longer a need to keep a list of reserved words
Regards,
Edwin