etp::get_ext_attribute_columns (public)

 etp::get_ext_attribute_columns content_type

Defined in packages/edit-this-page/tcl/etp-procs.tcl

Constructs some dynamic SQL to get each of the extended page attributes. note that the attribute values are stored for each *revision*, so we look them up based on the live revision id, not on the item id.

Parameters:

content_type

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

Testcases:

No testcase defined.

Source code:

    set extended_attributes ""
    if { $content_type ne "" && 
         $content_type ne "etp_page_revision" } {
    variable content_types

    set attributes $content_types($content_type)

    foreach attribute_desc $attributes {
        set lookup_sql [etp::get_attribute_lookup_sql $attribute_desc]
        append extended_attributes ",\n $lookup_sql"
    }
    }
    return $extended_attributes

Generic XQL file:

packages/edit-this-page/tcl/etp-procs.xql

PostgreSQL XQL file:

packages/edit-this-page/tcl/etp-procs-postgresql.xql

Oracle XQL file:

packages/edit-this-page/tcl/etp-procs-oracle.xql