ElasticSearch Multi-Select Faceting Example

README.txt

This is an example how to perform multi-select faceting in ElasticSearch.

Selecting multiple values from the same facet will result in an OR filter between each of the values:
(facet1.value1 OR facet1.value2)

Faceting on more than one facet will result in an AND filter between each facet:
(facet1.value1 OR facet1.value2) AND (facet2.value1)

I have chosen to update the counts for each facet the selected value DOES NOT belong to since we are performing an AND between each facet.  I have included an example that shows how to keep the counts if you don't want to do this (filter0.sh).


docs.sh - the example documents
query.sh - the initial query
filter0.sh - filter on tag "tag2", keeping counts
filter1.sh - filter on tag "tag2", update counts
filter2.sh - filter on tags "tag2" and "tag4", update counts
filter3.sh - filter on tags "tag2" and "tag4", keyword "keyword0", update counts
filter4.sh - filter on tags "tag2" and "tag4", keywords "keyword0" and "keyword2", update counts

docs.sh

curl -XPUT 'http://localhost:9200/multiselect/demo/1' -d '{
    "title": "One",
    "tags": ["tag1"],
    "keywords": ["keyword1","keyword2","keyword3"]
}'

curl -XPUT 'http://localhost:9200/multiselect/demo/2' -d '{
    "title": "Two",
    "tags": ["tag1","tag2"],
    "keywords": ["keyword1","keyword2"]
}'

curl -XPUT 'http://localhost:9200/multiselect/demo/3' -d '{
    "title": "Three",
    "tags": ["tag1","tag2","tag3"],
    "keywords": ["keyword1"]
}'

curl -XPUT 'http://localhost:9200/multiselect/demo/4' -d '{
    "title": "Four",
    "tags": ["tag4"],
    "keywords": ["keyword0"]
}'

filter0.sh

curl -XGET 'http://localhost:9200/multiselect/demo/_search?pretty=true' -d '{
    "query": {
        "match_all": {}
    },
    "filter": {
        "terms": {
            "tags": ["tag2"]
        }
    },
    "facets": {
        "tagFacet": {
            "terms": {
                "field": "tags",
                "all_terms": true
            }
        },
        "keywordFacet": {
            "terms": {
                "field": "keywords",
                "all_terms": true
            }
        }
    }
}'

filter1.sh

curl -XGET 'http://localhost:9200/multiselect/demo/_search?pretty=true' -d '{
    "query": {
        "match_all": {}
    },
    "filter": {
        "terms": {
            "tags": ["tag2"]
        }
    },
    "facets": {
        "tagFacet": {
            "terms": {
                "field": "tags",
                "all_terms": true
            }
        },
        "keywordFacet": {
            "terms": {
                "field": "keywords",
                "all_terms": true
            },
            "facet_filter":{
                "terms": {
                    "tags": ["tag2"]
                }
            }
        }
    }
}'

filter2.sh

curl -XGET 'http://localhost:9200/multiselect/demo/_search?pretty=true' -d '{
    "query": {
        "match_all": {}
    },
    "filter": {
        "terms": {
            "tags": ["tag2","tag4"]
        }
    },
    "facets": {
        "tagFacet": {
            "terms": {
                "field": "tags",
                "all_terms": true
            }
        },
        "keywordFacet": {
            "terms": {
                "field": "keywords",
                "all_terms": true
            },
            "facet_filter":{
                "terms": {
                    "tags": ["tag2","tag4"]
                }
            }
        }
    }
}'

filter3.sh

curl -XGET 'http://localhost:9200/multiselect/demo/_search?pretty=true' -d '{
    "query": {
        "match_all": {}
    },
    "filter": {
        "and": [
            {
                "terms": {
                    "tags": ["tag2","tag4"]
                }
            },
            {
                "terms": {
                    "keywords": ["keyword0"]
                }
            }
        ]
    },
    "facets": {
        "tagFacet": {
            "terms": {
                "field": "tags",
                "all_terms": true
            },
            "facet_filter": {
                "terms": {
                    "keywords": ["keyword0"]
                }
            }
        },
        "keywordFacet": {
            "terms": {
                "field": "keywords",
                "all_terms": true
            },
            "facet_filter":{
                "terms": {
                    "tags": ["tag2","tag4"]
                }
            }
        }
    }
}'

filter4.sh

curl -XGET 'http://localhost:9200/multiselect/demo/_search?pretty=true' -d '{
    "query": {
        "match_all": {}
    },
    "filter": {
        "and": [
            {
                "terms": {
                    "tags": ["tag2","tag4"]
                }
            },
            {
                "terms": {
                    "keywords": ["keyword0","keyword2"]
                }
            }
        ]
    },
    "facets": {
        "tagFacet": {
            "terms": {
                "field": "tags",
                "all_terms": true
            },
            "facet_filter": {
                "terms": {
                    "keywords": ["keyword0","keyword2"]
                }
            }
        },
        "keywordFacet": {
            "terms": {
                "field": "keywords",
                "all_terms": true
            },
            "facet_filter":{
                "terms": {
                    "tags": ["tag2","tag4"]
                }
            }
        }
    }
}'

query.sh

curl -XGET 'http://localhost:9200/multiselect/demo/_search?pretty=true' -d '{
    "query": {
        "match_all": {}
    },
    "facets": {
        "tagFacet": {
            "terms": {
                "field": "tags",
                "all_terms": true
            }
        },
        "keywordFacet": {
            "terms": {
                "field": "keywords",
                "all_terms": true
            }
        }
    }
}'

Anyone know how to do this with the new elasticsearch aggregations instead of facets?