Exposed filter with options (term or option field) combined with unexposed filter on the same field builds broken query

Created on 14 November 2023, about 1 year ago
Updated 14 March 2024, 10 months ago

Problem/Motivation

When a taxonomy exposed filter is active with a value, the request has a clause like 'taxonomy_xx != ' + "last value of taxonomy list " when he is combined with the same filter non exposed to filter datasource

Steps to reproduce

- Create Vocabulary XX
- Create terms x1, x2, x3, x4
- Add field taxonomy term to article content type with unlimited terms and attach Vocabulary_xx
- Create nodes with a couple of vocabulary terms
- Create view with articles
- Add filter for term field non exposed with x1, x2 and x3 selected values
- Add exposed filter for term field with x1, x2 and x3 selected values and "limit list to selection items" option checked

Result:
filters x1 and x2 work apparently well but x3 result is empty, if you check the query, there are a left join with 'taxonomy_xx != x3_id' in all request.
When x3 term is selected, request has a 'taxonomy_xx != x3_id' in left join and 'taxonomy_xx = x3_id' in where clause

🐛 Bug report
Status

Needs work

Version

11.0 🔥

Component
Views 

Last updated about 2 hours ago

Created by

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

Merge Requests

Comments & Activities

Production build 0.71.5 2024