These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]

Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: Filter search results with data not contained in an index
PostPosted: Sat Jun 18, 2016 3:43 am 

Joined: Sat Feb 27, 2016 1:47 am
Posts: 16
Sometimes it might not be feasible to store data in an index, yet that data is necessary for filtering the search results. So I'm wondering what tricks or techniques could be used. Lets take the following example:

public class Profile {

    public int id;
    public String name;

    @OneToMany(mappedBy = "profile")
    public Set<FavouritesMap> favouritesMap = new HashSet<FavouritesMap>();


public class FavouritesMap {

    public FavouritesMapId id;

    @JoinColumn(insertable = false, updatable = false)
    public Profile profile;

    @JoinColumn(insertable = false, updatable = false)
    public User user;


public class FavouritesMapId {

    public int userId;
    public int profileId;

Say we want to search our Profiles index, but filter the results by a specific user's favourite profiles. It's not feasible to have Profiles::favouritesMap stored in the index (ie via @IndexedEmbedded) as the collection could potentially have millions of records which would have a severe performance impact whenever a re-indexing operation took place.

My current workaround for this is essentially to do an SQL query to fetch the users favourite profiles first, and then add a restriction to the hibernate search query based on the return IDs.

Query q = em.createNativeQuery("SELECT p.id FROM Profile p JOIN FavouritesMap f ON f.id.profileId = p.id WHERE f.id.userId = X ");
List<Integer> favouriteIds = q.getResultList();

List<Query> favouritePredicates = new ArrayList<>();
for (Integer id : favouriteIds) {
mustQuery.add(combineShouldQuery(qb, favouritePredicates));

This is still not ideal as we could have ptentially 1000s of favourites to filter through. So I'm wondering if there are any other options to try?

Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.