When a list property is a substring of another substring

[AnitaNgaire]

What I’m trying to do

I have a database of plants, and use a list for the plant status, and this is where I have gotten myself in a muddle

One of the possible statuses is “Have”, that is I have a plant, and one is “Have seeds”, that is I have seeds of the plant. Every combination is possible; I can have neither, I can have a plant but no seeds, seeds but no plant, and both.

How do I filter for plants which contain the status “Have”?

Things I have tried

A straight WHERE contains(PlantStatus, “Have”) brings plants where I have the seeds but not the plant as well as ones where I have the plant. If I add "AND !contains(PlantStatus, “Have seeds”) then cards where I have the plants as well as the seeds disappear.

Is there a better option than replacing “Have” with “Have plant”?

[dawni]

TABLE PlantStatus
WHERE filter(PlantStatus, (s) => s = "Have")

That looks though each value in the PlantStatus lists for any that are strictly “Have”.

[AnitaNgaire]

Thank you!!!