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)

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