Questions tagged [solr-query-syntax]
175 questions
1
vote
0 answers
Retrieve parent document details on querying child documents
We have the documents in the index with user and the products
[{
"id": 10,
"type": "user",
"name": "John Smith",
"rating": 4,
"_childDocuments_": [
{
"id": 11,
"type": "product",
…

alx
- 41
- 3
1
vote
0 answers
solr date range issue
I have solr query
I have list of dateTimeStamp i.e user_input_datetimeList which I want to check lying in indexed data i.e indexed_datetime_range_List eg
indexed_datetime_range_List:["2021-08-27T00:00:00Z TO 2021-08-31T00:00:00Z",…

Anshul Verma
- 37
- 6
1
vote
2 answers
Search documents by multiple words query in Solr
I have the documents
[
{ "id": 1, "title": "next notebook" },
{ "id": 2, "title": "next thing" }
]
The title field type is

user13674325
- 339
- 2
- 14
1
vote
0 answers
Solr 7.5 parsing phrase query wrong
Here is the query our code produces when searching for a phone number.
(DOC_DTG:[2010-01-01T00:00:00Z TO 9999-12-31T23:59:59Z] OR (*:* NOT DOC_DTG:[* TO *])) AND "(972) 492 - 5495"
When i run it in the solr ui the area code shows up twice in the…

john
- 11
- 1
1
vote
1 answer
Apache Solr spellCheck polish characters in email
Using solr query to get the emails.
Query returned the keyword like this.
Keyword I am getting ( ±êææ³ñ¶¶¿¼¶ ) and
Required Keywords is ( ąęććłńśśżźś )

Emily
- 33
- 3
1
vote
0 answers
Search for documents that are starting with special word in a Field
I Have an index called Popular Songs and the document type is Song. Each Document has a field called "lyrics" which contains the lyrics of the specific song.
I want to query for all the Songs starting with Word "Love" not the songs content word…

Surath Perera
- 11
- 1
1
vote
0 answers
Apache solr filter based on array values
I have 2 data's which I have mentioned below:
{
id: intro.original
publicationID: TRENTXWB_EM_R1
hasBeenModifiedBy: [DAL]
isModificationFor: null
text: ... intro ...
}
{
id: intro.dal
publicationID: TRENTXWB_EM_R1
…

Praveen Kumar
- 93
- 1
- 8
1
vote
0 answers
SOLR exact match results not matching
Hi I have a text_exact fieldType (field is text_ex) that has KeywordTokenizerFactory for matching against exact queries. For example, searching for sale gives results that contain the term sale, specifically. When I run the query like this…

racsan308
- 31
- 1
- 4
1
vote
2 answers
Solr _ version _ field as a timestamp to query latest results
Can we use Solr _ version _ field as a timestamp/version so that we can query the latest documents from a particular _ version _ /timestamp?
My requirement is to periodically (daily) retrieve new documents from my solr index. But there is no…

Dileepa Jayakody
- 535
- 1
- 6
- 19
1
vote
0 answers
Solr query for topology select by parent
I need select categories for breadcrumbs from solr, where categories will be ordered by parent like this:
Super-parent > Child A of super-parent > Child B of child A > ...
So for instance this is our solr documents:
[
{
"parent_id": 2222,
…

Denis Stephanov
- 4,563
- 24
- 78
- 174
1
vote
1 answer
Solr Boost-Function on Sales
I am using Apache Solr 8 with products as documents. Each document includes sales within the last X days that I want to boost, as well as a title and other fields.
Say productA has been sold 5 times, I want to boost it with score+10; a productB has…

theNick
- 31
- 3
1
vote
1 answer
Solr query field fallback
I have the following fields indexed in Solr:
FIELD_1
FIELD_2
FIELD_3
I would like to search for a document where FIELD_3=X but if FIELD_3 is empty (or non existent in the document), to search in FIELD_2, and then in FIELD_1
Is this kind of query…

Simo L.
- 321
- 1
- 3
- 20
1
vote
1 answer
Solr Query: If field=value1 exists then return or else return field=value2
I want to do a Apache Solr search that will do the following:
If field=value1 returns anything then return that.
Else if field=value2 returns anything then return that.
Else field=value3 returns anything then return that.
How can I do that? Any…

Sumit
- 856
- 5
- 18
- 38
1
vote
0 answers
Solr display document in nested with n number of level and faceting
I indexed data in solr with 4 level data (nested),
My entities are Products, Category, ProductAttribute and ProductAttributeValue.
I'm using DIH for indexing data.
My data structure is
Type: Product
-- Type: Category
-- Type: ProductAttribute
-- …

Raju Paladiya
- 778
- 2
- 12
- 35