laravel-datatables

laravel-datatables copied to clipboard

how can i reset sorted columns after set 'bStateSave' to true ? ---------------------- PHP Version "^8.0.2 Laravel Version "^9.19" Laravel-Datatables Version "^9.0"

moathOSA

### Controller `$games = Game::with(['category' , 'publisher' , 'region' , 'languages']); return Datatables::of($games) ->editColumn('status', function ($data) { if($data->status === "1"){ return 'Active'; }else{ return 'Passive'; } }) ->filterColumn('languages', function ($query,...

coloralp

Search (smart?) issue with primary key ids and LIKE operator

3

Hello, So I have a problem, not sure if it's my lack of understanding how this works, or is it a problem with the lib itself. The problem is with...

alekth85

Laravel Yajra Datatable Server Side with pagination problem

11

I'm newby on Laravel and I'm trying to use Yajra Datatable Plugin with server side funtionality. The plugin works well with a small amount of records, but I have a...

robertoremondiniarcadia

Search on MSSQL smalldatetime error

1

### Summary of problem or feature request Hello, i have formatted a smalldate time to d-m-Y Display and sort it's ok but, when i search returning nothing. No rows data....

simsar78

Error in Laravel 9.10 queryBuilder does not exist

2

Using in Laravel 9.10 Method Yajra\DataTables\DataTables::queryBuilder does not exist With ``` $query = DB::table('categories as c') ->leftJoin('categories as k','c.parent','=','k.id') ->select('c.id','c.thumbnail','c.name','k.name as parent') ->orderBy('id'); return DataTables::queryBuilder($query)->toJson(); ``` Work with return DataTables::of($query)->toJson();...

KatiaSishost

Warning using column with orthogonal data

1

Hi! I try to create a column with two data, in order to use it after in Javascript with one data to display and other to sort. So the idea...

adantart

### Summary of problem or feature request I have dashboard page, and i'm using yajra datatables serverside to show the data. But i have problem with quick searching. I can...

rzlmtrt

toJson causes encoding of utf-8 characters

4

### Summary of problem or feature request When selecting data with valid utf-8 characters, the JsonResponse html encodes the data. I can disable this by using the rawColumns method, but...

avatarofhope2

Use different query to count filtered record

4

### Summary of problem or feature request On very complex query where i need to join many table to get some aggregation value and complex calculation for column: - Total...

abudawud