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