elasticsearch - additional field in aggregation results
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
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
You might want to take a look at Solr pivot faceting: Solr faceting + pivot faceting...
Faceted Search Attribute Count
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?
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
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
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
You can create an aggregating field all_errors and use <copyField source="error_code*" dest="all_errors" /> to populate it.