Hello i need to know how can i filter on solr pivot data.
For exampel we have a dealer which might have many cars in his lot and car has photos, i need to find out a dealer which has cars which has no photos so i have dealer1 -> has 20 cars -> all of them has photos dealer2 -> has 20 cars -> some of them have photos dealer3 -> has 20 cars -> none of them have photos in the results i want to see only dealers which has no photos ie dealer3, i managed to do pivot and get a breakdown by vin and photo exists now i want to apply filter and get only those dealer who has all vin which have photo exists as 0 lst name="facet_pivot"> <arr name="vin,mappings_|photo_exist|"> <lst> <str name="field">vin</str> <str name="value">1N4AA5AP0EC908535</str> <int name="count">1</int> <arr name="pivot"> <lst> <str name="field">mappings_|photo_exist|</str> <str name="value">1</str> <int name="count">1</int> </lst> </arr> </lst> <lst> <str name="field">vin</str> <str name="value">1N4AA5AP1EC470625</str> <int name="count">1</int> <arr name="pivot"> <lst> <str name="field">mappings_|photo_exist|</str> <str name="value">1</str> <int name="count">1</int> </lst> </arr> </lst> is it possible -- View this message in context: http://lucene.472066.n3.nabble.com/filter-on-solr-pivot-data-tp4178451.html Sent from the Solr - User mailing list archive at Nabble.com.