category::count_children (public)

 category::count_children -category_id category_id

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

counts all direct sub categories

Switches:
-category_id (required)

Partial Call Graph (max 5 caller/called nodes):
%3 test_category_tree_procs category_tree_procs (test categories) category::count_children category::count_children test_category_tree_procs->category::count_children db_string db_string (public) category::count_children->db_string

Testcases:
category_tree_procs
Source code:
    return [db_string count_children {
        select count(*)
        from categories
        where parent_id=:category_id
    }]
XQL Not present:
Generic
PostgreSQL XQL file:
packages/categories/tcl/categories-procs-postgresql.xql

Oracle XQL file:
packages/categories/tcl/categories-procs-oracle.xql

[ hide source ] | [ make this the default ]
Show another procedure: