콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다
2 답글
1356 화면

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.

아바타
취소
베스트 답변

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.

아바타
취소
베스트 답변

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

아바타
취소
작성자

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

관련 게시물 답글 화면 활동
0
2월 25
1564
2
1월 25
8165
2
1월 24
10138
0
9월 23
6220
7
1월 24
48983