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;