Hi Pierre, Great idea, that will speed things up!
Thank your very much. Regards Ericz On Mon, Sep 12, 2011 at 10:19 AM, Pierre GOSSE <pierre.go...@arisem.com>wrote: > Hi Eric, > > If you want a query informing one customer of its product row at any given > time, the easiest way is to filter on submission date greater than this > customer's and return the result count. If you have 500 products with an > earlier submission date, your row number is 501. > > Hope this helps, > > Pierre > > > -----Message d'origine----- > De : Eric Grobler [mailto:impalah...@googlemail.com] > Envoyé : lundi 12 septembre 2011 11:00 > À : solr-user@lucene.apache.org > Objet : Re: Document row in solr Result > > Hi Manish, > > Thank you for your time. > > For upselling reasons I want to inform the customer that: > "your product is on the last page of the search result. However, click here > to put your product back on the first page..." > > > Here is an example: > I have a phone with productid 635001 in the iphone category. > When I sort this category by submissiondate this product will be near the > end of the result (on row 9863 in this example). > At the moment I have to scan nearly 10000 rows in the client to determine > the position of this product. > Is there a more efficient way to find the position of a specific document > in > a resultset without returning the full result? > > q=category:iphone > fl=productid > sort=submissiondate desc > rows=10000 > > row productid submissiondate > 1 656569 2011-09-12 08:12 > 2 656468 2011-09-12 08:03 > 3 656201 2011-09-11 23:41 > ... > 9863 635001 2011-08-11 17:22 > ... > 9922 634423 2011-08-10 21:51 > > Regards > Ericz > > On Mon, Sep 12, 2011 at 9:38 AM, Manish Bafna <manish.bafna...@gmail.com > >wrote: > > > You might not be able to find the row index. > > Can you post your query in detail. The kind of inputs and outputs you are > > expecting. > > > > On Mon, Sep 12, 2011 at 2:01 PM, Eric Grobler <impalah...@googlemail.com > > >wrote: > > > > > Hi Manish, > > > > > > Thanks for your reply - but how will that return me the row index of > the > > > original query. > > > > > > Regards > > > Ericz > > > > > > On Mon, Sep 12, 2011 at 9:24 AM, Manish Bafna < > manish.bafna...@gmail.com > > > >wrote: > > > > > > > fq -> filter query parameter searches within the results. > > > > > > > > On Mon, Sep 12, 2011 at 1:49 PM, Eric Grobler < > > impalah...@googlemail.com > > > > >wrote: > > > > > > > > > Hi Solr experts, > > > > > > > > > > If you have a site with products sorted by submission date, the > > product > > > > of > > > > > a > > > > > customer might be on page 1 on the first day, and then move down to > > > page > > > > x > > > > > as other customers submit newer entries. > > > > > > > > > > To find the row of a product you can of course run the query and > loop > > > > > through the result until you find the specific productid like: > > > > > q=category:myproducttype > > > > > fl=productid > > > > > sort=submissiondate desc > > > > > rows=10000 > > > > > > > > > > But is there perhaps a more efficient way to do this? Maybe a > special > > > > > syntax > > > > > to search within the result. > > > > > > > > > > Thanks > > > > > Ericz > > > > > > > > > > > > > > >
