Searching: Exact term negation causes no results #6121

New issue

Closed

opened 2026-04-29 14:03:54 +02:00 by danb · 1 comment

danb commented

2026-04-29 14:03:54 +02:00

Owner

Description

Currently exact search term negation will form a query like this:

and not (`name` like '%API%' or `description` like '%API%' or `text` like '%API%')

Since the description/text columns are joined in (at least since entity table changes), with either one column or the other, this results in having null values as part of the "not", which then causes a match.

This needs to instead result in a query like:

and not (`name` like '%API%' or (`description` IS NOT NULL AND `description` like '%API%') or (`text` IS NOT NULL AND `text` like '%API%'))

Found while looking into support request 215

### Description Currently exact search term negation will form a query like this: ```sql and not (`name` like '%API%' or `description` like '%API%' or `text` like '%API%') ``` Since the description/text columns are joined in (at least since entity table changes), with either one column or the other, this results in having null values as part of the "not", which then causes a match. This needs to instead result in a query like: ```sql and not (`name` like '%API%' or (`description` IS NOT NULL AND `description` like '%API%') or (`text` IS NOT NULL AND `text` like '%API%')) ``` --- _Found while looking into support request 215_

👍 1

danb added the

Type

Bug Report

Focus: Back-End

labels

2026-04-29 14:03:54 +02:00

danb self-assigned this

2026-04-29 14:03:54 +02:00

danb added this to the v26.03.4 milestone

2026-04-29 14:05:04 +02:00

danb referenced this issue from a commit