Apperently searching/filtering with a left joined table doesn’t work. Do you have any solutions?
columns: [
....
{ text: 'Status', datafield: 'Status',cellclassname: cellclassname },
....
]
the generator
foreach ($result as $row)
{
$orders[] = array(
'Status' => $row->Status,
...
On filter attempt :: Unknown column ‘Status’ in ‘where clause’
SQL SELECT zlec_status.nazwa AS Status, …. FROM zlec LEFT JOIN zlec_status ON zlec.status_zlecenia = zlec_status.id …..WHERE (Status LIKE ‘%1%’)
I use your php generator.
The JS part
function applyFilters()
{
var filtergroupGeanre = new $.jqx.filter();
var filtervalue = '1';
var datafield = 'Status';
var filtertype = 'stringfilter';
var filter_or_operator = 1;
var filtercondition = 'contains';
var filterGeanre = filtergroupGeanre.createfilter(filtertype, filtervalue, filtercondition);
filtergroupGeanre.addfilter(filter_or_operator, filterGeanre);
$("#jqxgrid").jqxGrid('addfilter', datafield, filtergroupGeanre);
$("#jqxgrid").jqxGrid('applyfilters');
}
