Hi I have about 15 fields in my solr schema but there are two fields lets say them field1 and field2 in my schema. For most searches I feel I have a perfect schema but for one use case it is not apt: *problem*: I have to group by column using field1 and then I have to search a particular value "a" in field1 only when "b" is not present in any instance of field2 of this respective group. (Same as using "having" after group by in mysql). Is there a way to do this in Solr or do I have to maintain a separate schema for this(which will be a very costly operation for us).
Thanks in advance