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...