Individual Column Filter in 1.10

lyndonwil

First off, i've just upgraded to v1.10 and wow... could things get any simpler ! Loving it :-)

I did just run into an issue though regarding individual column filtering. Basically, it wasn't working and i kept getting a full set of results back.

I had a good look through ssp.class.php and noticed something in the following section :

[code]
$where = '';

if ( count( $globalSearch ) ) {
$where = '('.implode(' OR ', $globalSearch).')';
}

if ( count( $columnSearch ) ) {
$where = $where === '' ?
implode(' AND ', $globalSearch) :
$where .' AND '. implode(' AND ', $globalSearch);
}

if ( $where !== '' ) {
$where = 'WHERE '.$where;
}

return $where;
[/code]

I assume that the columnsearch section could be using columnsearch and not globalsearch ? ie:

[code]


if ( count( $columnSearch ) ) {
$where = $where === '' ?
implode(' AND ', $columnSearch) :
$where .' AND '. implode(' AND ', $columnSearch);
}
[/code]

This change works for me, but i wanted to make sure it was a typo and not me breaking something further down the line !

Regards

kqueekquee

i have the same problem this solution is very good
merci beaucoup

allan

Yup - very certainly a bug! I actually committed a fix for it a couple of days ago ( https://github.com/DataTables/DataTablesSrc/commit/5163edd378f ), but it isn't yet in a release package. I'm going to do an rc-1 of 1.10 (hopefully tomorrow) which will contain the fix. Thanks for brining this up!

Allan

kqueekquee

when data contains spécial french caracters ' èçàù...' the datatable return ' null '
i changed ssp.class.php with utf8_encode( to return the spécial caracters in the datatable

// Is there a formatter?
// 28/03/2014 utf8_encode () for spécial character éàèù...
if ( isset( $column['formatter'] ) ) {
$row[ $column['dt'] ] = utf8_encode($column['formatter']( $data[$i][ $column['db'] ], $data[$i] ));
}
else {
$row[ $column['dt'] ] = utf8_encode( $data[$i][ $columns[$j]['db'] ]);
}
}

allan

My classes assume that all data and all communication between the client and server, and server and database is UTF8 and that the database is also UTF8. There should be no need for conversion between character sets in such a case. Obviously if your processing environment doesn't match that, then yes, you would need to convert the character sets as appropriate.

Allan

kqueekquee

my mysql datatabase is in utf8_general_ci

kqueekquee

i have download the RC1 version and column filter not working
"public/scripts/DataTables1.10.0-RC1/media/js/jquery.dataTables.min"
when i load
public/scripts/DataTables1.10.0-2/media/js/jquery.dataTables.min"
the filtering is good

allan

What column filter? Can you show me the Javascript code please - ideally with a test case.

Allan

kqueekquee

here an example
http://live.datatables.net/efuyaj/49/edit

allan

Excellent - thanks for that. Allowed me to find and fix an issue wight he column selector in rc.1. I've committed the fix and it is now in the nightly: http://live.datatables.net/efuyaj/54/edit

Allan

kqueekquee

firebug give me this error when i ordering
"NetworkError: 404 Not Found - http://datatables.net/download/build/images/sort_desc.png"

kqueekquee

3 errors
"NetworkError: 404 Not Found - http://datatables.net/download/build/images/sort_both.png"
sort_both.png
"NetworkError: 404 Not Found - http://datatables.net/download/build/images/sort_asc.png"
sort_asc.png
"NetworkError: 404 Not Found - http://datatables.net/download/build/images/sort_desc.png"

allan

Yup - the nightly version of the CSS doesn't have the images at the correct address. The nightly hosted on this server is for testing only - which is why the images aren't present - it encourage you to either use the CDN version or host your own.

Allan

kqueekquee

merci