blob: 1736500bbb000aa913b969b126528a80734c5940 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
select c.credential_public_id
, i.identity_public_id
, c.data::text
, c.created_at
, c.revoked_at
, c.deleted_at
from secd.credential c
join secd.identity i using (identity_id)
where (($1::uuid is null) or (c.credential_public_id = $1))
and (($2::uuid is null) or (i.identity_public_id = $2))
and (($3::text is null) or (c.type = $3))
and (($3::text is null or $4::text is null) or (c.partial_key = $4))
|
