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

Reply via email to