content::keyword::item_get_assigned (public)

 content::keyword::item_get_assigned -item_id item_id \
    [ -parent_id parent_id ]

Defined in packages/acs-content-repository/tcl/content-keyword-procs.tcl

Returns a list of all keywords assigned to the given cr_item. If parent_id is supplied, only keywords that are children of parent_id are listed.

Switches:
-item_id
(required)
-parent_id
(optional)

Partial Call Graph (max 5 caller/called nodes):
%3 bug_tracker::bug::notification_info::get_notification_info bug_tracker::bug::notification_info::get_notification_info (private) content::keyword::item_get_assigned content::keyword::item_get_assigned bug_tracker::bug::notification_info::get_notification_info->content::keyword::item_get_assigned packages/bug-tracker/www/bug.tcl packages/bug-tracker/ www/bug.tcl packages/bug-tracker/www/bug.tcl->content::keyword::item_get_assigned db_list db_list (public) content::keyword::item_get_assigned->db_list

Testcases:
No testcase defined.
Source code:
    if {[info exists parent_id]} {
        set keyword_list [db_list get_child_keywords {
            select km.keyword_id
            from cr_item_keyword_map km,
                 cr_keywords kw
            where km.item_id = :item_id
            and   kw.parent_id = :parent_id
            and   kw.keyword_id = km.keyword_id
    }]
    } else {
        set keyword_list [db_list get_keywords {
            select keyword_id from cr_item_keyword_map
            where item_id = :item_id
    }]
    }

    return $keyword_list
XQL Not present:
Generic, PostgreSQL, Oracle
[ hide source ] | [ make this the default ]
Show another procedure: