Live Queries

SELECT "res_partner"."id" as "id", "res_partner"."name" as "name", "res_partner"."display_name" as "display_name", "res_partner"."date" as "date", "res_partner"."title" as "title", "res_partner"."parent_id" as "parent_id", "res_partner"."ref" as "ref", "res_partner"."lang" as "lang", "res_partner"."tz" as "tz", "res_partner"."vat" as "vat", "res_partner"."website" as "website", "res_partner"."comment" as "comment", "res_partner"."active" as "active", "res_partner"."employee" as "employee", "res_partner"."function" as "function", "res_partner"."type" as "type", "res_partner"."street" as "street", "res_partner"."street2" as "street2", "res_partner"."zip" as "zip", "res_partner"."mobile" as "mobile", "res_partner"."is_company" as "is_company", "res_partner"."industry_id" as "industry_id", "res_partner"."company_id" as "company_id", "res_partner"."color" as "color", "res_partner"."partner_share" as "partner_share", "res_partner"."commercial_partner_id" as "commercial_partner_id", "res_partner"."commercial_compan

SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (21924,2,19302,17074,7,27418,3,21536,93550,16767,35,9,13,90111,78873,17072,78874,79591,25927,81070,25559,80427,89774,92162,89319,94685,82983,93077,93078,91691,92202,92616,90826,91166,90879,89253,92438,82751,93163,91525,82996,24714,88961,91532,31623,87792,88473,90547,90720,83700,84031,34613,82300,82323,15004,89480,83212,35118,80633,15066,20948,15003,83407,15069,80129,82545,19950,88429,23579,20926,83629,35432,90146,83667,24560,80798,91593,32574,92584,79748,17390,17769,19105,17411,82870,23276,35526,89821,24086,26788,19219,22691,83917,84294,22007,84147,91441,93844,80757,86899,23926,16035,84250,15459,23295,29942,81051,23338,83190,24873,83716,91675,19631,80911,35453,18257,22879,83679,22997,17361,35477,20052,24301,83563,91070,27164,79836,21240,94104,93456,16697,30408,92332,91474,92404,84183,87811,93149,83128,92334,94302,88699,92381,91767,82330,91768,91511,32463,81789,92794,93018,92074,87820,90222,90451,93060,91756,94426,17352,90701,27522,35369,

SELECT "res_partner"."id" as "id", "res_partner"."name" as "name", "res_partner"."display_name" as "display_name", "res_partner"."date" as "date", "res_partner"."title" as "title", "res_partner"."parent_id" as "parent_id", "res_partner"."ref" as "ref", "res_partner"."lang" as "lang", "res_partner"."tz" as "tz", "res_partner"."vat" as "vat", "res_partner"."website" as "website", "res_partner"."comment" as "comment", "res_partner"."active" as "active", "res_partner"."employee" as "employee", "res_partner"."function" as "function", "res_partner"."type" as "type", "res_partner"."street" as "street", "res_partner"."street2" as "street2", "res_partner"."zip" as "zip", "res_partner"."mobile" as "mobile", "res_partner"."is_company" as "is_company", "res_partner"."industry_id" as "industry_id", "res_partner"."company_id" as "company_id", "res_partner"."color" as "color", "res_partner"."partner_share" as "partner_share", "res_partner"."commercial_partner_id" as "commercial_partner_id", "res_partner"."commercial_compan

SELECT "res_partner"."id" as "id", "res_partner"."name" as "name", "res_partner"."display_name" as "display_name", "res_partner"."date" as "date", "res_partner"."title" as "title", "res_partner"."parent_id" as "parent_id", "res_partner"."ref" as "ref", "res_partner"."lang" as "lang", "res_partner"."tz" as "tz", "res_partner"."vat" as "vat", "res_partner"."website" as "website", "res_partner"."comment" as "comment", "res_partner"."active" as "active", "res_partner"."employee" as "employee", "res_partner"."function" as "function", "res_partner"."type" as "type", "res_partner"."street" as "street", "res_partner"."street2" as "street2", "res_partner"."zip" as "zip", "res_partner"."mobile" as "mobile", "res_partner"."is_company" as "is_company", "res_partner"."industry_id" as "industry_id", "res_partner"."company_id" as "company_id", "res_partner"."color" as "color", "res_partner"."partner_share" as "partner_share", "res_partner"."commercial_partner_id" as "commercial_partner_id", "res_partner"."commercial_compan

SELECT "res_partner"."id" as "id", "res_partner"."name" as "name", "res_partner"."display_name" as "display_name", "res_partner"."date" as "date", "res_partner"."title" as "title", "res_partner"."parent_id" as "parent_id", "res_partner"."ref" as "ref", "res_partner"."lang" as "lang", "res_partner"."tz" as "tz", "res_partner"."vat" as "vat", "res_partner"."website" as "website", "res_partner"."comment" as "comment", "res_partner"."active" as "active", "res_partner"."employee" as "employee", "res_partner"."function" as "function", "res_partner"."type" as "type", "res_partner"."street" as "street", "res_partner"."street2" as "street2", "res_partner"."zip" as "zip", "res_partner"."mobile" as "mobile", "res_partner"."is_company" as "is_company", "res_partner"."industry_id" as "industry_id", "res_partner"."company_id" as "company_id", "res_partner"."color" as "color", "res_partner"."partner_share" as "partner_share", "res_partner"."commercial_partner_id" as "commercial_partner_id", "res_partner"."commercial_compan

SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."id" in (23214,2,19302,17074,7,3,14883,21536,17071,93550,19386,16767,67690,35,21431,9,32170,13,30473,90111,78873,17072,78874,79591,25927,81070,25559,80427,89774,92162,89319,94685,82983,93077,93078,91691,92202,92616,90826,91166,90879,89253,92438,82751,93163,91525,82996,24714,88961,91532,31623,87792,88473,90547,90720,83700,84031,34613,82300,82323,15004,89480,83212,35118,80633,15066,20948,15003,83407,15069,80129,82545,19950,88429,23579,20926,83629,35432,90146,83667,24560,80798,91593,32574,92584,79748,17390,17769,19105,17411,82870,23276,35526,89821,24086,26788,19219,22691,83917,84294,22007,84147,91441,93844,80757,86899,23926,16035,84250,15459,23295,29942,81051,23338,83190,24873,83716,91675,19631,80911,35453,18257,22879,83679,22997,17361,35477,20052,24301,83563,91070,27164,79836,21240,94104,93456,16697,30408,92332,91474,92404,84183,87811,93149,83128,92334,94302,88699,92381,91767,82330,91768,91511,32463,81789,92794,93018,92074,87820,90222,90451,93060,

            SELECT
                U.partner_id as id,
                CASE WHEN max(B.last_poll) IS NULL THEN 'offline'
                    WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval '55 seconds' THEN 'offline'
                    WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval '1800 seconds' THEN 'away'
                    ELSE 'online'
                END as status
            FROM bus_presence B
            RIGHT JOIN res_users U ON B.user_id = U.id
            WHERE U.partner_id IN (19302, 17074, 7, 3, 21536, 93550, 34086, 16767, 35, 9, 13, 90111, 78873, 17072, 78874, 79591, 25927, 81070, 25559, 80427, 89774, 92162, 89319, 94685, 82983, 93077, 93078, 91691, 92202, 92616, 90826, 91166, 90879, 89253, 92438, 82751, 93163, 91525, 82996, 24714, 88961, 91532, 31623, 87792, 88473, 90547, 90720, 83700, 84031, 34613, 82300, 82323, 15004, 89480, 83212, 35118, 80633, 15066, 20948, 15003, 83407, 15069, 80129, 82545, 19950, 88429, 23579, 20926, 83629, 35432, 90146, 83667, 24

SELECT "res_partner"."id" as "id", "res_partner"."name" as "name", "res_partner"."display_name" as "display_name", "res_partner"."date" as "date", "res_partner"."title" as "title", "res_partner"."parent_id" as "parent_id", "res_partner"."ref" as "ref", "res_partner"."lang" as "lang", "res_partner"."tz" as "tz", "res_partner"."vat" as "vat", "res_partner"."website" as "website", "res_partner"."comment" as "comment", "res_partner"."active" as "active", "res_partner"."employee" as "employee", "res_partner"."function" as "function", "res_partner"."type" as "type", "res_partner"."street" as "street", "res_partner"."street2" as "street2", "res_partner"."zip" as "zip", "res_partner"."mobile" as "mobile", "res_partner"."is_company" as "is_company", "res_partner"."industry_id" as "industry_id", "res_partner"."company_id" as "company_id", "res_partner"."color" as "color", "res_partner"."partner_share" as "partner_share", "res_partner"."commercial_partner_id" as "commercial_partner_id", "res_partner"."commercial_compan

SELECT res_users.partner_id FROM res_users
                            JOIN hr_leave ON hr_leave.user_id = res_users.id
                            AND state in ('validate')
                            AND res_users.active = 't'
                            AND date_from <= '2025-01-10T08:06:33'::timestamp AND date_to >= '2025-01-10T08:06:33'::timestamp

            SELECT
                U.partner_id as id,
                CASE WHEN max(B.last_poll) IS NULL THEN 'offline'
                    WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval '55 seconds' THEN 'offline'
                    WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval '1800 seconds' THEN 'away'
                    ELSE 'online'
                END as status
            FROM bus_presence B
            RIGHT JOIN res_users U ON B.user_id = U.id
            WHERE U.partner_id IN (19302, 17074, 7, 3, 21536, 93550, 34086, 16767, 35, 9, 13, 90111, 78873, 17072, 78874, 79591, 25927, 81070, 25559, 80427, 89774, 92162, 89319, 94685, 82983, 93077, 93078, 91691, 92202, 92616, 90826, 91166, 90879, 89253, 92438, 82751, 93163, 91525, 82996, 24714, 88961, 91532, 31623, 87792, 88473, 90547, 90720, 83700, 84031, 34613, 82300, 82323, 15004, 89480, 83212, 35118, 80633, 15066, 20948, 15003, 83407, 15069, 80129, 82545, 19950, 88429, 23579, 20926, 83629, 35432, 90146, 83667, 24

BEGIN ISOLATION LEVEL REPEATABLE READ