Views search filters, when searching for multiple words, utilize GROUP BY and HAVING statements to determine which results should be returned. (a row is returned for each word match, and the count of matches must be equal to the number of words searched for)

Since the views_random_seed inserts its value as a field, it is included in the GROUP BY statement and no values pass the HAVING statement.

CommentFileSizeAuthor
#1 views_random_seed-1986490-1.patch559 bytesgapple

Comments

gapple’s picture

gapple
he/they
Primary language English
commented
Status: Active » Needs review
StatusFileSize
new views_random_seed-1986490-1.patch559 bytes

The attached patch acts like views' built in random sort handler, by not adding a field and only adding the expression to the ORDER BY clause.

vitaliyb98’s picture

vitaliyb98 commented
Version: 7.x-1.x-dev » 8.x-1.x-dev
Issue summary: View changes
Status: Needs review » Closed (cannot reproduce)

Hi @gapple,

I tried to reproduce this issue using the latest supported version of the module on Drupal 11, but I was unable to reproduce it.

If the issue still occurs with the latest version of the module, please provide detailed steps to reproduce it.

Now that this issue is closed, review the contribution record.

As a contributor, attribute any organization that helped you, or if you volunteered your own time.

Maintainers, credit people who helped resolve this issue.