Yet Another DataTables Column Filter - (yadcf)

trapagual

Thanks for the ultra-rapid response. I'll wait for the next release for "text" mode.
Walt

MikeS

Has anyone got this plugin working with version 1.10 beta of dataTables and jQuery version 1.11?

When I try to use it as shown in the examples, I receive an error, "Object doesn't support property or method 'yadcf'". I am certain that I'm including the plugin script and css files on my page. I am not passing any parameters when I call the plugin. Do I have to? I tried with one column parameter like so

.yadcf([{column_number: 0}])

and same error message is thrown. I've looked at this Issue https://github.com/vedmack/yadcf/issues/27 over on GitHUB but it does not reveal anything that I can see to resolve the issue.

daniel_r

yadcf does not support the 1.10/beta of dataTables , you can open an issue on github project page

As to the jQuery version 1.11 , I think I did tested it a while ago and it did work, so try the datatables 1.9 + jQuery version 1.11 and if that wont work you can open an issue for that too.

I order to use the yadcf plugin you should at least specify the column_number.

trapagual

Hello
Another question regarding this powerful plugin.
I need datepicker language changed to "es". I've included the code below, but seems not to be working. The datepicker calendar remains english, and week starting on Sunday.

[code]jQuery(function(A){A.datepicker.regional["es"]={clearText:"Limpiar",clearStatus:"",closeText:"Cerrar",closeStatus:"",prevText:"",nextStatus:"",nextBigText:">>",nextBigStatus:"",currentText:"Hoy",currentStatus:"",monthNames:["Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre"],monthNamesShort:["Ene","Feb","Mar","Abr","May","Jun","Jul","Ago","Sep","Oct","Nov","Dic"],monthStatus:"",yearStatus:"",weekHeader:"Sm",weekStatus:"",dayNames:["Domingo","Lunes","Martes","Miércoles","Jueves","Viernes","Sábado"],dayNamesShort:["Dom","Lun","Mar","Mié","Juv","Vie","Sáb"],dayNamesMin:["Do","Lu","Ma","Mi","Ju","Vi","Sá"],dayStatus:"DD",dateStatus:"D, M d",dateFormat:"dd/mm/yy",firstDay:0,initStatus:"",isRTL:false};A.datepicker.setDefaults(A.datepicker.regional["es"])});
[/code]

Where have I to invoke the function for the datepicker inside the column filter to change language to spanish?

Thanks
Walt

daniel_r

Hi,
It looks like all you need to do is to include the relevant localized file from here http://jquery-ui.googlecode.com/svn/tags/1.8.20/ui/i18n/ (or other place for different version) and to include it on your page (after the inclusion of the jquery / ui

trapagual

Done
Working perfectly.
Thank you very much again.
I'm afraid I'm a little lost with this javascript thing.

Walt

daniel_r

0.6.3 version is out!


*) Added new filter type: text input (a simple input text) filter_type: "text"

*) Added new feature: case_insensitive, can be set to false or true (default)

*) Added new mode "startsWith" for filter_match_mode

Updated Showcase: http://yadcf-showcase.appspot.com/

louking

This is exactly what I'm looking for, I think. I was just about to embark on custom developing the external filter. As it stands, I'd have to move back to DataTables 1.9.4, so I did write the issue to get it working on DT 1.10+ as you'd suggested to MikeS.

One question: Would yadcf work for a hidden column, using the external filter?

daniel_r

I'm not sure about the hidden, take a look at this issue: https://github.com/vedmack/yadcf/issues/16

and see how it goes, if you a specific non working example , please provide a jsbin example

trapagual

Sorry, a new question.

Testing with all browsers, Chrome and Firefox work ok, but with IE9 and IE11 filters out the header do not work and the look is awful.
Screenshots:
http://i1008.photobucket.com/albums/af209/trapagual/auditChrome_zps5b8399a8.png
http://i1008.photobucket.com/albums/af209/trapagual/auditIE11_zps288c4abd.png

Functionality is not good either: the filter type "select" do work, but the "date-range" and "text" does not operate. In addition, each time a filter or button is pressed, or a date is selected, lines are added with the result that the container grows in height and filters get out of layout.

Any suggestions to fix this with Internet Explorer?

I have the following versions:
jquery-1.7.2
jQuery UI - v1.9.2
jquery.dataTables 1.9.4
jquery.dataTables.yadcf 0.6.4

I thought jQuery was aware of browser differences.

Please help. Many of my users work with IE9 and IE11.

Thanks
Walt

daniel_r

