i think your best bet is to write your own hql query to do what you want - it will likely be full table scans each time and wont work with indexes