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 > > > > > > > > > >
