I have multivalued fields in my solr datasource. sample is
<doc> <str name="id">23606</str> <arr name="institution"> <str>Harvard University</str> <str>Yale Universety</str> <str>Cornell University</str> <str>TUFTS University</str> <str>University of Arizona</str> </arr> <arr name="degree_level"> <str>Bachelors</str> <str>Diploma</str> <str>Master</str> <str>Master</str> <str>PhD</str> </arr> </doc>
in the example above this user has got Bachelors degree from Harvard, Diploma from Yale, Master from Cornell, Master from TUFTS, and PhD from Arizona.
now if i search for users who have Bachelors degree and graduated from Harvard, i will get this user, which is correct.
MyDomain:8888/solr/mycol/select?facet=true&q=:&fq=degree_level:Bachelors&fq=institution:Harvard+University
but if i want those who have Bachelors from Cornell, i will get this user as well, which is incorrect!
MyDomain:8888/solr/mycol/select?facet=true&q=:&fq=degree_level:Bachelors&fq=institution:Cornell+University
The question is: how could i preserve ordering/mapping in multivalued in solr?
Edit:
By the way, i know that i can solve my problem by creating new field to contain concatenation of the degree with university (ie, "Bachelors_Harvard University", "Diploma_Yale Universety", and so on) but i need a solution based on solr core itself as i have a lot of multivalued fields with a lot of combinations.
Below is a list of some suggestions