Executing query on multiple list properties I am trying to search via query stockholdersIndividual by Person that has a specific firstName or lastName matching a certain text. But at the same time, I want to ensure that the results are limited to the StockRegister with a specific reference I want to avoid using an inbuilt filter to search through the entire list to find the properties matching the input. I have tried that an it takes a very long time when there are over 10,000 records. Is there a way to do this in JPA or native query...