<?xml version="1.0"?> <queryset> <fullquery name="content::create_form_element.get_content_type"> <querytext> select content_type from cr_items i, cr_revisions r where r.item_id = i.item_id and r.revision_id = :revision_id </querytext> </fullquery> <partialquery name="content::create_form_element.cfe_attribute_name"> <querytext> $attribute_name </querytext> </partialquery> <fullquery name="content::create_form_element.get_element_value"> <querytext> select $what from ${table_name}x where revision_id = :revision_id </querytext> </fullquery> <partialquery name="content::query_form_metadata.attributes_query_extra_where"> <querytext> and $extra_where </querytext> </partialquery> <fullquery name="content::process_revision_form_dml.insert_revision_form"> <querytext> insert into $__last_table ( [join $__columns ", "] ) values ( [join $__values ", "] )" </querytext> </fullquery> <partialquery name="content::insert_element_data.ied_get_objects_tree_extra_where"> <querytext> and $extra_where </querytext> </partialquery> <partialquery name="content::insert_element_data.ied_get_objects_tree_order_by"> <querytext> order by types.inherit_level desc </querytext> </partialquery> <fullquery name="content::process_insert_statement.process_insert_statement"> <querytext> insert into $__last_table ( [join $__columns ", "] ) values ( [join $__values ", "] )" </querytext> </fullquery> <fullquery name="content::add_revision.addrev_get_content_type"> <querytext> select object_type as content_type, table_name from acs_object_types where object_type = (select content_type from cr_items where item_id = :item_id) </querytext> </fullquery> <fullquery name="content::upload_content.update_mime_sql"> <querytext> update cr_revisions set mime_type = :mime_type where revision_id = :revision_id </querytext> </fullquery> <fullquery name="content::add_content_element.get_text_mime_types"> <querytext> select label, map.mime_type as value from cr_mime_types types, cr_content_mime_type_map map where types.mime_type = map.mime_type and map.content_type = :content_type and lower(types.mime_type) like ('text/%') order by label </querytext> </fullquery> <fullquery name="content::add_child_relation_element.get_parent_type"> <querytext> select content_type from cr_items where item_id = :parent_id </querytext> </fullquery> <fullquery name="content::get_widget_param_value.set_content_values"> <querytext> $param(value) </querytext> </fullquery> <fullquery name="content::get_type_attribute_params.gtap_get_attribute_data"> <querytext> select [join $columns ","] from cm_attribute_widget_param_ext x where object_type in ( [join $in_list ","] ) </querytext> </fullquery> <fullquery name="content::get_attribute_params.gap_get_attribute_data"> <querytext> select [join $columns ","] from cm_attribute_widget_param_ext where object_type = :content_type and attribute_name = :attribute_name </querytext> </fullquery> <fullquery name="content::set_attribute_values.get_previous_version_values"> <querytext> select [join $columns ", "] from [get_type_info $content_type table_name]x where revision_id = :revision_id </querytext> </fullquery> <fullquery name="content::get_default_content_method.count_mime_type"> <querytext> select count(*) from cr_content_mime_type_map where content_type = :content_type and mime_type like 'text/%' </querytext> </fullquery> <fullquery name="content::get_type_info.get_type_info_1"> <querytext> select $ref from acs_object_types where object_type = :object_type </querytext> </fullquery> <fullquery name="content::get_type_info.get_type_info_2"> <querytext> select [join $args ","] from acs_object_types where object_type = :object_type </querytext> </fullquery> <fullquery name="content::copy_content.cc_get_mime_type"> <querytext> select mime_type from cr_revisions where revision_id = :revision_id_src </querytext> </fullquery> <fullquery name="content::copy_content.cc_update_cr_revisions"> <querytext> update cr_revisions set mime_type = :mime_type where revision_id = :revision_id_dest </querytext> </fullquery> <fullquery name="content::validate_name.vn_same_name_count1"> <querytext> select count(1) from cr_items where name = :name </querytext> </fullquery> <fullquery name="content::validate_name.vn_same_name_count2"> <querytext> select count(1) from cr_items where name = :name and parent_id = :parent_id </querytext> </fullquery> </queryset>