Posted by philippeg on Sat, Jan 30, 2021 - 9:28am

Hi,

I need to have view output ordered in alphabetical order, how can I do this?

Thanks

 

Comments

Sat, Jan 30, 2021 - 11:34am by BWPanda (not verified)

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.

Sat, Jan 30, 2021 - 12:16pm by stpaultim

Just adding a screenshot to support the advice from @BWPanda.

screenshot of sort in views user interface

Sat, Jan 30, 2021 - 7:28pm by philippeg

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

Sun, Jan 31, 2021 - 12:36am by BWPanda (not verified)

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.

Sun, Jan 31, 2021 - 1:12am by philippeg

{ "_config_name": "views.view.block_de_vue_des_videos_du_meme_auteur", "name": "block_de_vue_des_videos_du_meme_auteur", "description": "", "tag": "default", "disabled": false, "base_table": "node", "human_name": "Liste standard des vidéos de science", "core": "1.17.1", "display": { "default": { "display_title": "Master", "display_plugin": "default", "display_options": { "query": { "type": "views_query", "options": [] }, "access": { "type": "perm", "perm": "access content" }, "cache": { "type": "none" }, "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": 1, "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": "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 } } } }

Mon, Feb 01, 2021 - 12:31pm by BWPanda (not verified)

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.

Tue, Feb 02, 2021 - 12:33am by philippeg

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 ..

oadaeh's picture

Sun, Feb 07, 2021 - 3:38pm by oadaeh

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.

Sun, Feb 07, 2021 - 6:51pm by philippeg

Thanks the suggestion; i have tried but don't work either ..