Error in sql while using operator "in" and variable

function execute sql syntax

3 Svar

8074 Vyer

Darius Martinkus

Hello odoo community Im just wondering whats wrong in this sql statement while using operator "in" and variable from odoo.

Code Example:

sql="select sum(debit-credit) from account_account_period_sum where period_id in ({0}) and account_id = {1}".format (','.join(map(str,per_ids)), account_id)

When im trying to install module im getting :

ProgrammingError: syntax error at or near ")"

LINE 1: ...om account_account_period_sum where period_id in () and acco...

it seems like variable didnt get past when in ()

Thank you

OdooBot

ok i did a test
per_ids2=[1,2,3]
sql="select sum(debit-credit) from account_account_period_sum where period_id in ({0}) and account_id = {1}".format (per_ids2, account_id)

and i got
ProgrammingError: syntax error at or near "["
LINE 1: ...om account_account_period_sum where period_id in ([1, 2, 3])...

On 21 May 2015 at 14:11, Pawan <pawanmisra.2008@gmail.com> wrote:

A new answer for Error in sql while using operator "in" and variable has been posted. Click here to access the post.
--
Pawan
Sent by Odoo S.A. using Odoo about Forum Post Error in sql while using operator "in" and variable

Darius Martinkus | Zeraxis Limited
E: darius.martinkus@zeraxis.com
M: 07450292546 | T: 020 8253 8015

This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Zeraxis Limited. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing or copying of this email is strictly prohibited. If you have received this email in error please contact the sender.

Pawan

Bästa svar

Hi Darius,

While using 'in' in sql statement you should have a 'list' like (1,2,3.....) to select data from.
like "select sum(debit-credit) from account_account_period_sum where period in (list of period_id values seperated by ,(comma))"

I think the data returning from '[','.join(map(str,per_ids))]' statement is not in correct format, please check the data returned.

Thanks

Pawan

Darius Martinkus

Författare

You were right it works now, thanks!

Njuter du av diskussionen? Läs inte bara, delta också!

Skapa ett konto idag för att ta del av exklusiva funktioner och engagera dig i vår fantastiska community!

Registrera dig

Relaterade inlägg	Svar	Vyer
BUTTON performing QUERY with POSTGRESQL Löst function module field sql	2 mars 15	9740
Hello, I would like to know if there is a way from a server action to execute an existing postgresql function in my database action function server postgresql execute	1 apr. 24	2267
Odoov13 how to use cr.execute in a controller? portal execute sql controller cr	2 apr. 21	6672
How to execute sql query on website controller? Löst many2many query execute sql controller	3 maj 20	14238
[11.0] SQL query problem Löst error query sql syntax odoo11	1 feb. 19	7250

Denna fråga har flaggats

Njuter du av diskussionen? Läs inte bara, delta också!