category::get_id_by_object_title (public)

 category::get_id_by_object_title title

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

Gets the id of a category given an object title (object_type=category). This is highly useful as the category object title will not change if you change the name (label) of the category, so you can access the category even if the label has changed

Parameters:

title (required)

object title of the category to retrieve

Returns:

the category id or empty string if no category was found

Author:

Peter Kreuzinger <peter.kreuzinger@wu-wien.ac.at>

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

Testcases:

category_get_procs

Source code:

    return [db_string get_category_id {
        select object_id
        from acs_objects
        where title = :title
        and object_type = 'category'
    }]

XQL Not present:

Generic

PostgreSQL XQL file:

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

Oracle XQL file:

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