In the result part I define:
- Code: Select all
q.result
...
.add(q.getColumn(edis_alias,'daily_sales').divide(q.getColumn(edis_alias,'daily_units').nullif(0)),'avg_unit_pr') //NOTE need check for div by 0)
In the group by I define:
- Code: Select all
q.groupBy
.add(...)
...
.add(q.getColumn(edis_alias,'avg_unit_pr'))
Before I added these lines to the result and group by part the query runs fine.
The error message is
Cannot find column 'avg_unit_pr' in data source ....
Where the datasource is the table: edis_alias.
I am thinking that the alias 'avg_unit_pr' has become lost or assigned to some unknown datasource or my code is incorrect....the equivalent sql runs fine.
Any ideas are welcomed before I submit as a Jira issue.
Tom