579 questions
1
vote
0
answers
23
views
How do I do a 'terms' JSON facet query on a Solr DateRangeField
I have a Solr index with one of the fields being a solr.DateRangeField, object_production_year_range_dt.
I have added some custom field definitions to my schema:
<fieldType class="solr....
0
votes
1
answer
138
views
Facet Atlas Search returning the $$SEARCH_META using C# MongoDB.Driver
I would like to do a Facet Search that returns the "$$SEARCH_META" based on the documentation (https://www.mongodb.com/docs/atlas/atlas-search/facet/). A snippet of the search definition ...
- 858
0
votes
0
answers
22
views
Can't select sub categories on filter in the products category page
I work on Prestashop 1.7.8.11 website, and I have an issue when it comes to filter products by categories on a products category page.
Indeed, let's say that I have this category tree :
-> Woman ...
- 1
0
votes
0
answers
28
views
Is it Possible to Create and Apply a New Search Facet Type in BigCommerce?
We have a BigCommerce enterprise store that uses custom fields for product filters. I'm wondering if there's a way to create and apply a new facet type to the product filters sidebar? We sell footwear ...
- 37
0
votes
2
answers
187
views
Laravel Eloquent Faceted Search, is this query possible?
I have a table inventory, which has a one-to-many relationship to a table called data. I'm creating a filter application, where the user will be able to filter inventory by color and by material for ...
- 45
0
votes
1
answer
513
views
Efficient way to store data in pgsql to create facet buckets
I have product related data with an fts index on it to do fts search. I know there are multiple ways to create facet results, however I've not found any that have adequate performance with 15+ groups. ...
- 1,168
0
votes
1
answer
2k
views
How do I use the Faceted Search on Oracle Apex with a interactive report instead of a classic report?
What I want to accomplish
in Oracle APEX: I want to be able to use the faceted search with the ability to hide/show columns on the report, and then also be able to select records in the report so that ...
0
votes
1
answer
395
views
faceted search: filter 2 columns with 1 facet
<table>
<th>curr_0</th><th>amount_0</th><th>curr_1</th><th>amount_1</th>
<tr><td style="color:salmon;">eur</td><td>100</...
- 519
1
vote
0
answers
54
views
How to access API metadata (e.g. category counts that come from elasticsearch) in react-admin ListContext
I have a graphql API that uses elasticsearch to retrieve list results. The API responses has a 'meta' key that contains the aggregations for the facets present in the search results.
I want to provide ...
- 23
0
votes
0
answers
49
views
Facet ElasticSearch on list of dict (Python)
Given
Data in index looks like
{
"entity_tags": [
{
"tags": [
"two",
"three"
],
"tag_data_type": "...
- 1
3
votes
1
answer
239
views
Algolia filters on array property not working as expected
I have an index on algolia having users like this
UserA:
{
createdAt: 1675364400000,
email: "[email protected]",
products: [
{
productId: 'product1',
dateAdded: 1675364400000,
...
- 810
1
vote
0
answers
43
views
Variable set of attributes $facets MongoDB [duplicate]
How to use the $facet aggregation when I don't know upfront the name of all the attributes?
The documentation in https://www.mongodb.com/docs/atlas/atlas-search/facet only provides examples for a ...
- 391
0
votes
1
answer
349
views
Perform search with facets unknown upfront Atlas MongoDB
I have the following document structure in MongoDB:
{
// other keys,
tags: [
tagA: "red",
tagB: "green"
]
},
{
// other keys,
tags: [
tagA: "orange",...
- 391
0
votes
1
answer
63
views
SQL correlated columns filter and sort
I have a table with many columns with different types, which I am using to filter and sort results (it is similar to faceted search with sorting).
Let's consider 2 columns: A and B. For each column an ...
- 149
0
votes
0
answers
265
views
How to return a specified facet bucket when facet.limit is used in Solr
We have a situation where we have a large number of facet buckets for a specific multi-select facet filter, so to make things 'easier' we truncate the returned facet bucket list using facet.limit; ...
- 1,385
0
votes
1
answer
125
views
SOLR Faceting for special characters
I have multiple languages(English, German, Chinese, Japanese) in my collection and I would like to perform Faceting. Faceting works good for English and German but for chinese and japanese, I am not ...
- 177
0
votes
1
answer
340
views
how to get document count which don't have any nested child in Solr
I am using Nested Document structure to index document in Solr 8.11.1. I have some of the documents which has not any child. I want a count or documents which have no nested child, how can I get it ?
...
0
votes
1
answer
238
views
Solr field facet call slow on IntPointField but faster for TrieIntField
Why does IntPointField has poor performance compared to TrieIntField?
I have setup solr 8.7.0 in standalone mode, added core 1 and core 2 and indexed 100M documents each and ran did field facet like ...
3
votes
1
answer
266
views
Selected facet should not filter own group using hibernate search
If I have some Products with color and size.
Jeans Blue Size L
Jeans Red Size S
T-shirt REd Size S
and so on..
Doing a facet search using hibernate-search works as quite well. But if I select one of ...
- 1,123
1
vote
1
answer
785
views
Escape Special Character In Solr
I'm getting following error while escaping special character '&' after running http://localhost:8983/solr/amazon_products/select?q=*:*&fq=Category:"Toys \& Games "
this query in ...
- 366
2
votes
0
answers
408
views
MongoDB vs ElasticSearch Faceted Search Navigation Use case
Problem
I have a use case where I need to build a Faceted search Navigation in a webApp. As an Example lets take a fictional e-commerce site which sells the Shoes. For Simplicity let's consider the ...
- 21
0
votes
1
answer
626
views
Creating a faceted search bar in oracle apex master detail page
I'm trying to create a search bar in my master detail page that will allow my users to search for columns throughout my master and my detail tables (as the stock search bar only allows you to search ...
0
votes
2
answers
301
views
Express JS unlimited query parameter function?
I'm trying to set an unlimited query parameter in express js.But I couldn't figure out how should I implement that in my code. I'm using MongoDB aggeration
I want to build unlimited facets searched ...
user16395466
0
votes
0
answers
208
views
Faceted search mysql (EAV). How to increase speed of facet counting?
I make faceted search using mysql and it was good on test data. Then I upload 7000 of items and 20000 of filter-item relations. Now some queries to count items amount for each filters takes much time.
...
- 1
1
vote
0
answers
176
views
use $facet with mongoDB $search for filters navigation
How can I make brands that don't change with $search when using with filters.
const products = await Product.aggregate([
{
$search: {
compound: {
must: finalQuery,
},
...
- 41
1
vote
1
answer
299
views
Solr 8.6 search by daterange field throws java.lang.NoClassDefFoundError: com/google/common/util/concurrent/internal/InternalFutureFailureAccess
We are migrating from Solr version 7.7.3 to 8.6.3 and faced with problem, when searching by daterange field solr trows exception java.lang.NoClassDefFoundError: com/google/common/util/concurrent/...
- 83
1
vote
0
answers
199
views
Prestashop faceted search customized value repeated per products how to
After upgrade Prestashop & faceted module Prestashop faceted search customized value repeated per products how to resolve I am trying lots from back office uninstall & reinstall module but ...
- 11
1
vote
0
answers
87
views
Lucene Taxonomy Facets: difference between Hierarchial and DrillDown search
When I index fields using Lucene's taxonomy mechanism, I can specify the hierarchial path:
var doc = new Document();
doc.add(new FacetField("Date", "2010", "10", "15&...
- 1,666
0
votes
1
answer
411
views
Bigcommerce Infinite scroll not working after faceted search is made
Infinite scroll to our Custom PLP page is only working for page load alone. After selecting the faceted search, the infinite scroll feature is not working after the faceted response is appended. ...
- 1
0
votes
0
answers
352
views
Faceted Search - Using multiple facets with AND / OR conjunction
I am using Solr 8.7.0 with Drupal 8. I have multiple solr facets in place but need to set up OR condition for some facets and also AND conditions with some facets. Example as below:
-------------------...
- 332
0
votes
0
answers
1k
views
How to execute date range query on date index - SOLR
What is the correct way to run the range queries on SOLR date index field. Below is the snapshot from schema.xml file for the field definition:
<dynamicField name="ds_*" type="pdate&...
- 332
1
vote
0
answers
107
views
Solr get facets on each root document
I have a JSON with documents and each document has a few _childDocuments_ I want to search in the parent and get back the parents and facets on each parent separate
Here is a sample JSON
[{
&...
- 3,027
0
votes
0
answers
230
views
excludeTags in facets does not exclude a term
My document collection has an attribute cfname2. Using JSON API I can query *:* and facet on this attribute and exclude 00 term:
GET http://localhost:5555/solr/db/query HTTP/1.1
content-type: ...
- 1,064
1
vote
1
answer
1k
views
SAP Hybris boolean custom facet
Add boolean attribute to ProductModel and display it as facet on PLP.
Added new attribute named recipe to ProductModel.
Written populator for it.
- In solr.impex file added below impex
...
- 13
2
votes
1
answer
752
views
Faceted Search and selecting multiple values - mongodb $facet
I am working on a e-commerce project and want to build faceted search in it. I have been able to create different kinds of filters using the $facet operator. One of the tags is colors. Say I search ...
- 718
1
vote
0
answers
39
views
Solr: How to do DISTINCT(field1, field2, field3) search on documents with many fields?
For doing a Solr search: Imagine I have documents that have 6 fields each. I want to search on conditions of 2 fields, return those fields along with a 3rd and 4th field only (instead of all 6 ...
- 910
0
votes
1
answer
3k
views
how to add Image instead of Icon in card Template - Oracle Apex
I have a classic report with the standard query for a card in the classic report for the search results of a faceted region but the it main focus is getting it to query from the database and showing ...
1
vote
0
answers
789
views
How can i get solrclient, solr endpointurl and index used by hybris facet search?
I has my SAP Hybris project in JAVA. It using solr for caching product and other data.
I want to search data from the solr with specified string and relevance product of string.
I achieved it by using ...
- 23
0
votes
1
answer
100
views
Lucene search getting strange facet results for a text field
I'm using Sitecore with Lucene, and I'm trying to facet on an integer field, so that I can get all of the existing values for that field. I have the following search result class with a definition for ...
- 4,844
0
votes
0
answers
281
views
Solr returns Unknown aggregation agg_range on facet range query
I am using Solr 8.5 and the JSON Facet API. I would like to group by amounts (positive, negative), inside that the categories of my positions, and sum the amounts together. My query is as follows:
...
- 35
0
votes
1
answer
2k
views
Custom facets using Elastic Search
I have a search page that uses facets. When a user enters terms in the search bar or selects a facet checkbox on the left hand column, this triggers a new search in our Elastic Search index.
Here is ...
- 1,511
0
votes
0
answers
396
views
Solr Facet Pivot Date Field Gap
How can I group the following solr query day by day, is it possible? I don't want re-index for date.
Solr Query
fq=feeddate:[2019-01-01T00:00:00Z%20TO%202019-02-01T00:00:00Z]
&facet.range={!tag=...
0
votes
0
answers
81
views
Solr Facet Group Query Filtering
There is about 12 million solr data as shown in the model below. I want to group emotion values using solr facet query structure and find the total number of values, how can I do?
<doc>
<...
0
votes
1
answer
469
views
Pagination link of TYPO3 extension "ke_search" is missing some parameters and is not working. How to fix?
I am using the ke_search and its pagination to display search results. when I search for a word, the 1st page is displaying correctly. But the pagination links to other pages from the 2nd page onwards ...
- 53
1
vote
0
answers
179
views
Solr duplicate documents count based on multi-valued field using faceting
I have to find the count of duplicate documents based on the same values in a multi-valued field. Here documents refer to BI reports in my use case. And this multi-valued field is a metadata of the ...
- 41
0
votes
0
answers
38
views
Creating Filters/Facets on Filtered Results
I have a JS code that gets results from SOLR (v8.3.x). I have a few select boxes that get populated based on the facets I receive from SOLR. The problem is that since I create options based on the ...
1
vote
0
answers
883
views
Using facetWP, how do I filter by a facet in a WP_Query?
How do I add a facet filter to WP_Query? Here is what I'm trying, how do I get a ticket_price of 2:
$args = array(
'post_type' => 'ticket',
'posts_per_page' => 200,
'...
- 11
1
vote
0
answers
135
views
lucene.net DoubleRangeFacetCounts doesn't handle multi value fields
We create a price facet for a lot of our customers and generally we put sale price and list price both into the facet.
Example Items:
Hat, Sale: $5 List $11
We enter both of those into the document ...
- 41
0
votes
0
answers
1k
views
Django template Sorting search results on dropdown select
I have a search result django template called search_result.html
In the template, I have a list of products based on my filter criteria. I also have a dropdown to sort the result.
I would like to ...
- 145
1
vote
0
answers
181
views
Solr faceting considering the availability of product at attribute combination level for e-commerce merchandise like Garment
We are using Apache Solr for powering our search & faceting for the e-commerce website.
We have a faceting filter that works fine except for the product that has the multiple combination for the ...
- 3,207