I have build two blocks and when adding the union I don't see the expected results.

I did simple patch

FROM

$query1 = $query2->union($query1, 'UNION ALL');

TO

$query1 = $query1->union($query2, 'UNION');

Removed ALL to get no duplicates and make the union be on the first (called) view to work fine

@TODO : It needs to add the ALL as an option and hope the module maintainer review and push the changes to source code after being RTBC

CommentFileSizeAuthor
#3 wrong_results-2614002-3.patch447 bytesore

Comments

mhmd created an issue. See original summary.

Courtenay’s picture

Courtenay commented

I can confirm this patch works and the Union function does not work properly without it.

ore’s picture

ore commented
StatusFileSize
new wrong_results-2614002-3.patch447 bytes

I can also confirm works with patch and not without.

Rolled into patch so I can pull into drush patch file.

somersoft’s picture

somersoft commented

Patch is a part of #748844-42: How to: Combine or merge multiple views/queries into a single view (using hook_views_pre_execute).

  • TechNikh committed c7032bf on 7.x-1.x authored by ore 
    Issue #2614002 by ore: wrong results
technikh’s picture

technikh commented
Status: Needs work » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.