blob: 9062914b401112f89ff3f4159908cd82c7609e54 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
select c.credential_public_id
, i.identity_public_id
, c.data
, c.created_at
, c.revoked_at
, c.deleted_at
from credential c
join identity i using (identity_id)
where (($1 is null) or (c.credential_public_id = $1))
and (($2 is null) or (i.identity_public_id = $2))
and (($3 is null) or (c.type = $3))
and (($3 is null or $4 is null) or (c.data->$3->>'key' = $4))
|
