Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
On v7, group by date (anywhere), groups results by month and not the day. I understand that there is a workaround to add date to char column and group by that field.
The thing is that i defensively don't want to go through 9-10 modules i have inline and fix them.
is there any other solution?
This is a confirmed bug and you will have execute a sql command manually.
cr.execute('SELECT call_date, COUNT(*) AS num_calls FROM bitco_voice_daily_summary GROUP BY call_date;')
results = cr.fetchall()
for result in results:
p 'There were ' + str(result[1]) + ' calls made on '+ str(result[0])
Be careful of sql injection if you're building a query with parameters.
Create an account today to enjoy exclusive features and engage with our awesome community!
Prijavi| Related Posts | Odgovori | Prikazi | Aktivnost | |
|---|---|---|---|---|
|
3
jun. 25
|
1246 | ||
|
1
jan. 25
|
18041 | ||
|
0
maj 24
|
1815 | ||
|
1
jul. 21
|
2762 | ||
|
1
jan. 20
|
4013 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
The problem is your date will be of string type. Please check its type. You have to convert it into datetime and then check. You will get the result