Menu
  • HOME
  • TAGS

elasticsearch - additional field in aggregation results

elasticsearch,faceted-search

Use a sub-aggregation on the category.id, you will do a bit more work when looking at the results, but I think it's better than changing the mapping: { "aggs": { "name": { "terms": { "field": "name" }, "aggs": { "id": { "terms": { "field": "id" } } } } }...

Hierarchical faceted search example with Solr

solr,faceted-search,hierarchical

You can get all of your aggregations to be populated if you push them into the index in stages. If Bob is from Norway, you might populate up to three values in your facet field: location location/Europe location/Europe/Norway (As an alternate design, you might have a hair color field separate...

Facet groups in Solr - is this possible in one query

solr,facet,faceted-search

This can implemented using tagged filters and then excluding them when creating the facet. From the referenced page: To implement a multi-select facet for doctype, a GUI may want to still display the other doctype values and their associated counts, as if the doctype:pdf constraint had not yet been applied....

How to facet (group) over two fields in Apache Solr

solr,solr4,faceted-search

You might want to take a look at Solr pivot faceting: Solr faceting + pivot faceting...

Faceted Search Attribute Count

php,mysql,faceted-search

Here is how you can this: SELECT meta_name, meta_value, COUNT(DISTINCT item_id) count FROM meta m JOIN item_meta im ON im.field_id = m.id GROUP BY meta_name, meta_value Output: | META_NAME | META_VALUE | COUNT | |----------------|------------|-------| | Car Type | Coupe | 2 | | Car Type | Sedan | 1...

Alfresco 5.0.a - custom search facet

search,share,alfresco,faceted-search

Well I finally solve the problem. Just for clarification: I had a requirement to use 5.0.a version in which there is no Search Manager page. The solution which I used is a bit dirty, but it worked. I just overwrite the faceted-search.get.js and changed the facets array by adding my...

elasticsearch: is it possible to order aggregations?

elasticsearch,faceted-search

Can I add weight to each aggregation to make sure that they return in certain order, for example: category, manufacturer, color instead of in the order shown below The response is JSON and JSON/JavaScript object keys order is undefined. Source: http://www.json.org/ An object is an unordered set of name/value...

Alfresco 5.0.a/b doubled facets for d:mltext

search,solr,share,alfresco,faceted-search

I raised an issue ALF-21249 And also found a workaround, which is a bit dirty, but works well. Let's say you have a property with name ccm:property which has type d:mltext and you want to have facet for this property in English and French. Define an aspect with two d:text...

RavenDB Facet Null_Value

c#,ravendb,faceted-search

Add Where condition after Select to filter the size: Map = listings => listings .Select(listing => new { category = listing.Category, make = listing.Make, size = listing.Size // Size may sometimes be NULL }).Where(e => e.Size != null); ...

Calculating product counts (efficiently) in faceted search with PHP, MySQL

php,mysql,faceted-search

The fault in my thinking was that I would need an extra query for every possible filter to accurately calculate the product counts. However, the counts are only inaccurate for (radio) options in a currently selected filter (like Memory above), so if I simply recalculate product counts only for the...

Facet on multiple fields at once and aggregate the results

solr,facet,faceted-search

You can create an aggregating field all_errors and use <copyField source="error_code*" dest="all_errors" /> to populate it.