source: cats/ISOcat/trunk/mod-ISOcat-access-data/access/owner_id.acc @ 2686

<accessor debug="false">
        <name>ISOcat.access.data.owner.id</name>
        <descr>Get an owner id.</descr>
        <param mandatory="true">
                <name>owner</name>
                <descr>the owner login (or id)</descr>
                <type canonical="true">string</type>
        </param>
        <idoc>
                <choose>
                        <cond>
                                <instr>
                                        <type>sloot.xpath2eval</type>
                                        <operand>var:owner</operand>
                                        <operator>
                                                <xpath>matches(.,'^[1-9][0-9]*$')</xpath>
                                        </operator>
                                        <target>this:cond</target>
                                </instr>
                        </cond>
                        <then>
                                <instr>
                                        <type>copy</type>
                                        <operand>var:owner</operand>
                                        <target>this:response</target>
                                </instr>
                        </then>
                        <else>
                                <instr>
                                        <type>sloot.xquery</type>
                                        <operator>
                                                <sql>
                                                        SELECT
                                                                id
                                                        FROM
                                                                (
                                                                        SELECT
                                                                                id,
                                                                                login AS name
                                                                        FROM
                                                                                core_user
                                                                UNION
                                                                        SELECT
                                                                                id,
                                                                                name
                                                                        FROM
                                                                                core_thematic_domain_group
                                                                ) AS owner
                                                        WHERE
                                                                name = '{replace(string($owner),"'","\\'")}'
                                                        LIMIT 1
                                                        ;
                                                </sql>
                                        </operator>
                                        <owner>var:owner</owner>
                                        <target>var:sql</target>
                                </instr>
                                <accessor-debug>
                                        <instr>
                                                <type>copy</type>
                                                <operand>var:sql</operand>
                                                <target>ffcpl:/trace/owner_id.sql.xml</target>
                                        </instr>
                                </accessor-debug>
                                <instr>
                                        <type>isocat.sqlQuery</type>
                                        <operand>var:sql</operand>
                                        <target>var:own</target>
                                </instr>
                                <instr>
                                        <type>sloot.xpath2eval</type>
                                        <operand>var:own</operand>
                                        <operator>
                                                <xpath>(/results/row/id)[1]</xpath>
                                        </operator>
                                        <param>
                                                <return>
                                                        <canonical/>
                                                        <string/>
                                                </return>
                                        </param>
                                        <target>this:response</target>
                                </instr>
                        </else>
                </choose>
        </idoc>
        <exception>
                <debug/>
                <trace>ffcpl:/trace/owner_id.exception.xml</trace>
                <throw/>
        </exception>
        <response>
                <debug>ffcpl:/trace/owner_id.response.xml</debug>
                <mime>application/xml</mime>
        </response>
</accessor>