Tutorial

[FIX] Node Order module creating duplicates in a View?

So there is a very good and user friendly module called Node Order, but it has it's flaws. Each time I use it, it creates duplicates based on the amount of relatinships added in the View. So when I should have 10 results, I have 30 because of 2 relationships.

It happens to somehow mess with the View itself. But there is a fix for that! It took me a while to solve this one out.

Pridal/a lubo dňa So, 10/24/2020 - 16:48
Add a sort Nodeorder field

In Sort Criteria add Nodeorder field as follows in the image below.

Altering the query via custom module

In a .module file, using HOOK_views_query_alter() write the following:

use Drupal\views\ViewExecutable;
use Drupal\views\Plugin\views\query\QueryPluginBase;

function YOUR_MODULE_views_query_alter(ViewExecutable $view, QueryPluginBase $query) {
    
    // fix for node order duplicates
    if ($view->id() == 'VIEW_NAME') {
        $query->addWhereExpression(0,'taxonomy_index.tid = node__field_druh_materialu.field_druh_materialu_target_id');
    }
  
}

Replace node__field_druh_materialu.field_druh_materialu_target_id with a field you added as a taxonomy term reference field on nodes. In my case it was field_druh_materialu.

Might interest you

Tutorial
Struggling with setting up HTTPS for Drupal 8? Just copy paste the following code to .htaccess file located in your root directory and you…
Tutorial
Sometimes you unintentionally delete some relationship from Views, that your draft gets irreversibly corrupted. Not matter what you do, you…

Recommended

Article
32 views
For the past few days I am trying to comprehend why / how this blockchain even gained it'…
Tutorial
95 views
This sketch is quite easy, I used Arduino Nano with OLED 0.96″ display 128×64 resolution…
Tutorial
157 views
While working on a fairly complex website with very complex views setup, including tens…
Tutorial
14 views
In this case we have two options, either we use hook_user_presave() or we can create new…
Tutorial
15 views
When using Swiftmailer under Drupal 8 / 9 it automatically sets the headers for sender to…
Tutorial
7 views
Yes, IOS / Safari is the new internet explorer. Amount of time I spend on debugging…
Tutorial
43 views
There is a very handy function in Drupal 8 / 9, allowing developers refresh view when…
Tutorial
22 views
Often, when doing SEO checkups, SEO specialist come up with adding Schema.org…
Tutorial
174 views
I needed to test my contracts against USDC contract, specifically I needed ERC-721 mint…
Tutorial
85 views
If you are a newbie like I am and struggling with setting the proper MYSQL my.cnf config…
Tutorial
25 views
I had trouble to set this up properly, because documentation is quite misleading or often…
Article
72 views
As the title says, DO NOT in any circumstances install ANY bitcoin price extension to ANY…
Tutorial
278 views
This is (or should be) a working example of sending some Ether between two addresses.…
Module
45 views
This list was fetched from Zapper, with their /v1/token-list endpoint. Which you can…
Tutorial
143 views
In the last months I am being pretty much bombarded by my clients with asking what…