category_synonym::search (public)

 category_synonym::search -search_text search_text [ -locale locale ]

Defined in packages/categories/tcl/category-synonyms-procs.tcl

Gets all matching synonyms for search text in result table.

Switches:

-search_text

(required)

-locale

(optional)

Options:

-search_text

string to be matched against.

-locale

locale of the language. [ad_conn locale] used by default.

Authors:

Bernd Schmeil <bernd@thebernd.de>

Timo Hentschel <timo@timohentschel.de>

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

Testcases:

category_synonyms

Source code:

    if {$locale eq ""} {
    set locale [ad_conn locale]
    }

    db_transaction {
    set query_id [db_exec_plsql new_search ""]
    }

    return $query_id

Generic XQL file:

packages/categories/tcl/category-synonyms-procs.xql

PostgreSQL XQL file:

<fullquery name="category_synonym::search.new_search">
    <querytext>
		select category_synonym__search (
				    :search_text,
				    :locale
				    )
      </querytext>
</fullquery>

packages/categories/tcl/category-synonyms-procs-postgresql.xql

Oracle XQL file:

<fullquery name="category_synonym::search.new_search">
    <querytext>
		begin
		:1 := category_synonym.search (
					           search_text  => :search_text,
					           locale       => :locale
					          );
		end;
      </querytext>
</fullquery>

packages/categories/tcl/category-synonyms-procs-oracle.xql