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