etp::get_attribute_lookup_sql (public)

 etp::get_attribute_lookup_sql attribute_desc

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

Parameters:

attribute_desc (required)

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

Testcases:

No testcase defined.

Source code:

        set attribute_id [etp::get_attribute_id $attribute_desc]
        set attribute_name [etp::get_attribute_name $attribute_desc]
        set default [etp::get_attribute_default $attribute_desc]

        set lookup_sql [db_map lookup_sql_clause]

        # see if a select-list callback function was specified
        if { [info commands $default] ne "" } {
            set transformed_lookup_sql [eval $default transform_during_query $attribute_id {$lookup_sql}]

            if {$transformed_lookup_sql ne ""} {
                set lookup_sql $transformed_lookup_sql
            }
        }
        return "$lookup_sql as $attribute_name"

Generic XQL file:

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

PostgreSQL XQL file:

<fullquery name="etp::get_attribute_lookup_sql.lookup_sql_clause">
    <querytext>
    etp__get_attribute_value(r.revision_id, $attribute_id)
  </querytext>
</fullquery>

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

Oracle XQL file:

<fullquery name="etp::get_attribute_lookup_sql.lookup_sql_clause">
    <querytext>
    etp.get_attribute_value(r.revision_id, $attribute_id)
  </querytext>
</fullquery>

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