blob: 135ff9aa3fc3e2119d5f553f8a6c14ac035183bc (
plain)
1
2
3
4
5
6
7
8
9
10
11
|
select
identity_public_id
, data
, i.created_at
, i.deleted_at
from secd.identity i
join secd.identity_email_validation iev using (identity_id)
join secd.email_validation ev using (email_validation_id)
join secd.email e using (email_id)
where (($1 is null) or (i.identity_public_id = $1))
and (($2 is null) or (e.address = $2));
|
