İçereği Atla
Menü
Bu soru işaretlendi
2 Cevaplar
1321 Görünümler

Hi, 

As we do this in odoo's python:

cleared_bal = self.env['funds.flow.tree'].search(['|','|',('cust.id),('date_clearance','

same case if i want to find one id in three different columns of a same table and consider every row which has the target id in any of those three column. How I will write a query?

I have checked the internet but they were not helping, may be they were written in django or plain python. Much appreciate the help.

Avatar
Vazgeç
En İyi Yanıt

In sql:

SELECT * FROM your_model_name

WHERE first_column = target_id

OR second_column = target_id

OR third_column = target_id;


In the database, models (tables) have underscores instead of periods.

Avatar
Vazgeç
En İyi Yanıt

Hi,

If you're working with Odoo's ORM in Python and you want to search for records where a specific ID is present in any of three different columns, you can achieve this using domain filtering in the search method. Here's how you can write the query:


records = self.env['your.model.name'].search([

    '|', '|',

    ('first_column', '=', target_id),

    ('second_column', '=', target_id),

    ('third_column', '=', target_id)

])


Hope it helps

Avatar
Vazgeç
Üretici

Hi @cybrosys
I want to write a postgree sql Querry for that.

İlgili Gönderiler Cevaplar Görünümler Aktivite
0
Şub 25
1483
2
Oca 25
8061
2
Oca 24
10138
0
Eyl 23
6206
7
Oca 24
48909