workflow::role::get_search_query (public)

 workflow::role::get_search_query -role_id role_id

Defined in packages/workflow/tcl/role-procs.tcl

Get the search query for this role.

Switches:

-role_id

(required)

the ID of the role.

Author:

Lars Pind <lars@collaboraid.biz>

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Source code:

    set contract_name [workflow::service_contract::role_assignee_subquery]

    set impl_names [workflow::role::get_callbacks  -role_id $role_id  -contract_name $contract_name]
    return         "select distinct acs_object__name(p.party_id) || ' (' || p.email || ')' as label, p.party_id
        from   cc_users p
        where  upper(coalesce(acs_object__name(p.party_id) || ' ', '')  || p.email) like upper('%'||:value||'%')
        order  by label"

XQL Not present:

PostgreSQL, Oracle

Generic XQL file:

packages/workflow/tcl/role-procs.xql