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