How to fix error this BI SQL Editor ?

Question

Query :
SELECT a.analytic_account_id AS x_analytic_account_id, SUM(a.debit - a.credit) AS x_expense FROM account_move_line AS a LEFT JOIN account_account AS b ON a.account_id=b.id LEFT JOIN account_account_type AS c ON b.user_type_id=c.id WHERE c.name = 'Expenses' AND c.parent_state ='Posted' GROUP BY a.analytic_account_id

Example Error
The SQL query is not valid:
column c.parent_state does not exist
LINE 11:   c.name = 'Expenses' AND c.parent_state ='Posted'
^
HINT: Perhaps you meant to refere

Karthik Jain · Accepted Answer

Hi Hendy,
I have just changed the referencing name of models for easy understanding
select aml.analytic_account_id as x_analytic_account_id, SUM(aml.debit - aml.credit) as x_expense
from account_move_line as aml
left join account_account as aa on aml.account_id = aa.id
left join account_account_type as aat on aa.user_type_id = aat.id
where aat.name = 'Expenses' and aml.parent_state ='posted'
group by
aml.analytic_account_id
parent_state field is in account_move_line  and  not  in  account_accoun

관련 게시물	답글	화면
How to make a report for expenses more than 80? 해결 완료 expenses	1 2월 25	1958
Título: ¿Existen módulos OCA para agrupar diferentes tipos de gastos en Odoo? expenses	0 10월 24	2112
How to delete " approved or paid _ expense in Odoo expense app" expenses	1 2월 23	3140
Usage Of SQl Queries In odoo sql	1 11월 22	7125
sql constraints aren't being detected in my model sql	1 10월 21	4023

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!