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
)
update acs_attributes
set pretty_name = :pretty_name,
pretty_plural = :pretty_plural
where attribute_id = :attribute_id
select attribute_id
from acs_attributes
where object_type in ([ams::object_parents -sql -show_root -object_type $object_type])
and attribute_name = :attribute_name
select default_value
from ams_attributes
where attribute_id = :attribute_id
update acs_attributes
set default_value = :default_value
where attribute_id = :attribute_id
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
and attribute_id not in ( select attribute_id from ams_attribute_values where object_id = :to ))
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
delete from ams_attribute_values
where object_id = :object_id
and attribute_id = :attribute_id
insert into ams_attribute_values
(object_id,attribute_id,value_id)
values
(:object_id,:attribute_id,:value_id)
select option_id
from ams_option_types
where option = :option
and attribute_id = :attribute_id
update acs_objects
set title = :pretty_name
where object_id = :option_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,
alam.html_options
from ams_list_attribute_map alam,
ams_attributes aa
where alam.attribute_id = aa.attribute_id
and alam.list_id in ($list_ids)
$orderby_clause
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 in ($list_ids)
$orderby_clause
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