Re: sorting help

2020-07-15 Thread Dave
That’s a good place to start. The idea was to make sure titles that started with a date would not always be at the forefront and the actual title of the doc would be sorted. > On Jul 15, 2020, at 4:58 PM, Erick Erickson wrote: > > Yeah, it’s always a question “how much is enough/too much”. >

Re: sorting help

2020-07-15 Thread Erick Erickson
Yeah, it’s always a question “how much is enough/too much”. That looks reasonable for alphatitle, but what about title? Your original question was that the sorting changes depending on which field you sort on. If your title field uses something that tokenizes or doesn’t include the same analysis

Re: sorting help

2020-07-15 Thread David Hastings
thanks, ill check the admin, didnt want to send a big clock of text but: - - Tokenizer: org.apache.lucene.analysis.core.KeywordTokenizerFactoryclass: solr.KeywordTokenizerFactoryluceneMatchVersion: 7.1.0 - Token Filters: org.apache.lucene.analysis.co

Re: sorting help

2020-07-15 Thread Erick Erickson
I’d look two places: 1> try the admin/analysis page from the admin UI. In particular, look at what tokens actually get in the index. 2> again, the admin UI will let you choose the field (alphatitle and title) and see what the actual indexed tokens are. Both have the issue that I don’t know wha

Re: Sorting in other collection in Solr 8.5.1

2020-06-24 Thread vishal patel
p://aka.ms/weboutlook> From: vishal patel Sent: Wednesday, June 24, 2020 1:33 PM To: solr-user@lucene.apache.org Subject: Re: Sorting in other collection in Solr 8.5.1 My listing looks like : https://drive.google.com/file/d/1Pw94topEJfarEA_P5JeiDOsHlvyACPK0/view ID

Re: Sorting in other collection in Solr 8.5.1

2020-06-24 Thread vishal patel
ot;project_id":"102579" } As of now one form has only one action but possible one form has many actions. For getting listing of project_id:102578, First we sort in ascending in actionscomments with field title so we get form_id in order 10252141 and 10252140. Base on that ord

Re: Sorting in other collection in Solr 8.5.1

2020-06-23 Thread Erick Erickson
You have two separate collections with dissimilar data, so what does “sorting them in the same order” mean? Your example sorts on title, so why can’t you sort them both on title? That won’t work of course for any field that isn’t identical in both collections. These are actually pretty small colle

Re: Sorting in other collection in Solr 8.5.1

2020-05-23 Thread Zheng Lin Edwin Yeo
Hi Vishal, Maybe you can post your query that you are using which has the issue too. Regards, Edwin On Sat, 23 May 2020 at 22:27, vishal patel wrote: > Hi > > I am upgrading Solr 8.5.1. I have created 2 shards and each has one > replica. > I have created 2 collection one is form and second is

Re: Sorting on an empty filter

2020-03-11 Thread Stephen Lewis Bianamara
Hi Folks, Has anyone had a chance to consider this question yet? Thanks! Stephen On Tue, Mar 3, 2020 at 2:28 PM Stephen Lewis Bianamara < stephen.bianam...@gmail.com> wrote: > Hi SOLR Community, > > I've observed while hosting a SOLR 6.6 installation that if I issue a > query where the filter q

Re: sorting groups on the basis of average of a field in documents

2020-01-13 Thread Saurabh Sharma
Hi Erick, I am using json facets and was able to achieve desired result using them. I was looking for some possibilities for same in groups. Doing it using json facets is last option. Thank Saurabh Sharma On Mon, Jan 13, 2020, 7:17 PM Erick Erickson wrote: > This might help: > https://lucene

Re: sorting groups on the basis of average of a field in documents

2020-01-13 Thread Erick Erickson
This might help: https://lucene.apache.org/solr/guide/7_4/json-facet-api.html basically, if you can construct facets that correspond to your groups, you can do some statistical functions on them. Best, Erick > On Jan 13, 2020, at 2:18 AM, Saurabh Sharma > wrote: > > Hi All, > > I have a requ

Re: Sorting based on Date and Name combination in Solr 6.2

2019-07-10 Thread Santosh Kumar S
Thank you Shawn for your prompt response. However we have that option open of having a separate date only field or a separate field with date along with default Timestamp like you mentioned (00:00:00.000). But this change shall need a full-import or full crawl, as we lot many data, we looking o

Re: Sorting based on Date and Name combination in Solr 6.2

