caneara/quest

A pseudo fuzzy-searching library for Laravel database queries.

quest's Issues

Implement or matching when chaining where Fuzzy

When searching across multiple columns, if the query would normally return a match with ONE whereFuzzy, that result is not returned if second column query returns null.

Would it be possible to built an OR function to return a better result set in that instance ?

I.e.

User::whereFuzzy('name', 'jd')
->orWhereFuzzy('email', 'gm')
->first();

_fuzzy_relevance_* is not limited to 100

Hello
First of all, thanks for all the job. From the documentation I understand that the relevance is between 0 and 100 ... but I have lus more than that

do you have any idea ?
thanks a lot

Feature Idea: Allow the minimum relevance score to be set per instance

For example, if I do not want to show any results if the score is less than x.

DB::table('users')
  ->whereFuzzy('name', 'jd') // matches John Doe
  ->atLeast(60)
  ->first();

Add orWhereFuzzy search option

Hi,

Was looking for a replacement for Searchy and came across your implementation.
In my use case, I need an orWhereFuzzy, so that the query returns results having at least one relevance index > 0 as opposed to having all of them > 0.

Tried contributing but need access.

I have attached the needed changes here if you are kind enough to include them.
orWhereFuzzy.zip

Thank you,
Catalin Nita.

Matching extra characters

First of all, great package...thanks!

I'm having an issue with extra characters and slight misspellings. I wasn't sure if this was expected behavior:

Matching for guacamole...if I type:

• guac it works
• guacamolee does not work
• guacemole does not work

Am I doing something wrong?

Not able to use with Laravel 10.0

I just booted up a fresh Laravel repo and need some fuzzy search functionality. After following the docs for using, my code looks like this.

RoutingNumber::whereFuzzy('bank_name', 'WELLS')->first();

After running, I get this error:

ArgumentCountError: Too few arguments to function Illuminate\Database\Query\Expression::getValue(), 0 passed in /home/jon/Projects/Teleforce/routing_number_lookup/vendor/caneara/quest/src/Macros/WhereFuzzy.php on line 95 and exactly 1 expected in file /home/jon/Projects/Teleforce/routing_number_lookup/vendor/laravel/framework/src/Illuminate/Database/Query/Expression.php on line 34

I then tried to use the DB facade configuration, and the same error occurred.

Here are the relavant packages in my composer.json

"require": {
    "php": "^8.1",
    "caneara/quest": "^2.0",
    "guzzlehttp/guzzle": "^7.2",
    "laravel/framework": "^10.0",
    "laravel/sanctum": "^3.2",
    "laravel/tinker": "^2.8"
},
"require-dev": {
    "fakerphp/faker": "^1.9.1",
    "laravel/pint": "^1.0",
    "laravel/sail": "^1.18",
    "mockery/mockery": "^1.4.4",
    "nunomaduro/collision": "^7.0",
    "phpunit/phpunit": "^10.1",
    "spatie/laravel-ignition": "^2.0"
},

If you need more information let me know. Thanks for the time.

Handle potentially null search fields

I'm wanting to search on two columns, one of which is nullable. At the moment I get str_replace(): Argument #3 ($subject) must be of type array|string, null given when doing so, so I suspect there isn't built-in support for this.

Is there a workaround for this?