J3 Issue ?
avatar thanhnv37
thanhnv37
12 Aug 2019

Steps to reproduce the issue

In the Finder indexing plugin, I set multiple values for one taxonomy as following:

$item->addTaxonomy('Variants', 'catalan');
$item->addTaxonomy('Variants', 'occitan');
$item->addTaxonomy('Variants', 'test');

Expected result

On the search page, the item must be returned on search results if I filter by Variants field with any its variants.

Actual result

Some items are missing on search results.

For more details:
If I filter by Variant "occitan",
The results total (in pagination) display correct number of items (E.g: 1-14 of 14)
But the search results displays only 6 items.

System information (as much as possible)

After some investigating, I can fix this issue with solution below:

  1. Open the file:
    components/com_finder/models/search.php

  2. Go to the code line 226:
    ->select('l.link_id')

  3. Replace it with below one:
    ->select('DISTINCT l.link_id')

  4. Save changes and the search filter works worked correctly.

Additional comments

I hope that you can apply this fix on next release of Joomla.
Thanks

avatar thanhnv37 thanhnv37 - open - 12 Aug 2019
avatar joomla-cms-bot joomla-cms-bot - change - 12 Aug 2019
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 12 Aug 2019
avatar thanhnv37 thanhnv37 - change - 12 Aug 2019
The description was changed
avatar thanhnv37 thanhnv37 - edited - 12 Aug 2019
avatar thanhnv37 thanhnv37 - change - 12 Aug 2019
The description was changed
avatar thanhnv37 thanhnv37 - edited - 12 Aug 2019
avatar SharkyKZ
SharkyKZ - comment - 12 Aug 2019

Test PR #23735 please.

avatar franz-wohlkoenig franz-wohlkoenig - change - 12 Aug 2019
Labels Added: J3 Issue
avatar franz-wohlkoenig franz-wohlkoenig - labeled - 12 Aug 2019
avatar franz-wohlkoenig franz-wohlkoenig - change - 12 Aug 2019
Status New Closed
Closed_Date 0000-00-00 00:00:00 2019-08-12 06:20:34
Closed_By franz-wohlkoenig
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 12 Aug 2019

Closed as having Pull Request #23735

avatar franz-wohlkoenig franz-wohlkoenig - close - 12 Aug 2019

Add a Comment

Login with GitHub to post a comment