Search not giving result

[binita-engg89]

Value of Gr_no : gr22rmNO In database

In Model

protected $searchable = [ 'columns' => [ 'purchase.sr_no' => 10, 'purchase.gr_no' => 10],

];

or this way

protected $searchable = [ 'columns' => [ 'purchase.sr_no', 'purchase.gr_no'],

];

In Controller $purchase = Purchase::search('g', null, true)->get();

Result returns blank array

Collection {#895

items: []

}

am i doing any wrong???

Thanks

[scripta55]

hi @binita-engg89 does your model return data on its own? if you call purchase::all();

[binita-engg89]

@scripta55 yes

[chAhmedRaza]

Same is happening with me. Any solution yet?

[jozeflambrecht]

workaround would be:

Order::withoutGlobalScopes()->search($query)->where('team_id', Auth::user()->team_id)->get();

So re-adding your constraint after removing the global scope...