I would like to explain my problem with a simple example.
Here is a part of my database:
That's the query I have: (It's HQL which is similar to T-SQL)
from Gecoserv _a where _a.typeOfEcosystem IN (:typeNameList) AND _a.service IN (:serviceNameList)
I want the grid to show only the single combinations (Freshwater-Habitat, Saltwater-Food and Dunes-Recreation etc.) but it shows also other combinations (ex: Freshwater-Recreation).
How can I fix my problem ?