category::list::rewrite_query (public)

 category::list::rewrite_query -object_column object_column \
    [ -category_column category_column ] [ -dbn dbn ] sql

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

Takes a sql-query and adds an outer join to category_object_map

Switches:

-object_column

(required)

column name that holds the object_id of the categorized object.

-category_column

(defaults to "category_id") (optional)

column name of the mapped category_id.

-dbn

(optional)

Parameters:

sql - sql-query to be rewritten

Author:

Timo Hentschel <timo@timohentschel.de>

See Also:

• category::list::collapse_multirow
• category::list::prepare_display
• category::list::elements
• category::list::get_pretty_list

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

Testcases:

No testcase defined.

Source code:

    set driverkey [db_driverkey $dbn]
    switch $driverkey {
    oracle {
        set new_sql "select s.*, m.category_id as $category_column
        from ($sql) s, category_object_map m
        where s.$object_column = m.object_id(+)
        order by s.$object_column"
    }
    postgresql {
        set new_sql "select s.*, m.category_id as $category_column
        from ($sql) s left outer join category_object_map m
        on (s.$object_column = m.object_id)
        order by s.$object_column"
    }
    }
    return $new_sql

XQL Not present:

Generic, PostgreSQL, Oracle