Skip to content

SELECT & UPDATE agreement.valid_until

Fleet Helsinki org: continue taxi company agreement validity (https://app.clickup.com/t/2496230/TMS-6269) Stable tms_fleet update company agreements (https://app.clickup.com/t/86bw8fbe6)

SELECT index, org_uuid, company_uuid, valid_from, valid_until, deleted_state FROM agreement WHERE org_uuid = '1dfccc44-09c1-4e69-8554-3000cd2743f3' AND valid_until = '2025-03-01' AND deleted_state = 0;

UPDATE agreement SET valid_until = '2025-03-31' WHERE org_uuid = '1dfccc44-09c1-4e69-8554-3000cd2743f3' AND valid_until = '2025-03-01' AND deleted_state = 0;