select pretty_name
from ams_attributes
where attribute_id = :attribute_id
select pretty_plural
from ams_attributes
where attribute_id = :attribute_id
select acs_attribute__create_attribute (
:object_type,
:attribute_name,
:datatype,
:pretty_name,
:pretty_plural,
:table_name,
:column_name,
:default_value,
:min_n_values,
:max_n_values,
:sort_order,
:storage,
:static_p
)
select attribute_id
from acs_attributes
where object_type = :object_type
and attribute_name = :attribute_name
select supertype
from acs_object_types
where object_type = :object_type
insert into ams_attribute_values
(object_id,attribute_id,value_id)
( select :to,
attribute_id,
value_id
from ams_attribute_values
where object_id = :from )
delete from ams_attribute_values
where object_id = :object_id
select *
from ams_attributes
where attribute_id = :attribute_id
select ams_attribute_id
from ams_attributes
where attribute_id = :attribute_id
select ams_attribute_value__save (
:object_id,
:attribute_id,
:value_id
)
select option
from ams_option_types
where option_id = :option_id
select alam.attribute_id,
alam.required_p,
alam.section_heading,
aa.attribute_name,
aa.pretty_name,
aa.widget
from ams_list_attribute_map alam,
ams_attributes aa
where alam.attribute_id = aa.attribute_id
and alam.list_id = :list_id
order by alam.sort_order
select alam.attribute_id,
alam.required_p,
alam.section_heading,
aa.attribute_name,
aa.pretty_name,
aa.widget
from ams_list_attribute_map alam,
ams_attributes aa
where alam.attribute_id = aa.attribute_id
and alam.list_id = :list_id
order by alam.sort_order
select aav.*, aa.attribute_name, aa.widget, aa.pretty_name,
ams_attribute_value__value(aav.attribute_id,aav.value_id) as value
from ams_attribute_values aav,
ams_attributes aa
where aav.object_id = :object_id
and aav.attribute_id = aa.attribute_id
and aa.attribute_id in ( select attribute_id from ams_list_attribute_map where list_id = :list_id )
select alam.attribute_id,
alam.section_heading,
aa.attribute_name,
aa.pretty_name,
aa.widget,
av.value
from ams_list_attribute_map alam,
ams_attributes aa left join (
select ams_attribute_values.attribute_id,
ams_attribute_value__value(ams_attribute_values.attribute_id,ams_attribute_values.value_id) as value
from ams_attribute_values
where ams_attribute_values.object_id = :object_id ) av on ( aa.attribute_id = av.attribute_id )
where alam.attribute_id = aa.attribute_id
and alam.list_id = :list_id
order by alam.sort_order
select ams_attribute_value__value(av.attribute_id,av.value_id) as value, widget,attribute_name,av.attribute_id
from ams_attribute_values av, ams_attributes aa
where object_id = :object_id
and av.attribute_id = aa.attribute_id
$where_clause