Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
MIME-Version: 1.0
In-Reply-To: <1304362935.3773660.1500373401847@mail.yahoo.com>
References: <1304362935.3773660.1500373401847.ref@mail.yahoo.com> <1304362935.3773660.1500373401847@mail.yahoo.com>
From: Susheel Kumar <susheel2777@gmail.com>
Date: Tue, 18 Jul 2017 08:45:41 -0400
Message-ID: <CAJuqOK+ChvtKCcavC2uaS7a2vFccYYYwgOX6RP7XydiLw8Lwfg@mail.gmail.com>
Subject: Re: Get results in multiple orders (multiple boosts)
To: solr-user@lucene.apache.org, "Luca Dall'Osto" <tenaciousd93@yahoo.it>
Content-Type: multipart/alternative; boundary="94eb2c1952f0a74d5a055496e4d2"
archived-at: Tue, 18 Jul 2017 12:45:54 -0000

--94eb2c1952f0a74d5a055496e4d2
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

As Eric suggested, its possible by sorting using custom function. You may
have to use if, sum and exists function etc. to come up with custom score
field and sort using this field. The if condition would check for the
conditions mentioned and keep adding the score etc.

Thanks,
Susheel

On Tue, Jul 18, 2017 at 6:23 AM, Luca Dall'Osto <
tenaciousd93@yahoo.it.invalid> wrote:

> Hello everyone,thanks for the prompt reply!
> In response to Florian, I can get correct score only when boost for 1
> filed (for example category): the score are correctly increased by the
> factor.But when I try to make a double boost, the score are not great as
> expected (for example, if the greatest boost factor for category is 3 and
> for source is 3,  sometimes I've got documents boosted with category^3 an=
d
> source^1 **before** documents boosted with category^3 and source^3).
> I tired you snippet code "^=3D[boost]" instead of "^[factor]" but seems n=
ot
> work for me: SyntaxError: Cannot parse 'category:9500^': Encountered
> \"<EOF>\" at line 1 (...)
> In response to Erik, I have different "sort preferences", so I can't buil=
d
> a index and use for sorting.Maybe I have to sort by category then by sour=
ce
> and by language or by source, then by category and by date.The sort
> function that you are talking is a custom sort function of Solr?I build a
> custom PHP method that sort documents queried from Solr and it works good=
:
> the problem is that if I choose this way I have to get **all** the result=
s
> in a single query and I can't paginate.Today I have millions of record an=
d
> query could be very large, I would like to paginate results.To paginate
> results I need that Solr give me the results query in the correct
> order.Thank you very much
>
> Luca
>
>
>
>     On Monday, July 17, 2017 6:04 PM, Erick Erickson <
> erickerickson@gmail.com> wrote:
>
>
>  I don't think boosting is really what you want here. Boosting
> _influences_ the score, it does not impose an ordering.
>
> Sorting _does_ impose an ordering, the question is how to sort and the
> answer depends on how fixed (or not) the sorting criteria are. Do they
> change with different queries? If not, the very simplest thing to do
> is to index a field with a pre-computed sort value. IOW, if your
> ordering is _always_ source 5, 9, 7 index a source_sort field that
> orders things that way and sort on that. Then I'd have a secondary
> sort by score as a tie-breaker.
>
> If that's not the case, perhaps sorting by function (perhaps a custom
> function) would work.
>
> Best,
> Erick
>
> On Mon, Jul 17, 2017 at 4:30 AM, Florian Waltersdorfer
> <Florian.Waltersdorfer@compass.at> wrote:
> > Hi,
> >
> > I am quite the SolR newbie myself, but have you looked at the resulting
> scores, e.g. via fl=3D*,score (that way, you can see/test how your boosti=
ng
> affects the results)?
> > In a similar scenario, I am using fixed value boosts for specific field
> values; "^=3D[boost]" instead of "^[factor]", for example:
> >
> > category:9500^=3D20  source:(5^=3D20 OR 9^=3D10 OR 7^=3D5)
> >
> > (Actual fixed values open for experimentation.)
> >
> > Regards,
> > Florian
> >
> > -----Urspr=C3=BCngliche Nachricht-----
> > Von: Luca Dall'Osto [mailto:tenaciousd93@yahoo.it.INVALID]
> > Gesendet: Montag, 17. Juli 2017 12:20
> > An: solr-user@lucene.apache.org
> > Betreff: Get results in multiple orders (multiple boosts)
> >
> > Hello,
> > I'm new in Solr (and in mailing lists..), and I have a question about
> querying contents in multiple custom orders.
> > I 'm trying to query some documents boosted by 2 (or more) fields: I'm
> able to make a search of 2 day and return results boosted by category
> field, like this:
> >
> > ?indent=3Don
> > &defType=3Dedismax
> > &q=3D(date:[2017-06-16T00:00:00Z TO 2017-06-18T23:59:59Z])
> > &bq=3Dcategory:9500^2
> > &bq=3Dcategory:1100^1
> > &rows=3D40
> > &wt=3DjsonThis will return all documents of category 9500 first, and 11=
00
> in after.Now I would like to get this documents with a second boost based
> on another field, called source.I would like to have documents in this
> order:1) category:9500 AND source:5
> > 2) category:9500 AND source:9
> > 3) category:9500 AND source:7
> > 4) category:1100 AND source:5
> > 5) category:1100 AND source:9
> > 6) category:1100 AND source:7
> > To get this order, I tied with this query:?indent=3Don &defType=3Dedism=
ax
> &q=3D(date:[2017-06-16T00:00:00Z TO 2017-06-18T23:59:59Z])
> > &bq=3Dcategory:9500^2+source:(5^3 OR 9^2 OR 7^1)
> > &bq=3Dcategory:1100^1+source:(5^3 OR 9^2 OR 7^1)
> > &rows=3D40
> > &wt=3Djson
> > How can I apply a double boosts to get the documents in my correct
> order? Is boost the correct tool for my purpose?Any help will be greatly
> appreciated. Thanks Luca
>
>
>

--94eb2c1952f0a74d5a055496e4d2--