Just checked in IE9 the range_date and text , all works just fine , (I even updated the showcase with external range_date filter http://yadcf-showcase.appspot.com/DOM_source.html) My guess is that your IE is in "Comparability View" .

trapagual

You are right, Daniel.
Switching off the "compatibility view" IE11 works ok. Searching now for an IE9 to test also this version.

Thank you.
Great work this addon. Also the new "text" filter is what I was waiting for.

Walt

louking

Hi, Daniel.

Is there any way to control the color, or disable the color, used for a filtered column select?

I'm using external filters (i.e., not in the table headings).

thanks!

daniel_r

Hi,

Sure, its possible using css
Just add to your css file (make sure its loaded after the yadcf css) the following

[code]
.inuse {
background: none;
}
[/code]

You can replace the none with any other html color you want

louking

great, thanks!

daniel_r

0.6.7 version is out!


*) Added support for DataTables 1.10.0-beta.2

*) Bug fix

New showcase page: http://yadcf-showcase.appspot.com/DOM_Ajax_Multiple_1.10.html

Waynef

Hi I am loving the plug in, just wanted to ask a couple of questions,

To allow dates to be selected in dd/mm/yyyy do i update the js script to change this format.
To use the widgets do I have to incorporate those into the page or are they part of the makeup of yadcf?

Thanks for the great work

Wayne

daniel_r

Hi @Waynef

You can find all the documentation in the yadcf js source file:

* date_format
Required: false
Type: String
Default value: mm/dd/yyyy
Possible values: mm/dd/yyyy / dd/mm/yyyy (eventually I replace yyyy into yy for jquery datepicker)
Description: Defines the format in which the date values are being parsed into Date object

If by saying widgets you mean the jQuery datepicker /autocomple then you will have to include them on your page, just like I'm doing on the showcase , do "view source" of the page and you will see it all there http://yadcf-showcase.appspot.com/DOM_source.html

Daniel.

daniel_r

0.6.9 version is out!


*) Added new filter type: multiple selection, filter_type: "multi_select". With or without Chosen plugin support

updated showcase page: http://yadcf-showcase.appspot.com/DOM_source_chosen.html

daniel_r

0.7.0 version is out!

*) Reimplemented exFilterColumn to support ALL filter types!!! + Now it can be used even for multiple pre filtered columns

*) Bug fix

Updated showcase page: http://yadcf-showcase.appspot.com/multiple_tables.html

daniel_r

0.7.2 version is out!

*) Added another external API function : exGetColumnFilterVal, Allows to retreive column current filtered value (support ALL filter types!!!)

*) "data" property (predefined data source for filter) supports array of objects {value: 'Some Data 1', label: 'One'}, {value: 'Some Data 3', label: 'Three'}

*) Bug fix

*) Several code optimizations

daniel_r

0.7.7.beta.1 is out

Added Server side support (atm for non range filters)

http://yadcf-showcase.appspot.com/server_side_source.html

bdunsmuir

Does anyone have this working with DataTables 1.10.0 ? I think the website says it's supported, but I haven't been able to get it to work.

I get an error on the function:
"Uncaught TypeError: undefined is not a function"

daniel_r

It's working with 1.10.0 check the showcase I have several examples with the 1.10.0 double check your code

miya

first I would like to say, this is an awesome plugin - thanks for all the work.
Any idea when date-range will be supported for server side processing?

daniel_r

Thanks, I do have plans for that, but I guess opening a new issue for that will speed it up.

daniel_r

0.8.0.beta.2 is out

Added range_number and range_date support for server side processing (DataTables 1.10)

http://yadcf-showcase.appspot.com/server_side_source.html

tester1

Hi great .. can you please send me download link for PHP SERVER SIDE source code ... as above link dont have any .php file ... connectivity .. also if you can provide in that with ROW DETAILS ... also it should work with any JOIN QUERY ...OR ANY QUERY .... please ... i am struggling here to merge all example of datatables in one file and i am finding it very hard ... as new to ajax and JSON ...

add , edit ( via popup ) , delete , row detailing , search , pagination , any query can be run ... ( all this in single example file ) - php mysql

thanks

also i have add this request at gmail group

daniel_r

Hi,

You are welcome, I'm not a PHP user (Using Java) , so I'll post the relevant Java code for you:

Here an example of how you should get it on server (example for the fifth column) - getting parameter from request

String sSearch_4 = req.getParameter("columns[4][search][value]");

This is how you get the min/max or from/to values on your server side, delimited by "-yadcf_delim-" (same idea for the range_date from/to)

String[] minMax = sSearch_4.split("-yadcf_delim-");
Integer min = null;
Integer max = null;
if(minMax.length > 0) {
min = tryParse(minMax[0]);
}
if(minMax.length > 1) {
max = tryParse(minMax[1]);
}

Regarding the add/delete/edit, you better ask on datatables forum because I'm not a pro in this

jjsteward

Your plugin looks great. I had a question though.... many times column data may be blank or null, does your plug-in provide the option to filter on data that is null or blank?

Also, it would be nice if your sample data for the demos included a column with actual dates. just sayin'

Thanks!!