Stack Overflow
Stack Overflow

Questions tagged [laravel-datatables]

Laravel DataTables is an API designed to transform Laravel structures (collections, models, query builders) into a suitable format for consumption by the jQuery Datatables plugin.

Laravel DataTables on GitHub

Laravel DataTables documentation

69 questions
1
vote
1 answer

I failed to refresh data in yajra/laravel-datatables-oracle with draw method

In laravel 6 app I use "yajra/laravel-datatables-oracle": "^9.4" and I need selecting 1 row and running ajax request on server to delete this row I try to refresh table with draw() method and it does not work. In my blade file : @push('scripts') …
mstdmstd
  • 2,195
  • 17
  • 63
  • 140
1
vote
2 answers

Return Action Button Shaped Text Datatable Laravel

I want to add action button to my datatable here the code html table and datatables …
Wazirul Azzan
  • 11
  • 1
1
vote
1 answer

Laravel datatables - only return the requested columns, removing the additional model fields

I'm using Laravel datatables on a website. Data is loaded through AJAX. On my frontend code I select which columns the table needs: var dataTable = $('#products-table').DataTable({ serverSide: true, ajax: { 'url':…
gbalduzzi
  • 9,356
  • 28
  • 58
1
vote
3 answers

laravel datatable take long time to load data

I am trying to display database table to laravel datatable using below code but laravel datatable taking long time to load data. I have approx 700000 records in database. How to decrease time of load data? Code web.php Route::get('home',…
Jinal Somaiya
  • 1,931
  • 15
  • 29
1
vote
1 answer

Unable to sort on added column on laravel datatable

I am using server side processing (for large amount of dataset) with laravel 5.4 and yajra datatable but unable to perform sorting for column that is added into the table view. My table schema as follows: stocks table : id (pk), name, symbol e.g. …
Andrew Ng
  • 79
  • 1
  • 2
  • 8
1
vote
1 answer

How Can I Improve Relationships in My Database?

I'm very new in designing professional database system and making a School Management System in Laravel. I have issues setting my database. How to enroll a student. To know the problem, you must have to read requirement once. Every Classroom can…
Abdul Rehman
  • 159
  • 1
  • 2
  • 18
1
vote
2 answers

Laravel: Sort and search by data displayed or enum, not by database table

I'm using Laravel 5.6 and yajira datatables plugin. I want to display user status in one of the columns which is a number from 0-5 in the database but I want to show and display it in the column as words, (New, Updated, Initial, etc.) Method to make…
Varin
  • 2,354
  • 2
  • 20
  • 37
1
vote
2 answers

Laravel, Datatables, column with relations count

I have two models, User and Training, with Many to many relationship between them. I'm using the Laravel Datatables package to display a table of all the users. This is how the data controller method (which retrieves the query results and creates a…
Томица Кораћ
  • 2,542
  • 7
  • 35
  • 57
0
votes
0 answers

Laravel Yajra DataTable search with enter key or search with a length or search with button

I have a Laravel application which uses yajra datatable, and it searches every time, when text entered, which makes searching very slow. Below is the code which I have tried. I want to try with searchable() method which accepts boolean true/false to…
Ezra
  • 1
0
votes
0 answers

table.ajax.json().input not showing in server

I am using Yajra Datatable (https://yajrabox.com/docs/laravel-datatables/10.0) In my local If I use console.log(table.ajax.json()) I can get table.ajax.json().input and base on this data I perform something. But in server this .input is not…
Vpa
  • 703
  • 2
  • 9
  • 30
0
votes
0 answers

Yajra datatable Search is not working when "serverSide: true"

When "serverSide: true" then the search option works not perfectly. My table has 5000+ records, I'm using "serverSide: true" for fast data load, but the search not working. Again when using serverSide: false then the search works perfectly but the…
Hanif Mia Fabel
  • 19
  • 1
  • 7
0
votes
0 answers

Livewire datatables columns sorting not working

I am new to Livewire, I am implementing data table using livewire. Requirement: I need to sort data by updated_at column in descending order. After that if user click on status , then status should be sort by Ascending then also sort by…
Usama Riaz
  • 21
  • 2
0
votes
1 answer

Mimic the ( Show All ) link in datatables.net

I have a situation where I want to get the full (data) from the backend as a CSV file. I have already prepared the backend for that, but normally the front-end state => (filters) is not in contact with the backend unless I send a request, so I…
mercury
  • 2,390
  • 3
  • 30
  • 39
0
votes
1 answer

Laravel Data table : Getting SQLSTATE[42S22]: Column not found: 1054 Unknown column error

Here is my data table query funciton. /** * @param ProjectTimeLog $model * @return \Illuminate\Database\Eloquent\Builder */ public function query(ProjectDailyStandup $model) { $request = $this->request(); …
ZemichaelMD
  • 3
  • 3
0
votes
2 answers

Ajax Reload on Vue.js DataTables

ajax.reload() and/or ajax.url().load() is just not working for Vue3 DataTable integration. It works if you include the CDN and follow the jQuery approach to it. If you follow the instructions on the DataTables website on how to integrate DataTables…
Dino Cajic
  • 138
  • 1
  • 7
1
2
3 4 5
Id Name Email