CHANGELOG.md

Laravel DataTables CHANGELOG

Unreleased

v9.8.0 - 2019-12-17

• Add the possibility to makeVisible() some attribute of a model. #2263, credits to @imTigger.

v9.7.2 - 2019-11-11

• Cast database engines to array. #2240, credits to @mtvbrianking.
• Fix #2202.

v9.7.1 - 2019-10-02

• Fix skipTotalRecords api not working on initial state. #2222

v9.7.0 - 2019-10-02

• Allow orderColumn using closure. #2199

v9.6.1 - 2019-09-26

• Improve orderByNullsLast SQL generation. #2191
• Fix #1822, #1738.

v9.6.0 - 2019-09-04

• Fix deprecated helper functions, then add support for Laravel 6. #2171, credits to @lloricode
• Fix #2156.

v9.5.0 - 2019-08-31

• Add support for startsWithSearch filter. #2163
• Fix #2161.

v9.4.1 - 2019-06-12

• Removal of redundant SoftDelete check. #2103, credits to @selecod

v9.4.0 - 2019-06-06

• Allow column search on blacklisted columns with custom filter. #2102, fix #2091.
• Enable the dotted notation in the ->only() function. #2084, credits to @Arkhas
• Add tests.

v9.3.0 - 2019-05-21

• Prevent malformed UTF-8 characters in debug mode. #2088, credits to @drsdre.
• Add the possibility to makeHidden() some attribute of a model. #2085, credits to @Arkhas.

v9.2.0 - 2019-05-09

• Enable the dotted notation in the ->removeColumn() function. #2082, credits to @Arkhas.
• Consider black listed columns on column search. #2079, credits to @apreiml.
• Using predefined offsets for API-driven server-side(ish) DataTables. #2083, credits to @Stokoe0990.

v9.1.1 - 2019-04-25

• Revert #2051, fix #2058. #2072.

v9.1.0 - 2019-04-24

FIXED

• Fix rendering column from blade file. #2067, credits to @lukchojnicki.
• Fix #2045, #2054, #2024, #1977, #880, #577, #522, etc.

ADDED

• Add support for self join relationships. #2051, credits to @Morinohtar.

v9.0.1 - 2019-03-26

• Allow boolean values for column[i].searchable #1813, credits to @sgotre.

v9.0.0 - 2019-02-27

• Add support for Laravel 5.8 #2002.
• Fix #2001, #2003.
• Drop support for lower version of dataTables.
• Bump to php ^7.1.3.
• Bump testbench to ^3.8.

v8.13.5 - 2019-02-13

• Keep select bindings option. #1988, credits to @royduin.
• Fix #1983.

v8.13.4 - 2019-01-29

• Added optional merge of config raw columns to rawColumns method. #1960, credits to @Spodnet

v8.13.3 - 2019-01-05

• Revert #1942.
• Fix #1951.

v8.13.2 - 2019-01-04

• Keep casted attributes. #1942, credits to @ridaamirini.
• Fix #1747.

v8.13.1 - 2018-11-23

• Revert v8.12.0 changes.

v8.13.0 - 2018-11-23

• Only escape callable output of add and edit column. #1852, credits to @sharifzadesina
• Fix adding of index column bug introduced by #1852. [#1915]
• Add tests for #1852.

[v8.12.0] - 2018-11-23

• Skipped, bad tagging!

v8.11.0 - 2018-11-20

• Use skipTotalRecords as it better describe what the function does. #1912
• Remove method simplePagination and use skipTotalRecords instead.

v8.10.0 - 2018-11-20

