Hi all,

I am trying to use the Join feature in SOLR trunk with limited sucess. I am able to make simple searches and get the returns of documents as expected. A query such a follows works perfectly fine and as expected:

http://localhost:8983/solr/core0/select?q={!join%20from=matchset_id_ss%20to=id}*:*

I can then add parameters to this search and make the search as follows, and it works fine.
http://localhost:8983/solr/core0/select?q={!join%20from=matchset_id_ss%20to=id}*:*&fq=status_s:completed

I get filtered results of documents that are completed. The issue I am now trying to face is how do I filter the initial search of documents based on multiple conditions and then get a list of documents through the join. Here is the search I am trying to do:

http://localhost:8983/solr/core0/select?start=0&q=*:*&fq=status_i:1&rows=30&fq=team_id_i:1223

This search returns everything I want as expected, now I want to apply the join statement. I have added in the join statement above to make the new link in any place I can think of, but it seems that the join statement is taking place before any of the other filters applied. The issue becomes is that the returned documents mapped by the matchset_id_ss do not have the field status_i or team_id_i, these only exist on the initial documents I am searching.

Is there a way that I can apply multiple filters first, then complete the join? And if that is possible, can I then add more filters after the join?

Thanks for the help,

Cameron

Reply via email to