Id Name Birthday Status
121 Revenge of the Kabuki in the Bayou 13. 8. 1979 active
122 Telekinetic Police from Hell 5. 9. 1961 active
123 Allied Racing 25th Anniversary Edition 22. 2. 1974 active
124 Rockin' Fun from Mars 18. 4. 1954 active
125 Relieved Ray 18. 3. 1993 deleted
126 Ho-Hum Pogo Annihilation 8. 7. 1961 active
127 Inappropriate Furry Roundup 24. 10. 1961 active
128 Blasphemous Fishing Man 27. 4. 1980 active
129 Pixellated Kart Fighter 14. 8. 1968 active
130 Hilarious Herring 12. 9. 1971 active
131 Irritating Boxing Runner 18. 3. 2000 active
132 Repulsive Rhinoceros 24. 10. 1947 active
133 Cautious Corncrake 12. 9. 1978 deleted
134 Orbital Jungle Legend 20. 11. 1980 active
135 Subatomic Goth Stadium 9. 5. 1982 active
136 Crazy Cowfish 18. 4. 1995 active
137 Anxious Albatross 5. 1. 1936 active
138 Elegant Emu 8. 10. 1969 deleted
139 Spectacular Shadow Returns 23. 3. 1979 active
140 The Robot in Middle-Earth 9. 3. 1980 deleted
( Items: 121 - 140 from 1020 )
  See the code below 👇 or see GitHub
public function createComponentGrid(): DataGrid
{
	$grid = new DataGrid();

	$grid->setDataSource($this->dibiConnection->select('*')->from('users'));

	$grid->setItemsPerPageList([20, 50, 100]);

	$grid->addColumnNumber('id', 'Id')
		->setAlign('start')
		->setSortable();

	$grid->addColumnText('name', 'Name')
		->setSortable()
		->setFilterText();

	$grid->addColumnDateTime('birth_date', 'Birthday');

	$grid->addColumnText('status', 'Status');

	$grid->addExportCallback('Dump to ajax rq', function (array $rows, DataGrid $grid): void {
		echo 'All fetched data were passed to export callback. Size of data: ';
		echo count($rows);
		die;
	})->setAjax();

	$grid->addExportCsvFiltered('Csv export (filtered)', 'examples.csv')
		->setTitle('Csv export (filtered)');

	$columnName = new ColumnText($grid, 'name', 'name', 'Name');
	$columnEven = (new ColumnText($grid, 'even', 'even', 'Even ID (yes/no)'))
		->setRenderer(
			fn ($item) => $item['id'] % 2 === 0 ? 'No' : 'Yes'
		);

	$grid->addExportCsv('Csv export', 'examples-all.csv')
		->setTitle('Csv export')
		->setColumns([
			$columnName,
			$columnEven,
		]);

	return $grid;
}