2019-07-10 Thread Santosh Kumar S
Thank you Shawn for your prompt response. However we have that option open of having a separate date only field or a separate field with date along with default Timestamp like you mentioned (00:00:00.000). But this change shall need a full-import or full crawl, as we lot many data, we looking out a

Re: Sorting based on Date and Name combination in Solr 6.2

2019-07-10 Thread Shawn Heisey
On 7/10/2019 7:22 AM, Santosh Kumar S wrote: When we try sorting it, then the records are getting sorted based on Timestamp, but we need to sort only on date part keeping timestamp part aside. That is how sorting on a field that has a timestamp is going to work. It will always use the whole fi

Re: Sorting of solr.CurrencyFieldType in 7.3.1

2018-10-30 Thread Erick Erickson
Chris: Please follow the instructions here: http://lucene.apache.org/solr/community.html#mailing-lists-irc. You must use the _exact_ same e-mail as you used to subscribe. If the initial try doesn't work and following the suggestions at the "problems" link doesn't work for you, let us know. But no

Re: Sorting of solr.CurrencyFieldType in 7.3.1

2018-10-30 Thread Chris Gerke
UNSUBSCRIBE On Tue, 30 Oct 2018 at 8:24 pm, Stefan Kuhn wrote: > Hi, > > last week I found an error in the result sorting regarding a field of the > type "solr.CurrencyFieldType" in solr version 7.3.1. > > There are multiple documents which I must sort with this field, but the > order of the res

Re: Sorting multi-valued fields

2018-09-14 Thread Shawn Heisey
On 9/14/2018 4:50 AM, richard.clarke wrote: What does it mean to sort documents by a multivalued field? If a field has multiple values, how can this be used to sort documents? e.g. if document 1 has a numeric field containing values 1,2,3,4,5 and document 2 has values in the same field of 1,2,3

Re: Sorting multi-valued fields

2018-09-14 Thread Mikhail Khludnev
http://people.apache.org/~mkhl/searchable-solr-guide-7-3/common-query-parameters.html#sort-parameter In the case of primitive fields, or SortableTextFields, that are multiValued="true" the representative value used for each doc when sorting depends on the sort direction: The minimum value in each d

Re: Sorting by custom order

2018-09-01 Thread Walter Underwood
Use a enum field. Those are designed to map arbitrary values to a sort order. The standard example is to apply an order to something that isn’t alpha like: Error, Warning, Info. https://lucene.apache.org/solr/guide/6_6/working-with-enum-fields.html Enums convert an ordered set into a numeric sort

Re: Sorting by custom order

