rxcod9/joy-voyager-datatable

server Side search is not working

amunyua opened this issue · 6 comments

amunyua commented

Hi, server side searching is not working even on your demo.

rxcod9 commented
vitormicillo commented

Hi guys, yes the problem is still present, I've tested it
check my recorded screen

test.mp4
rxcod9 commented

Thanks for notifying,
Here is the implementation

joy-voyager-datatable/src/Services/DataTable.php

Line 132 in 6170d01

Log::debug('Your model must implement scopeGlobalSearch');

By default it filters only in primary key

You can implement scope in your model called scopeGlobalSearch

For your default user model, you can use following example

public function scopeGlobalSearch(Builder $query, $value): void
    {
        $query
            ->whereId($value)
            ->orWhere('name', 'LIKE', '%' . $value . '%')
            ->orWhere('email', 'LIKE', '%' . $value . '%');
    }
vitormicillo commented

Thanks for notifying,
Here is the implementation

joy-voyager-datatable/src/Services/DataTable.php

Line 132 in 6170d01

Log::debug('Your model must implement scopeGlobalSearch');

By default it filters only in primary key

You can implement scope in your model called scopeGlobalSearch

For your default user model, you can use following example

public function scopeGlobalSearch(Builder $query, $value): void
    {
        $query
            ->whereId($value)
            ->orWhere('name', 'LIKE', '%' . $value . '%')
            ->orWhere('email', 'LIKE', '%' . $value . '%');
    }

Thank you @rxcod9
Can you update your demo link too to filter all columns ?

rxcod9 commented

@vitormicillo Just updated with id, name and email

Build failed due to larapack

vitormicillo commented