I have multiple dropdown selects in cascade filtering data for a datatable. sede(not binded), escuela (loads) > curso (loads) > version. My query in PostgreSql has no problem processing the four dropdown values. It brings the results expected. The problem…
i need add fixed headers to the table create with yajra datatables in laravel 9.28 I have other tables with parameter: ->fixedHeader(true) and when i´m scrolling down, my headers stay in top. In my new table, i´m setting this parameter:…
I have a system where I manage multiple students, each with their own timezone, class days, and class times. However, my teachers are in a different timezone. I need to convert each student's class times to match the teacher's timezone…
I'm having trouble using Laravel Yajra Datatable to load 172.425 record with the following error: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4096 bytes) in vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 421. I already tried to set…
I am trying to pull the data from two tables by joining the data, but the sql query executed is dead slow. The idea is to pull all users and then combine with the created_at date from points table. Pulling…
How do I sort according to the second data? The sorting works only on the ID. But in my table, I added a badge count and that's what I want to sort by. Here is my controller return DataTables::of($users) ->addIndexColumn()…