Comments (15)
Thanks for that. I had missed a critical step in the documentation.
When you reference the table using the search()
method, you need to chain fields()
afterwards to denote the fields. See the updated readme in the commit and let me know if that fixes your issue.
from laravel-searchy.
Also ensure that you have the facades setup correctly and that you have the alias in you app.php config file.
from laravel-searchy.
Now i get this
Non-static method TomLingham\Searchy\SearchBuilder::search() should not be called statically, assuming $this from incompatible context
from laravel-searchy.
public function getSearch($value='')
{
//$users = Searchy::users('first_name', 'email', 'last_name')->query($value)->get();
// $users = Searchy::search('users')->query($value);
//$users = Searchy::users('email')->query('John Smith');
// $test = searchy;
$users = Searchy::search('users')->fields('first_name', 'email')->query($value)->get();
// $users = User::where('first_name', 'LIKE', $value.'%')->get();
//$users = Searchy::search('users')->query('John Smith');
return Response::json($users->toArray());
}
from laravel-searchy.
Again the same problem.
So i Uncomment the line and set
$users = Searchy::users('email')->query('John Smith');
and get
Call to undefined method TomLingham\Searchy\SearchBuilder::users()
facades setup correctly and alias
from laravel-searchy.
Ah ha! Think I have it now. I had the alias referenced incorrectly in the docs again. Change your alias to:
'Searchy' => 'TomLingham\Searchy\Facades\Searchy'
Let me know how that goes.
from laravel-searchy.
It works now:D
from laravel-searchy.
Awesome! Sorry that it wasn't working though. A big thank you for helping me make Searchy better! :)
from laravel-searchy.
Thanks you:D It working i need to test over 10000 records
from laravel-searchy.
what about paginate? Did you have plan to do this?
from laravel-searchy.
Not exactly, pagination requirements might be too complex to cover all bases. It is however very easy to roll your own with the skip()
and take()
methods and the Laravel Pagainator
class.
So you could run:
$users = Searchy::search('users')->fields('first_name', 'email')->query($value)->skip(10)->take(5)->get();
And you can use Laravel's Paginator class to keep track of pages and generate urls http://laravel.com/api/class-Illuminate.Pagination.Paginator.html
Even abstract it out to it's own method.
from laravel-searchy.
Ok a have one problem more:(
I put
$users = Searchy::search('users')->fields('first_name', 'email')->query('ne')->get()
and i get user with name 'Marijan' why?
is it possible to sort by revelance?
so when i heve user with name 'Nenad' to get first?
TNX
from laravel-searchy.
Which Driver are you using? The default Fuzzy Driver?
There may be something in the email
field that is getting matched in the user 'Marijan' which is causing it to show in the results. The results are already sorted by relevance with the one with the highest relevence coming first. I ran a search using the same details and it only returned user 'Nenad' but I'm not sure what you have in the email
field.
Check the readme and take a look at the matchers and Fuzzy Driver. I have explained how they work in there.
from laravel-searchy.
In email field the value is [email protected]
from laravel-searchy.
Hmmm... are you able to tell me your database collation? As well as the two records you get back (For Marijan and Nenad)?
I will need the email
and name
field for both users and the relevance
number that gets returned for them so I can troubleshoot..
You can email them if you don't want the details to show in the comments.
from laravel-searchy.
Related Issues (20)
- SQLite Testing Environment HOT 1
- Searching against provided words individually HOT 1
- Is this project still maintained? HOT 3
- Full hits on string is not included in result with the Levenshtein-driver HOT 1
- How to also include a related model in the result? HOT 1
- Support for Laravel 7? HOT 2
- Laravel 8.x support HOT 1
- Could not load package tom-lingham/searchy in http://repo.packagist.org: [UnexpectedValueException] Could not parse version constraint ^7.*: Invalid version string "^7.*" HOT 2
- Could not load package tom-lingham/searchy in http://repo.packagist.org: [UnexpectedValueException] Could not parse version constraint ^7.*: Invalid version string "^7.*" HOT 6
- Future of Laravel Searchy HOT 2
- Authenticated User Data HOT 1
- SQLSTATE[42000]: Syntax error or access violation: 1463 Non-grouping field 'relevance' is HOT 2
- Searching joined/concatenated columns fails when a field is null HOT 2
- Searchy returns Illuminate/Collection, not array? HOT 2
- Handling special Characters HOT 2
- levenshtein drive keeps processing and does not bring result HOT 1
- Can't return multiple specific columns HOT 2
- Very slow query causing 400% slow down of results HOT 1
- LevenshteinMatcher calculates distance not relevance HOT 1
- Laravel 6 Support HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from laravel-searchy.