Hi Edward,
Thanks a lot for your reply!
Subquery is what I had in mind, too, for designs 1) and 3) to bring
back the other side of the relationship. Except that I always queries
movies and subqueried users.
If I do it the other way around, like you did, then I'm able to
filter. I can't quite
Just for the sake of an imagined scenario, you could use the [subquery] doc
transformer. A query like the one below:
/select?q=family: Smith=watched_movies:[* TO *]=*,
movies:[subquery]={!terms f=id v=$row.watched_movies}
Would bring back the results below:
{ "responseHeader":{
"status":0,
Hello Solr users,
How would you design a filtered join scenario?
Say I have a bunch of movies (excuse any inaccuracies, this is an
imagined scenario):
curl -XPOST -H 'Content-Type: application/json'
'localhost:8983/solr/test/update?commitWithin=1000' --data-binary '
[{
"id": "1",
"title":