egdb3_12_9
.config
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
z3950_source_credentials_lookup(source text, owner integer)
Parameters
Name
Type
Mode
source
text
IN
owner
integer
IN
Definition
SELECT creds.* FROM config.z3950_source_credentials creds JOIN actor.org_unit aou ON (aou.id = creds.owner) JOIN actor.org_unit_type aout ON (aout.id = aou.ou_type) WHERE creds.source = $1 AND creds.owner IN ( SELECT id FROM actor.org_unit_ancestors($2) ) ORDER BY aout.depth DESC LIMIT 1;