in most cases I use the grid by passing a query.
$grid = new jqGridRender($pdo);
$grid->SelectCommand = ‘SELECT * FROM testtable WHERE user=1 AND year=2022;
$grid->dataType = ‘json’;
$grid->toolbarfilter = true;
However, if there is a WHERE clause in this query, the toolbar search does not work because the query is assembled incorrectly. Is there a way to assign some fields with filters to the grid already during initialization?
Copyright 2014 TriRand LtdAll Rights ReservedRSSBack to Top