2018-09-01 Thread Shawn Heisey
On 9/1/2018 12:36 AM, Salvo Bonanno wrote: I need to sort a results set in a particolar way... the documents looks like this: There are two problems with what you want and your setup. I need to sort them by profile_txt value (it's a multiValue field but actually it contains just a single valu

Re: Sorting issue while using collection parameter

2018-07-20 Thread Erick Erickson
Just tried this on master and can't reproduce. Didn't try 5.4. Any chance this is a multiValued field? That can sometimes confuse things. Best, Erick On Fri, Jul 20, 2018 at 2:50 AM, Vijay Tiwary wrote: > Hello Erick > > We are using string field and data is stored in lower case while indexing

Re: Sorting issue while using collection parameter

2018-07-20 Thread Vijay Tiwary
Hello Erick We are using string field and data is stored in lower case while indexing. We have alias set up to query multiple collections simultaneously. alias=collection1, collection2 If we are querying through alias then sorting is broken. For e.g. Results for descending sort are as follows. (Em

Re: Sorting and pagination in Solr json range facet

2018-07-11 Thread simon
Looking carefully at the documentation for JSON facets, it looks as though the offset parameter is not supported for range facets, only for term facets. You'd have to do pagination in your application. -Simon On Tue, Jul 10, 2018 at 11:45 AM, Anil wrote: > HI Eric, > > i mean pagination is off

Re: Sorting and pagination in Solr json range facet

2018-07-10 Thread Anil
HI Eric, i mean pagination is offset and limit for facet results. Basically i am trying to sort the daily totals (from json facet field) and apply offset, limit to the buckets. json.facet= { daily_totals: { type: range, field: daily_window, start : "2017-11-01T00:00:00

Re: Sorting and pagination in Solr json range facet

2018-07-10 Thread Erick Erickson
What exactly do you mean by "pagination" here? Facets are computed over the entire result set. That is, if the number of documents found for the query is 1,000,000, the facets are returned counted over all 1M docs, even if your rows parameter is 10. The same numbers will be returned for facets rega

Re: Sorting issue while using collection parameter

2018-06-29 Thread Erick Erickson
What _is_ your expectation? You haven't provided any examples of what your input and expectations _are_. You might review: https://wiki.apache.org/solr/UsingMailingLists string types are case-sensitive for instance, so that's one thing that could be happening. You can also specify sortMissingFirs

Re: Sorting issue while using collection parameter

2018-06-29 Thread Vijay Tiwary
Hello Eric, title is a string field On Wed, 27 Jun 2018, 9:21 pm Erick Erickson, wrote: > what kind of field is title? text_general or something? Sorting on a > tokenized field is usually something you don't want to do. If a field > has aardvard and zebra, how would it sort? > > There's usually

Re: Sorting issue while using collection parameter

2018-06-27 Thread Erick Erickson
what kind of field is title? text_general or something? Sorting on a tokenized field is usually something you don't want to do. If a field has aardvard and zebra, how would it sort? There's usually something like alphaOnlySort. People often copyField from "title" to "title_sort" and search on "tit

Re: Sorting on ip address

2018-06-18 Thread David Hastings
sorry, I mean to an ip adress as a numeric value, example in MySQL: https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html#function_inet-aton On Mon, Jun 18, 2018 at 12:35 PM, root23 wrote: > I am sorry i am not sure what you mean by store as atom. Is that an > fieldType > in solr

Re: Sorting on ip address

2018-06-18 Thread root23
I am sorry i am not sure what you mean by store as atom. Is that an fieldType in solr ? I couldnt find it in here https://lucene.apache.org/solr/guide/6_6/field-types-included-with-solr.html -- Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Re: Sorting on ip address

2018-06-18 Thread Dave
Store it as an atom rather than an up address. > On Jun 18, 2018, at 12:14 PM, root23 wrote: > > Hi all, > is there a built in data type which i can use for ip address which can > provide me sorting ip address based on the class? if not then what is the > best way to sort based on ip address ?

Re: Sorting on pseudo field(The one which is added during doctransformer)

2018-05-23 Thread prateek . agarwal
Thanks, Mikhail On 2018/05/18 11:33:09, Mikhail Khludnev wrote: > Right > https://wiki.apache.org/solr/SolrPlugins#ValueSourceParser > > On Fri, May 18, 2018 at 8:04 AM, prateek.agar...@bigbasket.com < > prateek.agar...@bigbasket.com> wrote: > > > Hi Mikhail, > > > > I think you forgot to link

Re: Sorting on pseudo field(The one which is added during doctransformer)

2018-05-18 Thread Mikhail Khludnev
Right https://wiki.apache.org/solr/SolrPlugins#ValueSourceParser On Fri, May 18, 2018 at 8:04 AM, prateek.agar...@bigbasket.com < prateek.agar...@bigbasket.com> wrote: > Hi Mikhail, > > I think you forgot to link the reference. > > Thanks > > > Regards, > Prateek > > On 2018/05/17 13:18:22, Mikha

Re: Sorting on pseudo field(The one which is added during doctransformer)

2018-05-18 Thread prateek . agarwal
Hi Mikhail, I think you forgot to link the reference. Thanks Regards, Prateek On 2018/05/17 13:18:22, Mikhail Khludnev wrote: > Here is the reference I've found so far. > > On Thu, May 17, 2018 at 12:26 PM, prateek.agar...@bigbasket.com < > prateek.agar...@bigbasket.com> wrote: > > > > > H

Re: Sorting on pseudo field(The one which is added during doctransformer)

2018-05-17 Thread Mikhail Khludnev
Here is the reference I've found so far. On Thu, May 17, 2018 at 12:26 PM, prateek.agar...@bigbasket.com < prateek.agar...@bigbasket.com> wrote: > > Hi Mikhail, > > > You can either sort by function that needs to turn the logic into value > > source parser. > > But like my requirement for this wa

Re: Sorting on pseudo field(The one which is added during doctransformer)

2018-05-17 Thread prateek . agarwal
Hi Mikhail, > You can either sort by function that needs to turn the logic into value > source parser. But like my requirement for this was to add a field dynamically from cache or external source to the returned documents from the solr and perform sorting in the solr itself if required otherw

Re: Sorting on pseudo field(The one which is added during doctransformer)

2018-05-17 Thread Mikhail Khludnev
Prateek, It's too late to sort on transformer result. You can either sort by function that needs to turn the logic into value source parser. If you need to toss just result page, check rerank. On Thu, May 17, 2018 at 10:03 AM, prateek.agar...@bigbasket.com < prateek.agar...@bigbasket.com> wrote:

Re: Sorting using "packed" fields?

2018-04-17 Thread Alessandro Benedetti
Hi Christopher, if you model your documents with a nested document approach ( like the one you mentioned) you should be able to achieve your requirement following this interesting blog [1] : *" ToParentBlockJoinQuery supports several score calculation modes. For example, a score for a parent cou

Re: Sorting results for spatial search

2018-02-01 Thread Leila Deljkovic
Hey David, Thanks for your suggestions! I think I’ve got the right behaviour now; I’ve done fq={!parent which=is_parent:true score=total v='+is_parent:false +{!func}density'} desc instead of sort=… Side note: the grid cells can be POLYGON or MULTIPOLYGON, so BBoxField didn’t work when I tried

Re: Sorting results for spatial search

2018-02-01 Thread David Smiley
quote: "The problem is that this includes children that DON’T touch the search area in the sum. How can I only include the shapes from the first query above in my sort?" Unless I'm misunderstanding your intent, I think this is a simple matter of adding the spatial filter to the parent join query y

Re: Sorting on Child document.

2018-01-03 Thread crezy
Hello All, any updates on my post. It's too much urget. Thanks -- Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Re: Sorting by distance resources with WKT polygon data

2017-09-22 Thread Ere Maijala
Hi, our strategy is to have a separate center coordinate field that we use for sorting. This has the additional benefit that it's possible to have the indexed center point differ from the polygon's centroid, which can be useful e.g. with cities, where the city center can be quite a bit offset

Re: Sorting by distance resources with WKT polygon data

2017-09-19 Thread David Smiley
Hello, Sorry for the belated response. Solr only supports sorting from point or rectangles in the index. For rectangles use BBoxField. For points, ideally use the new LatLonPointSpatialField; failing that use LatLonType. You can use RPT for point data but I don't recommend sorting with it; use

Re: Sorting order of suggested words

2017-01-19 Thread Keiichi MORITA
I found the option `comparatorClass`. https://wiki.apache.org/solr/SpellCheckComponent#Custom_Comparators_and_the_Lucene_Spell_Checkers_.28IndexBasedSpellChecker.2C_FileBasedSpellChecker.2C_DirectSolrSpellChecker.29 If I want to sort suggested words alphabetically, need to set a custom comparator

Re: sorting by date not working on dates earlier than EPOCH

2016-11-14 Thread marotosg
Hi there. I have found a possible solution for this issue. -- View this message in context: http://lucene.472066.n3.nabble.com/sorting-by-date-not-working-on-dates-earlier-than-EPOCH-tp4303456p4305770.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Sorting Problem with custom ValueSourceParser

2016-11-02 Thread Tirthankar
@Rohit you can look into this. http://www.javaworld.com/article/2074996/hashcode-and-equals-method-in-java-object---a-pragmatic-concept.html A good article for hashcode and equals -- View this message in context: http://lucene.472066.n3.nabble.com/Sorting-Problem-with-custom-ValueSourceParser

Re: Sorting Problem with custom ValueSourceParser

2016-10-04 Thread Rohit Agarwal
I tried returning false in equals method but still it has no effect. Btw is there any documentation where i can look at what the functions are used for. I can't find any proper documentation related to it. It is very difficult to guess the usage of the functions. I don't think it will be a good i

Re: Sorting Problem with custom ValueSourceParser

2016-10-04 Thread Rohit Agarwal
Hi Hoss, Thanks for the response. Will make the necessary changes and get back to you. Btw this is just a testing code. The logic is yet to be implemented. What according to you could be the best way to return hashcode? Regards, Rohit On Oct 5, 2016 5:27 AM, "Chris Hostetter" wrote: > > : Eg:

Re: Sorting Problem with custom ValueSourceParser

2016-10-04 Thread Chris Hostetter
: Eg: if i make a query to sort by func(cost) desc : It works. : Now if i change cost with some another field eg func(rating) desc : It sorts the result by cost only. : : Now if i restart the solr server and call sort by func(rating) it works but : now it will stick with rating : : Any idea why

Re: Sorting on DateRangeField?

2016-09-09 Thread David Smiley
Hi Alex, DateRangeField extends some spatial stuff, which has that error message in it, not in DateRangeField proper. You cannot sort on a DateRangeField. If you want to... try adding either one plain docValues field if you just have date instances, or a pair of them to hold a min & max and pick

Re: Sorting on different language fields

2016-08-31 Thread Emir Arnautovic
Ugh... Never used this approach and was thinking that sort can take a function that returns string, but it requires function that returns double so you would need to provide function that returns double representation of string. With such function you could do: sort=if(exists(object_name_fr),

Re: Sorting on different language fields

2016-08-31 Thread Vasu Y
Thank you Emir. That was helpful. I understand that we can make sure all doc have values in all fields at indexing time. But if that's not possible, how can we make sure all docs have values in all fields query time? If we missed to provide value for certain fields at index time, how can we ensure

Re: Sorting on different language fields

2016-08-31 Thread Emir Arnautovic
Hi Vasu, It is expected behavior, and you can control it with sortMissingLast and sortMissingFirst. Here is comment from schema: In any case it does not seem right to me to have results first just because it is declared as French - in some cases it will be same as English version and will

Re: Sorting non-english text

2016-08-25 Thread Vasu Y
Thank you Ahmet. I have couple of questions on using CollationKeyAnalyzer: 1) Is it enough to specify this Analyzer in schema.xml as shown below or do i need to pass any parameters like language etc.? 2) Do we need to define one CollationKeyAnalyzer per language? 3) I also noticed that there is o

Re: Sorting non-english text

2016-08-25 Thread Ahmet Arslan
Hi, I think there is a dedidated fieldType for this: https://cwiki.apache.org/confluence/display/solr/Language+Analysis#LanguageAnalysis-UnicodeCollation Ahmet On Thursday, August 25, 2016 9:08 PM, Vasu Y wrote: Thank you Ahmet. I have couple of questions on using CollationKeyAnalyzer: 1) I

Re: Sorting non-english text

2016-08-25 Thread Ahmet Arslan
Hi Vasu, There is a field type or something like that (CollationKeyAnalyzer) for language specific sorting. Ahmet On Thursday, August 25, 2016 12:29 PM, Vasu Y wrote: Hi, I have a text field which can contain values (multiple tokens) in English; to support sorting, I had in schema.xml to co

Re: Sorting - uppercase value first or lowercase value

2016-07-25 Thread Erick Erickson
Well, since the ascii upper-case codes are smaller than lower case, i.e. A = 0x41 a = 0x61 upper case before lower case is correct IMO. But you're being fooled by the I "tiebreaker" I'd guess, along with (I suppose) a small number of test docs. When two docs have the same sort value, the internal

Re: Sorting in solr

2016-07-11 Thread Erick Erickson
I'm going to be a bit pedantic here since "before" and "after" are a little misleading. Perhaps "during" is better. What happens internally is that a list "rows" long is kept (i..e the &rows=### parameter). Let's say &rows=20. A list to hold 20 items is created. The first 20 docs are just put in t

Re: Sorting in solr

2016-07-11 Thread Dheerendra Kulkarni
Naveen, The documents are sorted before. Lets say if it was a post sort and you are fetching 10 rows it would have pulled up top 10 rows and sorted it. but that is not what happens in solr it sorts in all available docs as per the query and goves the number of rows as per your requirment. Regards

Re: Sorting in solr

2016-07-11 Thread Sandeep Mestry
Hi Naveen, I am not too sure what you're after but the sorting mechanism is applied after search results are fetched. >From Solr Ref Guide: https://cwiki.apache.org/confluence/display/solr/Common+Query+Parameters#CommonQueryParameters-ThesortParameter The sort parameter *arranges search results*

Re: Sorting & searching on the same field

2016-06-24 Thread Jay Potharaju
Thanks Alex, I will check this out. Is it possible to do something at query time , using a function query to lowercase the field and then sort on it.? Jay > On Jun 24, 2016, at 12:03 AM, Alexandre Rafalovitch > wrote: > > Keep voting for SOLR-8362? > > You could do your preprocessing in Upda

Re: Sorting & searching on the same field

2016-06-24 Thread Alexandre Rafalovitch
Keep voting for SOLR-8362? You could do your preprocessing in UpdateRequestProcessor chain. There is nothing specifically for Lower/Upper case, but there is a generic scripting one: http://www.solr-start.com/javadoc/solr-lucene/org/apache/solr/update/processor/StatelessScriptUpdateProcessorFactor

Re: Sorting & searching on the same field

2016-06-23 Thread Jay Potharaju
Any ideas on how to handle case insensitive search, string fields and docvalues in 1 field? On Thu, Jun 23, 2016 at 8:14 PM, Alexandre Rafalovitch wrote: > At least you don't need to store the sort field. Or even index, if it is > docvalues (good for sort). > > Regards, > Alex > On 24 Jun 20

Re: Sorting & searching on the same field

2016-06-23 Thread Alexandre Rafalovitch
At least you don't need to store the sort field. Or even index, if it is docvalues (good for sort). Regards, Alex On 24 Jun 2016 9:01 AM, "Jay Potharaju" wrote: > yes, that is what i thought. but was checking to see if there was something > I was missing. > Thanks > > On Thu, Jun 23, 2016 at

Re: Sorting & searching on the same field

2016-06-23 Thread Jay Potharaju
yes, that is what i thought. but was checking to see if there was something I was missing. Thanks On Thu, Jun 23, 2016 at 12:55 PM, Ahmet Arslan wrote: > Hi Jay, > > I don't think it can be combined. > Mainly because: searching requires a tokenized field. > Sorting requires a single value (token

Re: Sorting & searching on the same field

2016-06-23 Thread Ahmet Arslan
Hi Jay, I don't think it can be combined. Mainly because: searching requires a tokenized field. Sorting requires a single value (token) to be meaningful. Ahmet On Thursday, June 23, 2016 7:43 PM, Jay Potharaju wrote: Hi, I would like to have 1 field that can used for both searching and case i

Re: Sorting documents in one core based on a field in another core

2016-06-01 Thread Mark Robinson
Thanks Mikhail! I will check and get back. Best, Mark On Tue, May 31, 2016 at 4:58 PM, Mikhail Khludnev < mkhlud...@griddynamics.com> wrote: > Hello Mark, > > Is it sounds like what's described at > > http://blog-archive.griddynamics.com/2015/08/scoring-join-party-in-solr-53.html > ? > > On Tue,

Re: Sorting documents in one core based on a field in another core

2016-05-31 Thread Mikhail Khludnev
Hello Mark, Is it sounds like what's described at http://blog-archive.griddynamics.com/2015/08/scoring-join-party-in-solr-53.html ? On Tue, May 31, 2016 at 5:41 PM, Mark Robinson wrote: > Hi, > > I have a requirement to sort records in one core/ collection based on a > field in > another core/c

Re: Sorting documents in one core based on a field in another core

2016-05-31 Thread Mark Robinson
Thanks for the reply Eric! Can we write a custom sort component to achieve this?... I am thinking of normalizing as the last option as clear separation of the cores helps me. Thanks! Mark. On Tue, May 31, 2016 at 11:12 AM, Erick Erickson wrote: > Join doesn't work like that, which is why it's

Re: Sorting documents in one core based on a field in another core

2016-05-31 Thread Erick Erickson
Join doesn't work like that, which is why it's referred to as "pseudo join". There's no way that I know of to do what you want here. I'd strongly recommend you flatten your data at index time. Best, Erick On Tue, May 31, 2016 at 7:41 AM, Mark Robinson wrote: > Hi, > > I have a requirement to so

Re: Sorting on child document field.

2016-05-23 Thread Pranaya Behera
Hi Mikhail, Thanks. Missed it completely thought it would handle by default. On Monday 23 May 2016 02:08 PM, Mikhail Khludnev wrote: https://cwiki.apache.org/confluence/display/solr/Common+Query+Parameters#CommonQueryParameters-ThesortParameter sort=score asc On Mon, May 23,

Re: Sorting on child document field.

2016-05-23 Thread Mikhail Khludnev
https://cwiki.apache.org/confluence/display/solr/Common+Query+Parameters#CommonQueryParameters-ThesortParameter sort=score asc On Mon, May 23, 2016 at 11:17 AM, Pranaya Behera wrote: > Hi Mikhail, > I saw the blog post tried to do that with parent block > query {!parent} as I d

Re: Sorting on child document field.

2016-05-23 Thread Pranaya Behera
Hi Mikhail, I saw the blog post tried to do that with parent block query {!parent} as I dont have the reference for the parent in the child to use in the {!join}. This is my result. https://gist.github.com/shadow-fox/b728683b27a2f39d1b5e1aac54b7a8fb . This yields me the result

Re: Sorting for MLT results

2016-05-20 Thread Zheng Lin Edwin Yeo
Thanks for your reply. But it didn't work when I execute this query. http://localhost:8983/solr/collection1/mlt?q=testing&sort=creation_date desc,id asc&rows=10 This is my configuration for the handler. explicit 10 json true edismax id, score content subject content 2 5 3 25 10 false details

Re: Sorting on child document field.

2016-05-20 Thread Mikhail Khludnev
Hello, Check this http://blog-archive.griddynamics.com/2015/08/scoring-join-party-in-solr-53.html Let me know if you need further comments. On Thu, May 19, 2016 at 4:25 PM, Pranaya Behera wrote: > Example would be: > Lets say that I have a product document with regular fields as name, > price,

Re: Sorting on child document field.

2016-05-20 Thread Pranaya Behera
Adding lucene user mailing list to it. On Thursday 19 May 2016 06:55 PM, Pranaya Behera wrote: Example would be: Lets say that I have a product document with regular fields as name, price, desc, is_parent. it has child documents such as CA:: fields as a,b,c,rank and another child document as

Re: Sorting on child document field.

2016-05-19 Thread Pranaya Behera
Example would be: Lets say that I have a product document with regular fields as name, price, desc, is_parent. it has child documents such as CA:: fields as a,b,c,rank and another child document as CB:: fields as x,y,z. I am using the query where {!parent which="is_parent:true"}a:some AND b:so

Re: Sorting on child document field.

2016-05-19 Thread Pranaya Behera
While searching in the lucene code base I found /ToParentBlockJoinSortField /but its not in the solr or even in solrj as well. How would I use it with solrj as I can't find anything to query it through the UI. On Thursday 19 May 2016 11:29 AM, Pranaya Behera wrote: Hi, How can I sort th

Re: Sorting for MLT results

2016-05-17 Thread Alessandro Benedetti
using the more like this query parser should solve your problem ! Just use that query parser and than sort as usual. Cheers On Wed, May 11, 2016 at 4:53 AM, Zheng Lin Edwin Yeo wrote: > Hi, > > Would like to check, is there a function to do the sorting for MLT results > in Solr? I understand th

Re: Sorting question

2016-04-04 Thread John Bickerstaff
Thanks for sharing the solution Tamas -- I was hoping you'd let us know... On Mon, Apr 4, 2016 at 8:05 AM, Tamás Barta wrote: > Hi, > > FYI: the final solution I found is that I created a custom > "listpos(fieldName, listId)" function and now I can display a sorted list > via: > > fq=listid_s:37

Re: Sorting question

2016-04-04 Thread Tamás Barta
Hi, FYI: the final solution I found is that I created a custom "listpos(fieldName, listId)" function and now I can display a sorted list via: fq=listid_s:378 sort=listpos(listpos_s,378) asc Regards, Tamas On Fri, Apr 1, 2016 at 8:55 PM, John Bickerstaff wrote: > Tamas, > > This feels a bit li

Re: Sorting question

2016-04-01 Thread John Bickerstaff
Tamas, This feels a bit like a "user favorites" problem. I did a little searching and found this... Don't know if it will help, but when I'm looking for stuff like this I find it helps to try to come up with generic or different descriptions of my problem and go search those as well... http://s

Re: Sorting question

2016-04-01 Thread John Bickerstaff
Tamas, I'm brainstorming here - not being careful, just throwing out ideas... One thing that comes up is a separate document in SOLR - one doc for each list. If a user adds a doc to their list, that doc's id gets added to this other type of document... So, a document with the title "List 1" wou

Re: Sorting question

2016-04-01 Thread John Bickerstaff
OK - I get it. List order is totally arbitrary and cannot be tied to an hard data point. I'll have to think - Perhaps billnbell's solution will help, although I'm not totally sure I understand that suggestion yet. At this point, you could get all the documents for List X that match the search te

Re: Sorting question

2016-04-01 Thread Tamás Barta
Sorry I don't know what you mean. If "listpos" field contains multiple values like "list=pos" then is it possible to order by field value where that field value fits a query? For example list 1 contains: p1 and p2, list 2 contains p2 and p1 in this order, then p1 document has a listpos field wit

Re: Sorting question

2016-04-01 Thread billnbell
Put the match into 2 separate fields and index it. Then sort in Solr by the 2 fields is one way Bill Bell Sent from mobile > On Apr 1, 2016, at 11:15 AM, John Bickerstaff > wrote: > > Just to be clear - I don't mean who requests the list (application or user) > I mean what "rule" determines

Re: Sorting question

2016-04-01 Thread Tamás Barta
So, the list order is determined by the user. The user creates a list, adds products to it and i have to display these list using filters and pagination. Let's assume there is list with 1 products in it. In the website where i display the list only 50 products are displayed in a page. So if i

Re: Sorting question

2016-04-01 Thread John Bickerstaff
Oh - and if you send a copy of your query - please include a human-readable version of what your intent is... Something like: Find all the documents that have "blue" in the color field in addition to searching the title field for the user's search term..." ...Or whatever your intent is for this s

Re: Sorting question

2016-04-01 Thread John Bickerstaff
Just to be clear - I don't mean who requests the list (application or user) I mean what "rule" determines the ordering of the list? Or, is there even a rule of any kind? In other words, does a user arbitrarily decide that documentA, documentF, and documentW should be on a list of their own? For

Re: Sorting question

2016-04-01 Thread Tamás Barta
Some of the lists are created by users and some are generated by applications, it doesn't matter. It would be fine to solve it in Solr because Solr does the work of filtering and pagination. If sorting were done outside than I would have to read every document from Solr to sort them. It is not an

Re: Sorting question

2016-04-01 Thread John Bickerstaff
Specifically, what drives the position in the list? Is it arbitrary or is it driven by some piece of data? If data-driven - code could do the sorting based on that data... separate from SOLR... Alternatively, if the data point exists in SOLR, a "sub-query" might be used to get the right sort or

Re: Sorting question

2016-04-01 Thread Tamás Barta
For example I have to display sellable products which are in list X in the correct order. If I add a "status" and "list" (multivalued) fields to every document (products), then I can execute a query: status:sellable AND list:X, where X is the ID of the list. The list field contains IDs of the list

Re: Sorting question

2016-04-01 Thread Alessandro Benedetti
I think this is a classic XY Problem , you are trying to solve X with Y , and you are asking us about Y . Could you describe us what is your X problem ? What are you trying to do with this ordered lists ? If not I would add a field to the product called : list_position ( or a similar name) of type

Re: Sorting question

2016-04-01 Thread Binoy Dalal
I don't think I understand your problem properly. Are you trying to pre-sort the products? On Fri, 1 Apr 2016, 19:49 Tamás Barta, wrote: > Hi, > > I have a problem and I don't know how should I solve it in Solr. > > I have products indexed. Every product can be in lists. It is possible that > a

Re: Sorting parent documents based on a field from children

2015-09-17 Thread Florin Mandoc
Great, thank you very much for your help. On 16.09.2015 13:07, Mikhail Khludnev wrote: On Wed, Sep 16, 2015 at 12:15 PM, Florin Mandoc wrote: Is possible to to also add "name_s:expensive" search term in q? I know i can add it to fq but I will have no score boost. Sure you can. But beware o

Re: Sorting parent documents based on a field from children

2015-09-16 Thread Mikhail Khludnev
On Wed, Sep 16, 2015 at 12:15 PM, Florin Mandoc wrote: > Is possible to to also add "name_s:expensive" search term in q? I know i > can add it to fq but I will have no score boost. Sure you can. But beware of query syntax trap. It's explained by David Smiley at comment http://blog.griddynamics.

Re: Sorting parent documents based on a field from children

2015-09-16 Thread Florin Mandoc
Hi, Sorry for letting this thread hanging, I was out of office last week. I have managed to make it work using this query: http://localhost:8983/solr/testscoring/select?q={!parent%20which=type_s:product%20score=max}+color_s:Red^=0%20AND%20{!func}price_i&wt=json&indent=true&fl=score,*,[docid]&deb

Re: Sorting on date with multivalued False attribute

2015-09-08 Thread Mugeesh Husain
Hi, stop the solr server,delete index before indexing you should change or write schema fields then start solr and index which you want. -- View this message in context: http://lucene.472066.n3.nabble.com/Sorting-on-date-with-multivalued-False-attribute-tp4227495p4227625.html Sent from the So

Re: Sorting on date with multivalued False attribute

2015-09-07 Thread Erick Erickson
completely wipe the index, or recreate the collection and re-index. I'm guessing you changed the definition after some indexing was done and Lucene is a little confused about what the right definition is supposed to be. Best, Erick On Mon, Sep 7, 2015 at 7:55 PM, Akash Sahu wrote: > Hi, > > I am

Re: Sorting parent documents based on a field from children

2015-09-01 Thread Alexandre Rafalovitch
On 1 September 2015 at 09:10, Mikhail Khludnev wrote: >> Not many >> people know about it, may help to disambiguate the syntax. >> > Oh. C'mon! it's announced for ages http://yonik.com/solr/query-syntax/ Not everybody reads and keeps track of every feature of Solr. Especially for newbies, it help

  1   2   3   4   5   >