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