Questions tagged [solr-query-syntax]
175 questions
0
votes
1 answer
How to nested sort in solr query?
Assume I have field and value like
Field : value
sku : xxx
Seller : true
Name : "Elux"
query will be like
sku:"xxx"
within this result I need to sort the products with Name (Elux) in the top with seller (true) top
and within that I need the…
pradeep murugan
- 531
- 1
- 9
- 18
0
votes
1 answer
How to add a boost query using SolrQuery
I am using SolrClient to connect with the database and following the example from https://www.php.net/manual/en/book.solr.php
I am trying to generate the query which I created through the dashboard of…
Abhilash Cherukat
- 65
- 8
0
votes
0 answers
Solr 6.6 + highlight stem of word
I'm pretty new to Solr. I was reading the Solr highlighting documentation to discover whether there's a way, in the returned results, to highlight the stems of words that would be returned in an analysis query, but I was not able to find anything…
GLaDOS
- 683
- 1
- 14
- 29
0
votes
1 answer
Sort Based on the top 100 records Solr
This is not same as the below:
How to sort the top 100 results of solr query based on a specific filed?
Suppose my search criteria title:Building the Nation returns 100k results. I guess Solr already returns data based on the best match i.e best…
Sumit
- 856
- 5
- 18
- 38
0
votes
2 answers
Solr return stats and exclude values that equal zero
Im not sure if its possible as I am currently learning Solr and am very much a novice. I am querying a dataset with a few hundred thousand pieces to it and I'm returning the stats on the price of those sets. Most of my data has a price that is well…
McMuffin
- 1
0
votes
1 answer
Passing a variable in a solr auery
I'm working with solr using r library solrium
After the connection to solr in the variable conn1, I make queries like this:
solr_search(conn1,"collection_name", params = list(q = "price:1000",start = 0, rows = 20000,fl=c('column_name')))
But…
Khalid Askia
- 33
- 1
- 8
0
votes
0 answers
Solr grouping results
So I have a solr result with the following JSON:
{
"grouped": {
"manu_exact": {
"matches": 2,
"groups": [
{
"groupValue": "SOLR1000",
"doclist": {
"numFound": 2,
"start": 0,
…
Anirudha Nanda
- 43
- 1
- 8
0
votes
0 answers
Solr Join query to combine two queries
My first Solr query is:
http://localhost:8983/solr/test/select?q=id:idval
Using the result(only 1 result is returned) I get from this query, I take the "latlon" field value(let's call it latlonval from the result and pass it in to the following…
0
votes
1 answer
Solr OR query does not return any result while queries returns result separately
I am trying to run OR query on Solr 6.6 like "field:[x TO ] OR -field:[ TO *]" which means greater than or equal some value or null. Even both field:[x TO ] and -field:[ TO *] has result sets individually this OR query does return empty set. When I…
Abdulkadir Dalga
- 65
- 5
0
votes
1 answer
Solr searching by operator OR
I'm using Apache Solr and I try to find one item by this query:
server_url?debug=true
&defType=edismax
&fq=custom_type:custom
&indent=true
&limit=10
&page=0
&q=custom_words:contact
&wt=json
Where custom_words - It's a type in schema, where I need…
Alex
- 63
- 1
- 10
0
votes
1 answer
Pagination not working while querying multiple solr collecections
I have two collections mdsearch_veevavault and mdsearch_hema
http://rldata:8983/solr/mdsearch_veevavault_shard1_replica1/select?q=%3A&fl=id,desc1&wt=json&indent=true&collection=mdsearch_veevavault,mdsearch_hema&sort=titlesort%20desc,%20id%20asc
When…
Bhuvan
- 104
- 9
0
votes
1 answer
CQL solr-query getting error - cannot pass json query
I'm new to DSE. Working on DSE based queries to get date range
1) select count(1) from tbl where solr_query='code:maf';
It gives the result.
But When I'am trying to use range query is gives error :-
select count(1) from tbl where…
jAi
- 115
- 1
- 14
0
votes
2 answers
Solr 6.6.0 Case Insensitive Query Not Working
Solr 6.6.0 Case Insensitive Query Not Working.
I had tried all other option/answer available on internet.
I had tired with,
Kiran
- 1,176
- 2
- 14
- 27
0
votes
1 answer
SQL Server query - Correction in syntax
Could you please help me to correct the syntax ?
I have to write below code in SQL server.
This is working perfectly fine in Oracle database.
Select to_number(substr((((END_TS - BEGIN_TS)*(24*60*60))),1,10)) AS EXECUTION_TIME
from TABLE B
Also…
Jocky
- 25
- 4
0
votes
1 answer
Unable to understand boost function solr query
I am new to solr and trying to understand how boost function works.
Below in an existing query -
…
Vibhav Singh Rohilla
- 760
- 1
- 5
- 17