I am trying to do a join, which I have working properly on 2 cores.

One core has report_as, and the other core has debt_id.

If I enter 'report_as: "Freeman", I expect to get 272 results. But I get
557.

When I do a database search on the matched fields, it shows me that
report_as: "Freeman" is matching also on 'A-1 Freeman'.

I have tried boosting the score as report_as: "Freeman"^2, but I get the
same results from the API, and from the browser itself.

Here is my query:

{
  "responseHeader":{
    "status":0,
    "QTime":5,
    "params":{
      "q":"( * )",
      "indent":"on",
      "fl":"debt_id, score",
      "cursorMark":"*",
      "sort":"score desc, id desc",
      "fq":"{!join from=debtor_id to=debt_id fromIndex=dbtr}(
report_as:\"Freeman\"^2)",
      "rows":"1000"}},
  "response":{"numFound":557,"start":0,"maxScore":1.0,"docs":[
      {
        "debt_id":"485435",
        "score":1.0},
      {
        "debt_id":"485435",
        "score":1.0},
      {
        "debt_id":"482795",
        "score":1.0},
      {
        "debt_id":"482795",
        "score":1.0},
      {
        "debt_id":"482794",
        "score":1.0},
      {
        "debt_id":"482794",
        "score":1.0},
      {
        "debt_id":"482794",
        "score":1.0},

SKIP



{
        "debt_id":"396925",
        "score":1.0},
      {
        "debt_id":"396925",
        "score":1.0},
      {
        "debt_id":"396925",
        "score":1.0},
      {
        "debt_id":"396925",
        "score":1.0},
      {
        "debt_id":"396925",
        "score":1.0},
      {
        "debt_id":"396925",
        "score":1.0},
      {
        "debt_id":"396925",
        "score":1.0},
      {
        "debt_id":"396925",
        "score":1.0},
      {
        "debt_id":"396925",
        "score":1.0},
      {
        "debt_id":"396925",
        "score":1.0},
      {
        "debt_id":"396925",


These ones are the correct matches that I can verify with the
database, but their scores are the same as the ones matching on
'A1-Freeman'

Is my scoring set up wrong?

Thanks,

Rhys

Reply via email to