debugger.md

Debugging Mode

To enable debugging mode, just set APP_DEBUG=true and the package will include the queries and inputs used when processing the table.

IMPORTANT: Please make sure that APP_DEBUG is set to false when your app is on production.

You also need to update the Error Handler config appropriately.

Example Response

{
	"draw": 1,
	"recordsTotal": 10,
	"recordsFiltered": 3,
	"data": [{
		"id": 414,
		"name": "Abel Cole",
		"email": "[email protected]",
		"created_at": "2016-07-31 23:26:10",
		"updated_at": "2016-07-31 23:26:10",
		"deleted_at": null,
		"superior_id": 0
	}, {
		"id": 267,
		"name": "Addie Satterfield",
		"email": "[email protected]",
		"created_at": "2016-07-31 23:26:00",
		"updated_at": "2016-07-31 23:26:00",
		"deleted_at": null,
		"superior_id": 0
	}, {
		"id": 120,
		"name": "Adeline Mayert",
		"email": "[email protected]",
		"created_at": "2016-07-31 23:25:50",
		"updated_at": "2016-07-31 23:25:50",
		"deleted_at": null,
		"superior_id": 0
	}],
	"queries": [{
		"query": "select count(*) as aggregate from (select '1' as `row_count` from `users` where `users`.`deleted_at` is null and `users`.`deleted_at` is null) count_row_table",
		"bindings": [],
		"time": 1.84
	}, {
		"query": "select * from `users` where `users`.`deleted_at` is null order by `name` asc limit 10 offset 0",
		"bindings": [],
		"time": 1.8
	}],
	"input": {
		"draw": "1",
		"columns": [{
			"data": "id",
			"name": "",
			"searchable": "true",
			"orderable": "true",
			"search": {
				"value": "",
				"regex": "false"
			}
		}, {
			"data": "name",
			"name": "",
			"searchable": "true",
			"orderable": "true",
			"search": {
				"value": "",
				"regex": "false"
			}
		}, {
			"data": "email",
			"name": "",
			"searchable": "true",
			"orderable": "true",
			"search": {
				"value": "",
				"regex": "false"
			}
		}, {
			"data": "created_at",
			"name": "",
			"searchable": "true",
			"orderable": "true",
			"search": {
				"value": "",
				"regex": "false"
			}
		}, {
			"data": "updated_at",
			"name": "",
			"searchable": "true",
			"orderable": "true",
			"search": {
				"value": "",
				"regex": "false"
			}
		}],
		"order": [{
			"column": "1",
			"dir": "asc"
		}],
		"start": "0",
		"length": "10",
		"search": {
			"value": "",
			"regex": "false"
		},
		"_": "1479295888286"
	}
}