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 (required)

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