Contrib.social

Make the Views Entity Form Field sortable

Open on Drupal.org →
Created on 25 March 2024, 10 months ago

Problem/Motivation

Currently the Views Entity Form Field does has sorting disabled, although unlike other pseudo fields it is based on real fields which are stored in the database. With the information from the entity field the form field is representing the view can be easily be sorted if the correct statements about field aliases, join statements for relationships and order by clauses are added to the views query.

Steps to reproduce

The Views Entity Form Field can not be selected for sorting (default or click sorting) in the format settings of the view.

Proposed resolution

As the Views Entity Form Field is based on entity fields, which are stored in the database, sorting can be enabled and be based on the settings of the underlying entity field. If the field does not use a view relationship, it has to be added to the field aliases in the view query. If it uses a view relationship, a corresponding "join" statement should be added to the view query. To enable the sorting, an "order by" clause is added to the view query.

Remaining tasks

Provide a patch.

User interface changes

The Views Entity Form Fields can be selected as sortable in the view settings.

API changes

None

Data model changes

None

✨ Feature request
Status

Active

Component

Code

Created by

🇦🇹Austria jordik

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

  • Issue created by @jordik
  • Status changed to Needs review 10 months ago
  • Comment 10 months ago →
    🇦🇹Austria jordik
  • Comment 10 months ago →
    🇦🇹Austria jordik

    Small change - adding hardcoded 'entity_id' for the query table field. Works like a charm now.

  • Status changed to Needs work 1 day ago
  • Comment 1 day ago →
    🇮🇩Indonesia gausarts

    @jordik , thank you for your work!

    I need to make taxonomy and other entities sortable as well.

    I made it work for entities by replacing this line:

    +    $column = $field_name . '_value';
+    $table_alias = $table . '__' . $field_name;

    With this:

    +    $field_definition = $this->getBundleFieldDefinition();
+    $column = $field_name . '_value';
+
+    if ($field_definition->getType() == 'entity_reference') {
+      $column = $field_name . '_target_id';
+    }
+
+    $table_alias = $table . '__' . $field_name;

    If you could update it to support entities like above or any other way, that would be great.

    Considering it is assigned to you, I would leave it to maintainers' and your consideration.

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024