Skip to content

SELECT driver FULL DECRYPTED

Used for a leaving customer.

SELECT
    driver.index,
    driver.uuid,
    driver.org_uuid,
    driver.company_uuid,
    driver.state,
    driver.name,
    driver.email,
    driver.phone_number,
    driver.picture,
    driver.language,
    driver.spoken_languages,
    driver.device_token,
    driver.created,
    driver.updated,
    driver.deleted_state,
    driver.name_display,
    driver.device_info,
    COALESCE(pgp_sym_decrypt(
        driver.details, '<decryption-key-hidden-by-miro>'
    )::jsonb, '{}'::jsonb) as details,
    driver.skills,
    driver.driver_penalty
FROM driver
-- LAT / Päijät-Sote
WHERE org_uuid = '6b1de742-525b-4945-8d0a-136d5574583f'
ORDER BY index ASC;