You can add a ~3 to the query to allow the order to be reversed, but you
will get extra hits. Maybe it is a ~4, i can never remember on phrases and
reversals. I usually just try it.
Alternatively, you can create a custom query field for what you need from
dates. For example, if you want to sear
What field types are you using for your dates?
Have a look at:
https://cwiki.apache.org/confluence/display/solr/Working+with+Dates
On Thu, Aug 17, 2017 at 10:08 AM, Nawab Zada Asad Iqbal
wrote:
> Hi Krishna
>
> I haven't used date range queries myself. But if Solr only supports a
> particular da
Hi Krishna
I haven't used date range queries myself. But if Solr only supports a
particular date format, you can write a thin client for queries, which will
convert the date to solr's format and query solr.
Nawab
On Thu, Aug 17, 2017 at 7:36 AM, chiru s wrote:
> Hello guys
>
> I am working on
Hello guys
I am working on Apache solr and I am stuck with a use case.
The input data will be in the documents like 2017/03/15 in 1st document,
2017/04/15 in 2nd doc,
2017/05/15 in 3rd doc,
2017/06/15 in 4th doc so on
But while fetching the data it should fetch like 03/15/2017 for the first
On 2/2/2017 6:16 AM, deepak.gha...@mediawide.com wrote:
> I am writting query for getting response from specific index content first.
> eg.
> http://192.168.200.14:8983/solr/mypgmee/select?q=*blood*&fq=id:(*/939/* OR
> **)&fl=id&wt=json&indent=true
>
> In above query I am getting response, Means
Hello Sir,
I am writting query for getting response from specific index content first.
eg.
http://192.168.200.14:8983/solr/mypgmee/select?q=*blood*&fq=id:(*/939/* OR
**)&fl=id&wt=json&indent=true
In above query I am getting response, Means suppose I Get 4 result for course
"939" out of 10. It
I think this will work. Ill try it tomorrow and let you know.
Thanks for the help Eric and Shawn
Kris
-Original Message-
From: Erik Hatcher [mailto:erik.hatc...@gmail.com]
Sent: Thursday, December 8, 2016 2:43 PM
To: solr-user@lucene.apache.org
Subject: Re: prefix query help
It’s hard
nd 6
>
> yes I know its wonky but its what I have to deal with until he content is
> cleaned up.
> I cant use date type.. that would make my life to easy.
>
> TIA again
> Kris
>
> - Original Message -
>
> From: "Erik Hatcher"
> To: solr-user@luce
its wonky but its what I have to deal with until he content is
cleaned up.
I cant use date type.. that would make my life to easy.
TIA again
Kris
- Original Message -
From: "Erik Hatcher"
To: solr-user@lucene.apache.org
Sent: Thursday, December 8, 2016 12:36:26 PM
Sub
On 12/8/2016 10:02 AM, KRIS MUSSHORN wrote:
>
> Here is how I have the field defined... see attachment.
You're using a tokenized field type.
For the kinds of queries you asked about here, you want to use StrField,
not TextField -- this type cannot have an analysis chain and indexes to
one token t
Kris -
To chain multiple prefix queries together:
q=({!prefix f=field1 v=‘prefix1'} {!prefix f=field2 v=‘prefix2’})
The leading paren is needed to ensure it’s being parsed with the lucene qparser
(be sure not to have defType set, or a variant would be needed) and that allows
multiple {!…}
Here is how I have the field defined... see attachment.
- Original Message -
From: "Erick Erickson"
To: "solr-user"
Sent: Thursday, December 8, 2016 10:44:08 AM
Subject: Re: prefix query help
You'd probably be better off indexing it as a
You'd probably be better off indexing it as a "string" type given your
expectations. Depending on the analysis chain (do take a look at
admin/analysis for the field in question) the tokenization can be tricky
to get right.
Best,
Erick
On Thu, Dec 8, 2016 at 7:18 AM, KRIS MUSSHORN wrote:
> Im ind
Im indexing data from Nutch into SOLR 5.4.1.
I've got a date metatag that I have to store as text type because the data
stinks.
It's stored in SOLR as field metatag.date.
At the source the dates are formatted (when they are entered correctly ) as
-MM-DD
q=metatag.date:2016-01* does not
I am trying write query to get below stats for orders data
Find Total Order Count, sum(Quantity) and sum(Cost) for specified date
range in a gap of 1 day. example if date range is for 10 days then get
these result for every day for 10 days.
Solr Version : 5.2.1
Example Order Solr Doc
2014-09-
...@gmail.com]
Sent: Friday, January 23, 2015 9:57 PM
To: solr-user@lucene.apache.org
Subject: Re: Solr regex query help
Right. As I mentioned on the original JIRA, the regex match is happening on
_terms_.
You are conflating the original input (the entire field) with the individual
terms that the regex is
If you make your field type "string" the regex may work as expected.
But as others said, splitting into separate fields is likely more flexible.
Erik
> On Jan 23, 2015, at 23:58, Arumugam, Suresh wrote:
>
> Hi All,
>
> We have indexed the documents to Solr & not able to query using t
When I first read your post I thought this example had something to do with
"pipe", but now I realize that "::PIPE::" is simply a symbolic
representation of what we software people call a "pipe", namely the
vertical bar character used as a field separator. Usually, terms and tokens
are all of the s
Right. As I mentioned on the original JIRA, the regex match is happening on
_terms_.
You are conflating the original input (the entire field) with the
individual terms that the
regex is applied to.
I suggest that you look at the admin/analysis page. There you'll see the
terms that are
indexed and
Hi All,
We have indexed the documents to Solr & not able to query using the Regex.
Our data looks like as below in a Text Field, which is indexed using the
ClassicTokenizer.
1b ::PIPE:: 04/14/2014 ::PIPE:: 01:32:48 ::PIPE:: BMC
Power/Reset action ::PIPE:: Delayed shutdown time
ance and so the shop
> is
> within delivery range of the location specified.
>
> smsolr
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Need-solr-query-help-tp4061800p4062603.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
nal Message- From: Arun Rangarajan Sent: Monday, May 13,
> 2013 4:11 PM To: solr-user@lucene.apache.org Subject: Solr Boolean query
> help
> I am trying to form a Solr query. Our documents have a multi-valued field
> named tag_id. I want to get documents that either do not have tag_id 1
Pure negative queries only work at the top level.
So, try:
q=(tag_id:(1 AND 2) OR tag_id:(*:* NOT 1))
-- Jack Krupansky
-Original Message-
From: Arun Rangarajan
Sent: Monday, May 13, 2013 4:11 PM
To: solr-user@lucene.apache.org
Subject: Solr Boolean query help
I am trying to
Inner purely negative clauses aren't allowed by Lucene. (Solr supports
top-level negative clauses, though, so works as expected)
To get a nested negative clause to work, try this:
q=tag_id:(1 AND 2) OR (*:* AND -tag_id:1)
On May 13, 2013, at 16:11 , Arun Rangarajan wrote:
> I am trying
I am trying to form a Solr query. Our documents have a multi-valued field
named tag_id. I want to get documents that either do not have tag_id 1 or
have both tag_id 1 and 2 i.e.
q=(tag_id:(1 AND 2) OR tag_id:(NOT 1))
This is not giving the desired results. The result is the same as that of
q=tag_i
cene.472066.n3.nabble.com/Need-solr-query-help-tp4061800p4062603.html
Sent from the Solr - User mailing list archive at Nabble.com.
ete all shops so you can edit the file to play with it and repost the
shops:-
http://localhost:8983/solr/update?stream.body=name:shop&commit=true
smsolr
--
View this message in context:
http://lucene.472066.n3.nabble.com/Need-solr-query-help-tp4061800p4062591.html
Sent from the So
We are doing spatial search. with following logic.
a) There are shops in a city . Each provides the facility of home delivery
b) each shop has different max_delivery_distance .
Now my query is suppose some one is searching from point P1 with radius R.
User wants the result of shops those can del
: András Bártházi
Sent: Tuesday, May 15, 2012 6:50 AM
To: solr-user@lucene.apache.org
Subject: Re: simple query help
Hi,
You should use parantheses, have you tried that?
q=(skcode:2021051 and flength:368.0) or (skcode:2021049 and
ent_no:1040970907)
http://robotlibrarian.billdueber.com/solr-and
Kirk
Sent: Tuesday, May 15, 2012 8:23 AM
To: solr-user@lucene.apache.org
Subject: RE: simple query help
Hi
If I understand the terms correctly, the search-handler was configured to
use "edismax".
The start of the configuration in the solrconfig.xml looks like this:
edismax
> But whether or not it was simply the act of restarting - I'm
> not sure. (I had also found out that "AND " and "OR" should
> be written in uppercase, but this made no difference until
> after I had restarted).
By the way, there is a control parameter for this.
"lowercaseOperators A Boolean
around is to place a space
between the left parenthesis and the field name.
See:
https://issues.apache.org/jira/browse/SOLR-3377
-- Jack Krupansky
-Original Message-
From: Peter Kirk
Sent: Tuesday, May 15, 2012 7:04 AM
To: solr-user@lucene.apache.org
Subject: RE: simple query help
ter
-Original Message-
From: Ahmet Arslan [mailto:iori...@yahoo.com]
Sent: 15. maj 2012 13:25
To: solr-user@lucene.apache.org
Subject: RE: simple query help
> It doesn't make a difference. But now I'm thinking there's something
> completely odd - and I wonder if it'
Hi,
it is AND (uppercase) not and (smallcase) (and OR instead of or).
Regards,
Peter
2012/5/15 András Bártházi :
> Hi,
>
> You should use parantheses, have you tried that?
> q=(skcode:2021051 and flength:368.0) or (skcode:2021049 and
> ent_no:1040970907)
>
> http://robotlibrarian.billdueber.com/
> It doesn't make a difference. But now I'm thinking there's
> something completely odd - and I wonder if it's necessary to
> use a special search-handler to achieve what I want.
>
> For example, if I execute
> q=(skcode:2021051 AND flength:368.0)
>
> I get no results. If I omit the parentheses
er@lucene.apache.org
Subject: Re: simple query help
Hi,
You should use parantheses, have you tried that?
q=(skcode:2021051 and flength:368.0) or (skcode:2021049 and
ent_no:1040970907)
http://robotlibrarian.billdueber.com/solr-and-boolean-operators/
Bye,
Andras
2012/5/15 Peter Kirk
> Hi
>
Hi,
You should use parantheses, have you tried that?
q=(skcode:2021051 and flength:368.0) or (skcode:2021049 and
ent_no:1040970907)
http://robotlibrarian.billdueber.com/solr-and-boolean-operators/
Bye,
Andras
2012/5/15 Peter Kirk
> Hi
>
> Can someone please give me some help with a simple q
Hi
Can someone please give me some help with a simple query.
If I search
q=skcode:2021051 and flength:368.0
I get 1 document returned (doc A)
If I search
q=skcode:2021049 and ent_no:1040970907
I get 1 document returned (doc B)
But if I search
q=skcode:2021051 and flength:368.0 or skcode:2021
> b) As i have explained i have result set( documents ) and
> each document
> contains a fields "*ad_text*" (with other fields also) which
> is
> multivalued..storing some tags say "B1, B2, B3" in each. bt
> order of tags
> are different for each doc. say (B1, B2, B3) *for
> doc1*, B3,B1 B2*, for
Boosting won't help either I don't think. Boosts apply to the
document, and pretty much ignore position information.
Best
Erick
On Thu, Mar 29, 2012 at 2:07 PM, Abhishek tiwari
wrote:
> can i achieve this with help of boosting technique ?
>
> On Thu, Mar 29, 2012 at 10:42 PM, Erick Erickson
>
can i achieve this with help of boosting technique ?
On Thu, Mar 29, 2012 at 10:42 PM, Erick Erickson wrote:
> Solr doesn't support sorting on multValued fields so I don't think this
> is possible OOB.
>
> I can't come up with a clever indexing solution that does this either,
> sorry.
>
> Best
>
Solr doesn't support sorting on multValued fields so I don't think this
is possible OOB.
I can't come up with a clever indexing solution that does this either, sorry.
Best
Erick
On Thu, Mar 29, 2012 at 8:27 AM, Abhishek tiwari
wrote:
> a) No. i do not want to sort the content within document .
a) No. i do not want to sort the content within document .
I want to sort the documents .
b) As i have explained i have result set( documents ) and each document
contains a fields "*ad_text*" (with other fields also) which is
multivalued..storing some tags say "B1, B2, B3" in each. bt order of tags
Hmmm, I don't quite get this. Are you saying that you want
to sort the documents or sort the content within the document?
Sorting documents (i.e the results list) requires a single-valued
field. So you'd have to, at index time, sort the entries.
Sorting the content within the document is somethin
Hi ,
i have multi valued field want to sort the docs order the particular
text eq:'B1' is added.
how i should query? ad_text is multivalued field.
t
B1
B2
B3
B2
B1
B3
B1
B2
B3
B3
B2
B1
See "Tagging and excluding Filters" section
*
http://wiki.apache.org/solr/SimpleFacetParameters#Tagging_and_excluding_Filters
2011/6/6 Denis Kuzmenok :
> For now i have a collection with:
> id (int)
> price (double) multivalue
> brand_id (int)
> filters (string) multivalue
>
> I need to get a
For now i have a collection with:
id (int)
price (double) multivalue
brand_id (int)
filters (string) multivalue
I need to get available brand_id, filters, price values and list of
id's for current query. For example now i'm doing queries with
facet.field=brand_id/filters/price:
1) to ge
--- On Thu, 11/25/10, Himanshu Tatariya wrote:
> From: Himanshu Tatariya
> Subject: About Solr Query help
> To: solr-user@lucene.apache.org
> Date: Thursday, November 25, 2010, 4:02 PM
> Hello,
>
> Greetings !
>
> I am working on one project which is used solr sea
Hello,
Greetings !
I am working on one project which is used solr search facilities and its
is good for searching and indexing it. I have one query regarding
searching facets, so please guide me.
I search color just for example :
"*attr_color_sm:blue*" which i send in query but now I want p
wrote:
> >
> > Your example though doesn't show different ContentType, it shows a
> different
> > sort order. That would be difficult to achieve in one call. Sounds like
> your
> > best bet is asynchronous (multi-threaded) calls if your architecture will
&
27;t show different ContentType, it shows a different
> sort order. That would be difficult to achieve in one call. Sounds like your
> best bet is asynchronous (multi-threaded) calls if your architecture will
> allow for it.
> --
> View this message in context:
> http://lucene.472066
72066.n3.nabble.com/Query-help-tp969075p969334.html
Sent from the Solr - User mailing list archive at Nabble.com.
Hello, I hope someone can help me with this. I have a website which is
built on top of Solr and the home page is composed of 4 sections one
for each type of content on the site.
At the moment to populate this page, I am using 4 separate queries of the form:
?q=ContentType:News&sort=DatePublished+d
Avlesh, thanks those worked, for somre reason I never got your mail,
found it in one of the list archives though.
thanks again
Joel
On Nov 5, 2009, at 9:08 PM, Avlesh Singh wrote:
Didn't the queries in my reply work?
Cheers
Avlesh
On Fri, Nov 6, 2009 at 4:16 AM, Joel Nylund wrote:
Hi yes
Didn't the queries in my reply work?
Cheers
Avlesh
On Fri, Nov 6, 2009 at 4:16 AM, Joel Nylund wrote:
> Hi yes its a string, in the case of a title, it can be anything, a letter a
> number, a symbol or a multibyte char etc.
>
> Any ideas if I wanted a query that was not a letter a-z or a number
Hi yes its a string, in the case of a title, it can be anything, a
letter a number, a symbol or a multibyte char etc.
Any ideas if I wanted a query that was not a letter a-z or a number
0-9, given that its a string?
thanks
Joel
On Nov 4, 2009, at 9:10 AM, Jonathan Hendler wrote:
Hi Joel,
Hi Joel,
The ID is sent back as a string (instead of as an integer) in your
example. Could this be the cause?
- Jonathan
On Nov 4, 2009, at 9:08 AM, Joel Nylund wrote:
Hi, I have a field called firstLetterTitle, this field has 1 char,
it can be anything, I need help with a few queries on
Hi, I have a field called firstLetterTitle, this field has 1 char, it
can be anything, I need help with a few queries on this char:
1.) I want all NON ALPHA and NON numbers, so any char that is not A-Z
or 0-9
I tried:
http://localhost:8983/solr/select?q=NOT%20firstLetterTitle:0%20TO%209%20
: the original pastie(http://pastie.org/650932). I tried the fq query body with
: quotes and without quotes.
the entire fq param shouldn't be in quotes ... just the value that you
want to query on (since it's a string field and you want the whole field
treated as a single string...
fq =
ok, so fq != facet.query. i thought it was an alias. I'm trying your
suggestion fq=Memory_s:"1 GB" and now it's returning zero documents even
though there is one document that has "tommy" and "Memory_s:1 GB" as
seen in the original pastie(http://pastie.org/650932). I tried the fq
query body wit
On Mon, Oct 12, 2009 at 6:07 AM, Tommy Chheng wrote:
> The dummy data set is composed of 6 docs.
>
> My query is set for 'tommy' with the facet query of Memory_s:1+GB
>
> http://lh:8983/solr/select/?facet=true&facet.field=CPU_s&facet.field=Memory_s&facet.field=Video+Card_s&wt=ruby&facet.query=Memo
The dummy data set is composed of 6 docs.
My query is set for 'tommy' with the facet query of Memory_s:1+GB
http://lh:8983/solr/select/?facet=true&facet.field=CPU_s&facet.field=Memory_s&facet.field=Video+Card_s&wt=ruby&facet.query=Memory_s:1+GB&q=tommy&indent=on
However, in the response (http://
hanks guys!
- Original Message
From: Erik Hatcher
To: solr-user@lucene.apache.org
Sent: Tuesday, August 25, 2009 11:26:58 AM
Subject: Re: Solr Query help - sorting
If you're using DataImportHandler, a custom (Java or script)
transformer could do this.
Also an UpdateProcessor could do it
I can because the app
and db that Solr is indexing are not really the best place to add
this type of functionality.
- Original Message
From: Koji Sekiguchi
To: solr-user@lucene.apache.org
Sent: Tuesday, August 25, 2009 4:04:29 AM
Subject: Re: Solr Query help - sorting
Hi E
ality.
- Original Message
From: Koji Sekiguchi
To: solr-user@lucene.apache.org
Sent: Tuesday, August 25, 2009 4:04:29 AM
Subject: Re: Solr Query help - sorting
Hi Erik Earle,
Ahh, I read your mail too fast... Erik Hatcher's method should work.
Thanks!
Koji
Erik Hatcher wrote:
> You could
Hi Erik Earle,
Ahh, I read your mail too fast... Erik Hatcher's method should work.
Thanks!
Koji
Erik Hatcher wrote:
You couldn't sort on a multiValued field though.
I'd simply index a max_side field, and have the indexing client add a
single valued field with max(length,width) to it. The
You couldn't sort on a multiValued field though.
I'd simply index a max_side field, and have the indexing client add a
single valued field with max(length,width) to it. Then sort on
max_side.
Erik
On Aug 25, 2009, at 4:00 AM, Constantijn Visinescu wrote:
make a new multivalued fi
make a new multivalued field in your schema.xml, copy both width and length
into that field, and then sort on that field ?
On Tue, Aug 25, 2009 at 5:40 AM, erikea...@yahoo.com wrote:
> Clever... but if more than one row adds up to the same value I may get the
> wrong order (like 50, 50 and 10, 90
Clever... but if more than one row adds up to the same value I may get the
wrong order (like 50, 50 and 10, 90)
I need a max function but the one provided only compares against a constant.
Sent from my iPhone
On Aug 24, 2009, at 6:15 PM, Koji Sekiguchi wrote:
How about using sum() FunctionQu
How about using sum() FunctionQuery, via:
http://localhost:8983/solr/select/?q=_val_%3A%22sum%28width%2Clength%29%22
Thanks,
Koji
Erik Earle wrote:
Suppose I have a database of rectangle attributes that I have indexed in Solr
and I want to get the top 10 widest or longest rectangles from on
Suppose I have a database of rectangle attributes that I have indexed in Solr
and I want to get the top 10 widest or longest rectangles from one query.
name | width | length
A | 100| 10
B | 10 | 90
C | 80 | 10
...
My indexed fields are: name, width, length
I
71 matches
Mail list logo