• Add simple pagination api. #1911
• Use toJson() on all tests api. #1911
• Use dedicated assertCount assertion. [#1903], credits to @carusogabriel

v8.9.2 - 2018-10-30

• Fix the default name of index column to follow DT syntax. #1882, credits to @sharifzadesina.

v8.9.1 - 2018-10-05

• DATATABLES_ERROR shouldn't be by default null #1805 #1811, credits to @zeyad82.

v8.9.0 - 2018-10-05

• Added ability to pass an array of needed columns on response. #1860, credits to @ptuchik.

v8.8.0 - 2018-09-05

• Add support for Laravel 5.7
• Fix #1824, #1830

v8.7.1 - 2018-07-06

• Add validation for order direction. #1792
• Prevents SQL injection on order direction.
• Fix phpunit configuration warning.

v8.7.0 - 2018-06-03

• Add withQuery api for query callback. #1759
• Revert #1758 with callback implementation since its BC.

v8.6.1 - 2018-06-03

• Fix/Enhance with closure value implementation. #1758
• Use filteredQuery as callback parameter.
• Fix #1752

v8.6.0 - 2018-05-18

• Add support for manual setting of filtered count #1743, credits to @forgottencreature
• Fix #1516.

v8.5.2 - 2018-05-15

• Revert "[8.0] Classify join statements as a complex query." #1741
• Fix #1739

v8.5.1 - 2018-05-12

• Reset select bindings for count query #1730, credits to @fschalkwijk
• Classify join statements as a complex query #1737.
• Fix #1600, #1471.

v8.5.0 - 2018-05-10

• Support for Eloquent API Resources #1702, credits to @asahasrabuddhe.
• Fixes #1515, #1659, #1351.

v8.4.4 - 2018-05-04

• Use array_key_exists instead of in_array + array_keys #1719, credits to @carusogabriel.
• Adds support to Laravel 5.6 on readme, #1724, credits to @nunomaduro
• Fixed a bug for "undefined index" errors, #1728, credits to @redelschaap

v8.4.3 - 2018-04-05

• [8.0] Fix ambiguous column 'deleted_at'. #1688, credits to @sskl.

v8.4.2 - 2018-03-29

• Check SoftDeletes on HasOne or BelongsTo relations #1628, credits to @drahosistvan.
• Add mention of Datatables Editor pkg to "suggests" #1658, credits to @drbyte.

v8.4.1 - 2018-02-16

• Change Log contract to LoggerInterface. #1624, credits to @LEI.
• Fix #1626.

v8.4.0 - 2018-02-11

• Added Laravel 5.6 Support #1609, credits to @marcoocram
• Fix #1617

v8.3.3 - 2018-01-11

• Fixes from PHPStan. #1569, credits to @carusogabriel.
• Enable no_useless_else. #1554, credits to @carusogabriel.
• Remove useless else statements. #1553, credits to @carusogabriel.
• Fix typo. #1536, credits to @Oussama-Tn.
• Test against PHP 7.2. #1532, credits to @carusogabriel.
• Update TestCase with PSR-2. #1496, credits to @gabriel-caruso.

v8.3.2 - 2017-11-02

• Fix datatables() helper and use singleton instance. #1487, credits to @ElfSundae.
• Styling phpdoc for facade. #1489, credits to @ElfSundae.
• Apply StyleCI fixes. #1485, #1483.
• Patch docs. #1492
• Add StyleCI integration. #1484

v8.3.1 - 2017-10-27

• Fix filtered records total when using filterColumn. #1473, credits to @wuwx.
• Added Patreon Link. #1476, credits to @ChaosPower.
• Fix missing periods. #1478, credits to @jiwom.
• Fix PHP Docs and minor array fixes. Remove unused import. #1479, credits to @jiwom.

v8.3.0 - 2017-10-26

ADDED

• DataTables factory class is now Macroable. #1462
• query() api added as a replacement for queryBuilder(). #1462

CHANGED

• Support for plugin engine methods. #1462, credits to @pimlie.
• datatables.builders config is now optional/redundant. #1462
• Deprecate queryBuilder() api and replaced with query().

FIXED

• Support for custom engines (eg for mongodb) #1294,

v8.2.0 - 2017-10-25

FIXED

• Fix changelog links. #1449
• Rename phpunit.xml and add composer script. #1460, credits to @pimlie.
• Fix exception/warning for PHP 7.2. #1465, credits to @CristianDeluxe.
• Fix facade method annotations. #1468, credits to @Guja1501.
• Fix globalSearch not working for 0. #1467, credits to @lrtr.

ADDED/CHANGED

• Make wildcard string a function parameter. #1461, credits to @pimlie.

v8.1.1 - 2017-10-17

• Fix docs API link. #1438, credits to @dextermb.
• Fix merging config. #1444, credits to @ElfSundae.
• Fix return type. #1446, credits to @gabriel-caruso.
• Remove unused provides() from service provider. #1445, credits to @ElfSundae.

v8.1.0 - 2017-10-08

• Add addColumns() to EloquentDataTable. #1416, credits to @ElfSundae.

v8.0.3 - 2017-09-12

• Fix compatibility with Lumen. #1382
• Fix #1377.

v8.0.2 - 2017-09-06

• Remove void return type.
• Fix #1367, #1368.

v8.0.1 - 2017-08-31

• Do not resolve column if relation is not eager loaded. #1355
• Fix #1353, sort/search not working when using join statements.
• Add tests for join statements.

v8.0.0 - 2017-08-31

ADDED

• Add support for Laravel 5.5.
• Package auto-discovery implemented.
• Add the raw data to model key when compiling views when using addColumn and editColumn.
• Make multi-term search configurable.
• Source code clean-up, refactoring and type-hinting.
• Improved scrutinizer code quality score from 6 to ~9 pts.
• On the fly support for SoftDeletes. No need to use withTrashed and onlyTrashed.
• Add getQuery api to get the query used by dataTable.
• Add getFilteredQuery api to get the prepared (filtered, ordered & paginated) query.
• Add Arrayable and Jsonable interface for a more Laravel like response.

use Yajra\DataTables\Facades\DataTables;

return DataTables::eloquent(User::query())->toJson();
return DataTables::eloquent(User::query())->toArray();

• Introducing a new OOP / intuitive syntax.

// using DataTables Factory
use Yajra\DataTables\DataTables;

return DataTables::of(User::query())->toJson();
return (new DataTables)->eloquent(User::query())->toJson();
return (new DataTables)->queryBuilder(DB::table('users'))->toJson();
return (new DataTables)->collection(User::all())->toJson();

// using DataTable class directly
use Yajra\DataTables\EloquentDataTable;
return (new EloquentDataTable(User::query())->toJson();

use Yajra\DataTables\QueryDataTable;
return (new QueryDataTable(DB::table('users'))->toJson();

use Yajra\DataTables\CollectionDataTable;
return (new CollectionDataTable(User::all())->toJson();

• Add datatables() function helper.

CHANGED

• Namespace changed from Yajra\Datatables to Yajra\DataTables.
• Rename Datatables to DataTables class.
• Rename Facade from Datatables to DataTables class.
• Preserve Eloquent\Builder when overriding the default ordering of dataTables when using EloquentEngine.
• Preserve Eloquent\Builder when using filterColumn api. Allows us to use model scope and any eloquent magics.
• Fractal integration extracted to own plugin laravel-datatables-fractal.
• Raw output are always passed on transformer instance.
• Object response is now the default output public function make($mDataSupport = true).

REMOVED

• Remove filterColumn api magic query method in favor of closure.
• Remove support on older snake_case methods.
• Remove silly implementation of proxying query builder calls via magic method.
• Removed unused methods.
• Remove withTrashed and onlyTrashed api.

FIXED

• How to get full used query ? #1068
• Is there a way to build the query (with filtering and sorting) but without execute it? #1234
• Fix orderColumn api where related tables are not joined.
• Fix nested with relation search and sort function.