: I am getting results from one query and I just need 2 index attribute values
: . These index attribute values are used for form new Query to Solr.
can you elaborate on what exactly you mean by "These index attribute
values are used for form new Query to Solr" ... are you saying that you
want to take the values from *every* document matching query#1 and use
them to construct query#2
this sounds like you arent' denormalizing your data enough when building
your index.
: Since Solr gives result only for GET request, hence there is restriction on
: : forming query with all values.
that's false ... you can post a query if you want, and there are not hard
constraints on how big a query can be (just practical constraints on what
your physical hardware can handle in a reasonable amount of time)
: >> > SELECT id, first_name
: >> > FROM student_details
: >> > WHERE first_name IN (SELECT first_name
: >> > FROM student_details
: >> > WHERE subject= 'Science');
: >> >
: >> > If so, how performant is this kind of queries?
even as a sql query this doesn't relaly make much sense to me (at least
not w/o a better understanding of the table+data)
why wouldn't you just say:
SELECT id, first_name FROM ...WHERE subject='Science'
..or in Solr...
q=subject:Science&fl=id,first_name
-Hoss
