lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Darniz <rnizamud...@edmunds.com>
Subject filter on solr pivot data
Date Fri, 09 Jan 2015 19:14:59 GMT
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.

Mime
View raw message