title: java object querying ( applying SQL logic on List of java objects)
body: <p>I have a Employee object for example, Employee contains several fields (300+) like name, department, salary, age, account, etc.
  Entire Employee table data cached into java List object , which contains 2+ million records.</p>
  
  <p><strong>Requirement</strong> 
  user can search on any filed presents in Employee object like employee name like Sehwag and age > 30 or salary > 100000, Based on user search we have to show filtered list of Employee list.</p>
  
  <p>due to performance issues we are not querying DB, we want to apply the user search criteria on cached java List object earlier </p>
  
  <p>is there way api / frameworks / any other solution where we can query on java objects?</p>
  
  <p>below approach I am trying but I am feeling not a good approach </p>
  
  <p>Iterating the Employee list and applying condition user search criteria on employee object, to know the user selected search criteria among 300 fields is challenging, written a lot enum mapping logic and some additional logic for every filed to make it work.
  with current requirement it may works but thinking to use api or framework or better way to solve the requirement!</p>
  
  <p>thanks in advance for your help.</p>