Fix DISCTINCT count results

bgultekin / laravel4-datatables-package

Server-side handler of DataTables Jquery Plugin for Laravel 4

267 stars 108 forks source link

Open djnet00 opened 10 years ago

djnet00 commented 10 years ago

Hello.

I have some problems with complex queries with DISTINCT and JOIN

Please fix the count funcion in Datatables.php

// Replace if( !preg_match( '/UNION/i', $myQuery->toSql() ) )

// Whit if( !preg_match( '/UNION/i', $myQuery->toSql() ) && !preg_match( '/DISTINCT/i', $myQuery->toSql() ) )

Thank you!

merlosy commented 10 years ago

Hi, I had the same issue. This totally fixed it!

ktunkiewicz commented 10 years ago

Added to TO DO list for 1.4.1 release #122