Hi Nigel. Thanks for the tip. Actually, the context was in the “and when” section of a button click even handler. So this doesn’t work exactly but I got it to work. Instead of using the two criteria for filtering the list I wanted to in the constraint, I first have to generate a return list using what I could in the constraints, and then filter the resulting list with the :filter advanced option to use the field of the embedded object to do the final searching to see if I have any matching objects.
This will make me re-think future data modeling. The “correct” way is to use embedded objects and lists of objects from an object/data oriented design perspective. However, the UI of constructing queries in bubble makes that somewhat convulted and cumbersome to create queries to yield the desired resulting datasets.