Odoo Help
Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM
|
e-Commerce
|
Accounting
|
Inventory
|
PoS
|
Project management
|
MRP
|
etc.
Error: not enough arguments for format string
Error: not enough arguments for format string
Code python:
def _getnametahlili(self, user, fromDate, toDate):
sql = " SELECT aaa.name,round(sum(aal.unit_amount)) FROM account_analytic_account as aaa,
account_analytic_line as aal
WHERE aaa.id=aal.account_id and aal.user_id=%d and aal.date BETWEEN \'%s\' AND \'%s\' Group By aaa.name
except
SELECT aaa.name,round(sum(aal.unit_amount)) FROM account_analytic_account as aaa
inner join account_analytic_line as aal on aal.account_id=aaa.id
inner join project_project as pp on pp.analytic_account_id=aal.account_id
WHERE aal.user_id=%d and aal.date BETWEEN \'%s\' AND \'%s\'
Group By aaa.name"
%(user.id, fromDate, toDate)
self.cr.execute(sql)
return self.cr.fetchall()
please Help me…………………………..
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.
RegisterOdoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.
Test it nowQuestion tools
Stats
Asked: 8/3/15, 3:51 AM |
Seen: 1800 times |
Last updated: 8/3/15, 5:49 AM |