Hi,
I need to have view output ordered in alphabetical order, how can I do this?
Thanks
Weekly office hours
Bring your questions to our weekly virtual office hours, every Wednesday. Everyone is welcome.
Recent topics
Posted 1 week 2 days ago by Francis Greaves (themetman) in How-To and Troubleshooting
Posted 2 weeks 1 day ago by Francis Greaves (themetman) in How-To and Troubleshooting
Posted 3 weeks 3 days ago by (izmeez) in How-To and Troubleshooting
Posted 3 weeks 4 days ago by (izmeez) in How-To and Troubleshooting
Posted 3 weeks 4 days ago by (ian) in How-To and Troubleshooting
Recent comments
well @herb I cannot believe it, but the webform module was there in modules on the disc, but missing in the listed modules, so I delete the module folder, and downloaded it again. Then...
My Webform Worksheets have disappeared
The only thing I can think of is to make sure Webform module is enabled and that the content type that needs to contain the webforms has Webform enabled for it. Edit the content type and make...
My Webform Worksheets have disappeared
@yorkshirepudding, In the end I fixed it by deleting the config/active folder contents, copying the config/staging/ files into config/active, importing the database again and clearing the caches...
Importing the staged config throws an error: another field with the same name already exists
Thanks, I have to go out now, I will try later on and report back
Importing the staged config throws an error: another field with the same name already exists
Hi Francis. Yes, what config do you have in staging for it? You might have configs like: field.field.field_video_embed field.instance.node.page....
Comments
Whatever field you want to order by (probably node title), add it to the Sort section of the view and choose Asc order. That'll display the view in alphabetical order.
Just adding a screenshot to support the advice from @BWPanda.
Thank you very much .. indeed on the title it does the job but I should have specified (my fault) that I wanted to sort by grouped fields and by alpahbetic sort on this grouped field
Whatever the grouped field is, add it to the sort section then.
If you still have trouble, maybe post an export of the view we can look at.
Select any filter and click on Apply to see results
\r\n", "format": "full_html" } }, "allow_secondary": 0, "secondary_label": "Options avancées" }, "field_definition_du_domaine_target_id": { "bef_format": "default", "more_options": { "bef_select_all_none": false, "bef_collapsible": 0, "is_secondary": 0, "any_label": "", "bef_filter_description": "", "rewrite": { "filter_rewrite_values": "" } } }, "field_ecrivain_auteur_presentate_target_id": { "bef_format": "default", "more_options": { "bef_select_all_none": false, "bef_collapsible": 0, "is_secondary": 0, "any_label": "", "bef_filter_description": "", "rewrite": { "filter_rewrite_values": "" } } } } } }, "pager": { "type": "none", "options": { "offset": "0" } }, "style_plugin": "views_bootstrap_grid_plugin_style", "row_plugin": "fields", "fields": { "title": { "id": "title", "table": "node", "field": "title", "relationship": "none", "group_type": "group", "ui_name": "", "label": "", "exclude": 0, "alter": { "alter_text": 1, "text": "", "make_link": 0, "path": "", "absolute": 0, "external": 0, "replace_spaces": 0, "path_case": "none", "trim_whitespace": 0, "alt": "", "rel": "", "link_class": "", "prefix": "", "suffix": "", "target": "", "nl2br": 0, "max_length": "40", "word_boundary": 1, "ellipsis": 0, "more_link": 0, "more_link_text": "", "more_link_path": "", "strip_tags": 0, "trim": 1, "preserve_tags": "", "html": 0 }, "element_type": "h2", "element_class": "", "element_label_type": "", "element_label_class": "", "element_label_colon": false, "element_wrapper_type": "", "element_wrapper_class": "", "element_default_classes": 1, "empty": "", "hide_empty": 0, "empty_zero": 0, "hide_alter_empty": 1, "link_to_node": 1 }, "field_video2": { "id": "field_video2", "table": "field_data_field_video2", "field": "field_video2", "relationship": "none", "group_type": "group", "ui_name": "", "label": "", "exclude": 0, "alter": { "alter_text": 0, "text": "", "make_link": 0, "path": "", "absolute": 0, "external": 0, "replace_spaces": 0, "path_case": "none", "trim_whitespace": 1, "alt": "", "rel": "", "link_class": "", "prefix": "", "suffix": "", "target": "", "nl2br": 0, "max_length": "", "word_boundary": 1, "ellipsis": 1, "more_link": 0, "more_link_text": "", "more_link_path": "", "strip_tags": 0, "trim": 0, "preserve_tags": "", "html": 0 }, "element_type": "div", "element_class": "bordure03", "element_label_type": "", "element_label_class": "", "element_label_colon": false, "element_wrapper_type": "", "element_wrapper_class": "", "element_default_classes": 1, "empty": "Pas de vidéo de cet auteur", "hide_empty": 0, "empty_zero": 1, "hide_alter_empty": 0, "click_sort_column": "input", "type": "youtube_thumbnail", "settings": { "image_style": "", "image_link": "content", "colorbox": { "parameters": { "width": "1040", "height": "680", "autoplay": 1, "loop": 0, "showinfo": 0, "controls": 0, "autohide": 0, "iv_load_policy": 0 }, "gallery": 0 } }, "group_column": "", "group_columns": [], "group_rows": true, "delta_limit": "all", "delta_offset": 0, "delta_reversed": false, "delta_first_last": false, "multi_type": "separator", "separator": ", ", "field_api_classes": 0 }, "field_image": { "id": "field_image", "table": "field_data_field_image", "field": "field_image", "relationship": "none", "group_type": "group", "ui_name": "", "label": "", "exclude": 0, "alter": { "alter_text": 1, "text": "", "make_link": 0, "path": "", "absolute": 0, "external": 0, "replace_spaces": 0, "path_case": "none", "trim_whitespace": 0, "alt": "", "rel": "", "link_class": "", "prefix": "", "suffix": "", "target": "", "nl2br": 0, "max_length": "", "word_boundary": 1, "ellipsis": 1, "more_link": 0, "more_link_text": "", "more_link_path": "", "strip_tags": 0, "trim": 0, "preserve_tags": "", "html": 0 }, "element_type": "span", "element_class": "", "element_label_type": "", "element_label_class": "", "element_label_colon": false, "element_wrapper_type": "", "element_wrapper_class": "", "element_default_classes": 1, "empty": "", "hide_empty": 0, "empty_zero": 0, "hide_alter_empty": 1, "click_sort_column": "fid", "type": "image", "settings": { "image_style": "livre_intro", "image_link": "content", "image_float": "left", "image_load": "auto" }, "group_column": "", "group_columns": [], "group_rows": true, "delta_limit": "all", "delta_offset": 0, "delta_reversed": false, "delta_first_last": false, "multi_type": "separator", "separator": ", ", "field_api_classes": 0 }, "field_node_vers_domaine": { "id": "field_node_vers_domaine", "table": "field_data_field_node_vers_domaine", "field": "field_node_vers_domaine", "relationship": "none", "group_type": "group", "ui_name": "", "label": "", "exclude": 1, "alter": { "alter_text": 1, "text": "", "make_link": 0, "path": "", "absolute": 0, "external": 0, "replace_spaces": 0, "path_case": "none", "trim_whitespace": 0, "alt": "", "rel": "", "link_class": "", "prefix": "", "suffix": "", "target": "", "nl2br": 0, "max_length": "", "word_boundary": 1, "ellipsis": 1, "more_link": 0, "more_link_text": "", "more_link_path": "", "strip_tags": 0, "trim": 0, "preserve_tags": "", "html": 0 }, "element_type": "", "element_class": "", "element_label_type": "", "element_label_class": "", "element_label_colon": false, "element_wrapper_type": "", "element_wrapper_class": "", "element_default_classes": 1, "empty": "", "hide_empty": 0, "empty_zero": 0, "hide_alter_empty": 1, "click_sort_column": "nid", "type": "node_reference_default", "settings": [], "group_column": "nid", "group_columns": [], "group_rows": 1, "delta_limit": "all", "delta_offset": "0", "delta_reversed": 0, "delta_first_last": 0, "multi_type": "separator", "separator": ", ", "field_api_classes": 0 }, "field_node_vers_auteur": { "id": "field_node_vers_auteur", "table": "field_data_field_node_vers_auteur", "field": "field_node_vers_auteur", "relationship": "none", "group_type": "group", "ui_name": "", "label": "Auteur", "exclude": 1, "alter": { "alter_text": 0, "text": "", "make_link": 0, "path": "", "absolute": 0, "external": 0, "replace_spaces": 0, "path_case": "none", "trim_whitespace": 0, "alt": "", "rel": "", "link_class": "", "prefix": "", "suffix": "", "target": "", "nl2br": 0, "max_length": "", "word_boundary": 1, "ellipsis": 1, "more_link": 0, "more_link_text": "", "more_link_path": "", "strip_tags": 0, "trim": 0, "preserve_tags": "", "html": 0 }, "element_type": "", "element_class": "", "element_label_type": "", "element_label_class": "", "element_label_colon": 1, "element_wrapper_type": "", "element_wrapper_class": "", "element_default_classes": 1, "empty": "", "hide_empty": 0, "empty_zero": 0, "hide_alter_empty": 1, "click_sort_column": "nid", "type": "node_reference_default", "settings": [], "group_column": "nid", "group_columns": [], "group_rows": 1, "delta_limit": "all", "delta_offset": "0", "delta_reversed": 0, "delta_first_last": 0, "multi_type": "separator", "separator": ", ", "field_api_classes": 0 } }, "filters": { "status": { "value": 1, "table": "node", "field": "status", "id": "status", "expose": { "operator": false }, "group": 1 }, "type": { "id": "type", "table": "node", "field": "type", "relationship": "none", "group_type": "group", "ui_name": "", "operator": "in", "value": { "videoscience": "videoscience" }, "group": 1, "exposed": false, "expose": { "operator_id": "type_op", "label": "Type de publication", "description": "", "use_operator": 0, "operator": "type_op", "identifier": "type", "required": 0, "remember": 0, "multiple": 0, "remember_roles": { "authenticated": "authenticated", "anonymous": 0, "editor": 0, "administrator": 0 }, "reduce": 1 }, "is_grouped": false, "group_info": { "label": "Type", "description": "", "identifier": "type", "optional": 1, "widget": "radios", "multiple": 0, "remember": 0, "default_group": "1", "default_group_multiple": [], "group_items": { "1": { "title": "filtre 1", "operator": "in", "value": { "domaine_scientifique": "domaine_scientifique", "ecrivains_auteurs_presentateurs": "ecrivains_auteurs_presentateurs", "livre": "livre", "videoscience": "videoscience", "video_de_musique": "video_de_musique", "all": 0, "post": 0, "date": 0, "instrument": 0, "layout_node": 0, "page": 0, "book": 0, "webform": 0, "bundle_image": 0 } }, "2": { "title": "filtre 2", "operator": "in", "value": { "domaine_scientifique": "domaine_scientifique", "ecrivains_auteurs_presentateurs": "ecrivains_auteurs_presentateurs", "livre": "livre", "videoscience": "videoscience", "video_de_musique": "video_de_musique", "all": 0, "post": 0, "date": 0, "instrument": 0, "layout_node": 0, "page": 0, "book": 0, "webform": 0, "bundle_image": 0 } }, "3": { "title": "filtre 3", "operator": "in", "value": { "domaine_scientifique": "domaine_scientifique", "ecrivains_auteurs_presentateurs": "ecrivains_auteurs_presentateurs", "livre": "livre", "videoscience": "videoscience", "video_de_musique": "video_de_musique", "all": 0, "post": 0, "date": 0, "instrument": 0, "layout_node": 0, "page": 0, "book": 0, "webform": 0, "bundle_image": 0 } } } } }, "field_node_vers_domaine_nid": { "id": "field_node_vers_domaine_nid", "table": "field_data_field_node_vers_domaine", "field": "field_node_vers_domaine_nid", "relationship": "none", "group_type": "group", "ui_name": "", "operator": "in", "value": [], "group": "1", "exposed": true, "expose": { "operator_id": "field_node_vers_domaine_nid_op", "label": "Domaines ", "description": "", "use_operator": 0, "operator": "field_node_vers_domaine_nid_op", "identifier": "field_node_vers_domaine_nid", "required": 0, "remember": 0, "multiple": 0, "remember_roles": { "authenticated": "authenticated", "anonymous": 0, "editor": 0, "administrator": 0 }, "reduce": 0 }, "is_grouped": false, "group_info": { "label": "", "description": "", "identifier": "", "optional": true, "widget": "select", "multiple": false, "remember": 0, "default_group": "All", "default_group_multiple": [], "group_items": [] } }, "field_node_vers_auteur_nid": { "id": "field_node_vers_auteur_nid", "table": "field_data_field_node_vers_auteur", "field": "field_node_vers_auteur_nid", "relationship": "none", "group_type": "group", "ui_name": "", "operator": "in", "value": [], "group": "1", "exposed": true, "expose": { "operator_id": "field_node_vers_auteur_nid_op", "label": "Auteurs ", "description": "", "use_operator": 0, "operator": "field_node_vers_auteur_nid_op", "identifier": "field_node_vers_auteur_nid", "required": 0, "remember": 0, "multiple": 0, "remember_roles": { "authenticated": "authenticated", "anonymous": 0, "editor": 0, "administrator": 0 }, "reduce": 0 }, "is_grouped": false, "group_info": { "label": "", "description": "", "identifier": "", "optional": true, "widget": "select", "multiple": false, "remember": 0, "default_group": "All", "default_group_multiple": [], "group_items": [] } } }, "sorts": { "title": { "id": "title", "table": "node", "field": "title", "relationship": "none", "group_type": "group", "ui_name": "", "order": "ASC", "exposed": false, "expose": { "label": "" } } }, "title": "Vidéos de Sciences", "row_options": { "default_field_elements": 1, "inline": [], "separator": "", "hide_empty": 0 }, "use_ajax": true, "style_options": { "grouping": [], "alignment": "horizontal", "columns": "2", "class_prefix": "col-sm" }, "arguments": [], "relationships": [], "empty": [], "filter_groups": { "operator": "AND", "groups": { "1": "AND" } }, "link_display": "page", "css_class": "" } }, "page": { "display_title": "Page", "display_plugin": "page", "display_options": { "query": { "type": "views_query", "options": [] }, "path": "sciences/vue-des-videos-de-science-avec-selecteurs", "menu": { "type": "normal", "title": "Vidéos de science ", "description": "", "name": "main-menu", "weight": "0", "context": 0, "context_only_inline": 0 }, "style_plugin": "views_bootstrap_grid_plugin_style", "defaults": { "style_plugin": false, "style_options": false, "row_plugin": false, "row_options": false }, "style_options": { "grouping": [ { "field": "field_node_vers_domaine", "rendered": 1, "rendered_strip": 0 } ], "alignment": "horizontal", "columns": "4", "class_prefix": "col-sm" }, "row_plugin": "fields", "row_options": { "default_field_elements": 1, "inline": [], "separator": "", "hide_empty": 0 }, "exposed_block": false } }, "entityreference_1": { "display_title": "Entity Reference", "display_plugin": "entityreference", "display_options": { "query": { "type": "views_query", "options": [] }, "style_options": { "grouping": [ { "field": "title", "rendered": 1, "rendered_strip": 0 } ], "search_fields": { "title": "title" } }, "row_options": { "default_field_elements": 1, "inline": { "title": "title" }, "separator": "-", "hide_empty": 0 } } }, "block_de_liste_standard_des_videos_de_sciences": { "display_title": "Bloc", "display_plugin": "block", "display_options": { "query": { "type": "views_query", "options": [] }, "block_description": "block de liste standard des vidéos de sciences", "inherit_path": "1", "exposed_block": false, "style_plugin": "views_bootstrap_grid_plugin_style", "defaults": { "style_plugin": false, "style_options": false, "row_plugin": false, "row_options": false, "pager": false, "pager_options": false, "title": false, "exposed_form": false, "exposed_form_options": false }, "style_options": { "grouping": [], "alignment": "horizontal", "columns": "3", "class_prefix": "col-sm" }, "row_plugin": "fields", "row_options": { "default_field_elements": 1, "inline": [], "separator": "", "hide_empty": 0 }, "pager": { "type": "none", "options": { "offset": "0" } }, "pager_options": null, "link_to_view": "1", "link_url": "", "title": "", "exposed_form": { "type": "better_exposed_filters", "options": { "submit_button": "Appliquer", "reset_button": 1, "reset_button_label": "Réinitialiser", "exposed_sorts_label": "Trier par", "expose_sort_order": 0, "sort_asc_label": "Asc", "sort_desc_label": "Desc", "autosubmit": 1, "autosubmit_hide": 1, "bef": { "general": { "input_required": 0, "text_input_required": { "text_input_required": { "value": "Select any filter and click on Apply to see results
\r\n", "format": "filtered_html" } }, "allow_secondary": 0, "secondary_label": "Options avancées" }, "field_definition_du_domaine_target_id": { "bef_format": "default", "more_options": { "bef_select_all_none": false, "bef_collapsible": 0, "is_secondary": 0, "any_label": "", "bef_filter_description": "", "rewrite": { "filter_rewrite_values": "" } } }, "field_ecrivain_auteur_presentate_target_id": { "bef_format": "default", "more_options": { "bef_select_all_none": false, "bef_collapsible": 0, "is_secondary": 0, "any_label": "", "bef_filter_description": "", "rewrite": { "filter_rewrite_values": "" } } } } } }, "exposed_form_options": null } } } }It looks like your Page view is being grouped by the 'field_node_vers_domaine' field. So this is the one you need to Sort by.
This is what I did and I have the same result and more i have many times the same node because some nodes belong to more than one categories..maybe that i want to do is not feasible and i should find a workaround ..
For the multiple nodes showing up, maybe try various combinations of aggregation and distinct settings. They are both in the right-most column, in the Other section. The distinct settings are in the Query settings area. I would start with the distinct and pure distinct settings to see if they help.
Thanks the suggestion; i have tried but don't work either ..