Yet Another DataTables Column Filter - (yadcf) - Page 2

Yet Another DataTables Column Filter - (yadcf)

24

Replies

  • trapagualtrapagual Posts: 6Questions: 0Answers: 0
    Thanks for the ultra-rapid response. I'll wait for the next release for "text" mode.
    Walt
  • MikeSMikeS Posts: 113Questions: 1Answers: 0
    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_rdaniel_r Posts: 460Questions: 4Answers: 67
    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.
  • trapagualtrapagual Posts: 6Questions: 0Answers: 0
    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_rdaniel_r Posts: 460Questions: 4Answers: 67
    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
  • trapagualtrapagual Posts: 6Questions: 0Answers: 0
    Done
    Working perfectly.
    Thank you very much again.
    I'm afraid I'm a little lost with this javascript thing.

    Walt
  • daniel_rdaniel_r Posts: 460Questions: 4Answers: 67
    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/
  • loukinglouking Posts: 259Questions: 52Answers: 0
    edited March 2014
    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_rdaniel_r Posts: 460Questions: 4Answers: 67
    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
  • trapagualtrapagual Posts: 6Questions: 0Answers: 0
    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_rdaniel_r Posts: 460Questions: 4Answers: 67
    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" .
  • trapagualtrapagual Posts: 6Questions: 0Answers: 0
    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
  • loukinglouking Posts: 259Questions: 52Answers: 0
    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_rdaniel_r Posts: 460Questions: 4Answers: 67
    edited April 2014
    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
  • loukinglouking Posts: 259Questions: 52Answers: 0
    great, thanks!
  • daniel_rdaniel_r Posts: 460Questions: 4Answers: 67
    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
  • WaynefWaynef Posts: 9Questions: 0Answers: 0
    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_rdaniel_r Posts: 460Questions: 4Answers: 67
    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_rdaniel_r Posts: 460Questions: 4Answers: 67
    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_rdaniel_r Posts: 460Questions: 4Answers: 67
    edited May 2014

    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_rdaniel_r Posts: 460Questions: 4Answers: 67
    edited June 2014

    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_rdaniel_r Posts: 460Questions: 4Answers: 67

    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

  • bdunsmuirbdunsmuir Posts: 17Questions: 4Answers: 0

    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_rdaniel_r Posts: 460Questions: 4Answers: 67

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

  • miyamiya Posts: 2Questions: 0Answers: 0

    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_rdaniel_r Posts: 460Questions: 4Answers: 67

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

  • daniel_rdaniel_r Posts: 460Questions: 4Answers: 67

    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

  • tester1tester1 Posts: 53Questions: 14Answers: 1

    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_rdaniel_r Posts: 460Questions: 4Answers: 67

    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

  • jjstewardjjsteward Posts: 3Questions: 1Answers: 0

    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!!

This discussion has been closed.