Filter by "has_one" item

Summary

I want to filter for items, which have in a relational connection item of x but not y

Basic Example

Items:

So I want to check for all products, which are bought by a married customer but not includes any other status of customer. The status of product should be published. So product1 and product2 should be not be returned.

Motivation

I tried to apply "_some" and "_none" but I get a error:
reason: '"_none" can only be used with top level relational alias field'

Detailed Design

Implement the _some or _none filter for relational items

Requirements List

Must Have:

• A
• B

Should Have:

• C

Could Have:

• D

Won't Have:
• E


Drawbacks

None

Alternatives

Maybe it is already possible..?

Adoption Strategy

No

Unresolved Questions

_No response_