WordPress.org

Ready to get started?Download WordPress

Forums

TablePress
[resolved] Enhanced search options ?? (26 posts)

  1. MommyBlogDesigns
    Member
    Posted 1 year ago #

    Hi!! LOVE your plug-in!! I just downloaded it and I'm having tons of fun playing with it!! I've run into a question though. I'm setting up a coupon database for a customer and she is wanting to have some extra search boxes above the database. This is an example that she gave me:
    http://www.mrsjanuary.com/coupon-database/
    Note the filter search and quick link buttons. Is there any way we can do something that that with this plug-in? I know the columns are all sortable ... and that is great! But can we somehow add these enhanced searches too?

    The site I'm working on now is:
    http://demo-extremecouponmom.mommy-blog-designs.com/canadian-coupons/

    Thanks so much!!
    Ro :)

    http://wordpress.org/extend/plugins/tablepress/

  2. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    thanks for your question. Great to hear that you like TablePress so much! :-) (Don't forget to rate it here in the plugin directory then. Thanks!)

    Regarding your question:
    Well, this should be possible, but I don't really have a readily usable solution. The search/filter and sorting functionality is coming from the DataTables JavaScript library (see http://www.datatables.net) that TablePress uses. That library does have an extensive API, so that it is possible to develop and program custom search/filter behavior in JavaScript. Unfortunately, I don't really have experience with this, so I can't really help with this :-(

    One thing that I can offer is the functionality that you can see here:
    http://datatables.net/extras/thirdparty/ColumnFilterWidgets/DataTables/extras/ColumnFilterWidgets/
    There's a drop down box for each column that allows to quickly filter certain values.
    I have packaged the JavaScript code that is necessary for this into a "TablePress Extension" (see http://tablepress.org/extensions/ for the concept behind this). To get that functionality, just install and activate http://tablepress.org/download/extension/tablepress-datatables-column-filter-widgets.zip as a regular WordPress plugin.

    For each table that shall get this, then change the Shortcode in the page from something like

    [table id=123 /]

    to

    [table id=123 datatables_columnfilterwidgets=true /]

    Regards,
    Tobias

  3. MommyBlogDesigns
    Member
    Posted 1 year ago #

    Hi Tobias,

    Thanks so much for your super fast reply!! I gave your suggestion a try ... and it seems to look great. I'll see if my client is happy with it like that. Thanks again!!
    Ro :)

  4. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    sure, no problem! Great to hear that this will help!

    For your table, it will probably make sense to not show a dropdown for the contents of the first column, as the name will likely be unique anyway. I therefore suggest to change your Shortcode once more, to

    [table id=1 datatables_columnfilterwidgets=true datatables_columnfilterwidgets_exclude_columns=1 /]

    Regards,
    Tobias

  5. MommyBlogDesigns
    Member
    Posted 1 year ago #

    Great idea! I just tried adding in the new shortcode, but it didn't affect the 1st column. Please confirm the shortcode.

    Thanks again!!!! :)

  6. MommyBlogDesigns
    Member
    Posted 1 year ago #

    Also Tobias ... is it at all possible to use the term 'COUPONS' instead of 'ENTRIES' in the footer of the table? Where would I go to change that?

    You are awesome!!!

  7. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    yes, the Shortcode is correct. Did you really add

    datatables_columnfilterwidgets_exclude_columns=1

    ?

    About changing "entries" to "coupons": That's possible with another TablePress Extension. Please see http://tablepress.org/extensions/change-datatables-strings/ for more information.

    Regards,
    Tobias

  8. LugaGuga
    Member
    Posted 1 year ago #

    Hello Tobias,
    Thanks for your great plugin! I'am exactly on the same thing to add more search options to the table. With the dropdwon menu, this would be fantastic! I will try it with the shortcode and the extensions you provided.

    Another input: maybe other people don't like, but I would even pay for this plug-in with all the extensions inluded. Youl could sell it through codecanyon by themeforest.

    Autoimporter

    Danke vielmals für dein super plugin!
    Grüsse, Luigi

  9. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi Luigi,

    thanks for your feedback! Great to hear that you like the plugin and the dropdown extension!

    About your suggestion: Currently, I have no intention to make the plugin commercial (and certainly not through a site like CodeCanyon, as there's some trouble going on right now with the company behind it and their understanding of the spirit of open source software). I see TablePress as my way of giving back to the WordPress community. (I do however appreciate donations to support my work, so feel free :-) )

    Best wishes,
    Tobias

  10. LugaGuga
    Member
    Posted 1 year ago #

    Hi Tobias,

    have done the donation ;-) I do understand that free thing. But I am working now as a newbee already for more than one year with wordpress and when you want that a plugin is supported and the author has an incentive I prefer much more to pay a small amount than to have a free plugin .

    All my themes, expcept one from woo, I have from themeforest. There is no other option.

    Will try to know exclude some coulmns in the short code you provided. Will give you fast feedback.

    Best, Luigi

  11. LugaGuga
    Member
    Posted 1 year ago #

    Hi Tobias,

    just a feedback: to exclude a column is not working, see my shortcode below. Would be great to have this!!!

    [table id=5 datatables_columnfilterwidgets=true datatables_columnfilterwidgets_exclude_columns=1 /]

    Best, Luigi

  12. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi Luigi,

    ok, thanks for testing this! As two people have now reported that the parameter is not working, I'll take another look at the code and report back shortly.

    Regards,
    Tobias

  13. LugaGuga
    Member
    Posted 1 year ago #

    Hi Tobias,

    Thank you so much! Have a nice weekend.

    Regards, Luigi

  14. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    Luigi, thanks for your donation, I really appreciate it! And I can understand your point about support for plugins. For me, all of this is just a hobby though, and I'm not a professional developer. So, charging doesn't really feel right, and it would put me under a lot more pressure. I'll stick with the free/donation way for now :-)

    Now, back to the ColumnFilterWidgets: I checked the code again, and there was indeed a small problem that showed itself as an edge case bug, only when the excluded column is "1". All other columns and combinations (like "1,2,3") worked fine.

    I fixed this bug and also took that opportunity to make the Extension compatible with the upcoming new version 0.9-RC of TablePress.
    So, to use the fixed version, please first install the latest TablePress development version from http://downloads.wordpress.org/plugin/tablepress.zip (just replace the existing "tablepress" folder on your server with the one from the ZIP archive).
    Then, also replace the Extension with a fresh download from http://tablepress.org/download/extension/tablepress-datatables-column-filter-widgets.zip
    After that, the Shortcode should work as intended, and the first column should be excluded.

    Regards and have a nice weekend, too!
    Tobias

  15. LugaGuga
    Member
    Posted 1 year ago #

    Hello Tobias

    Works perfectly! Thank you again very much for the work and hours you have already devoted to this project!

    Hope you had a nice weekend, w/o coding ;-)

    Best,

    Luigi

  16. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi Luigi,

    awesome! Great to hear that this worked! Thanks for the confirmation!

    And no, of course I did some coding over the weekend, as I finally released version 0.9-RC of TablePress :-)

    Best wishes,
    Tobias

  17. LugaGuga
    Member
    Posted 1 year ago #

    Hi Tobias,

    Oh, sorry for the coding at the weekend. And still going on now....

    About exculding coulmns. I wanted not only to exclude one column for the dropdown, but more than one. But I realised that it woks only for one column. May it be possible to exclude several coulmns?

    Best wishes,

    Luigi

  18. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi Luigi,

    oh, coding is fun for me, even on the weekend! No problem :-)

    Yes, you can exclude several columns! Just write them as a comma-separated list in the Shortcode, like

    datatables_columnfilterwidgets_exclude_columns="1,4,8"

    Regards,
    Tobias

  19. LugaGuga
    Member
    Posted 1 year ago #

    Hi Tobias,
    Wow, great! works! Sorry to have have bothered you. This plguin is so great with the multiple filter/dropdown functionality people will love it!!!!!!

    Saw that an other problem with loading only one table for showing several table has also already implemented :-)

    Tobias, go on! :-) Your work is absolutly amazing!! Hope you can trun this project somewhere in the future in a project where you could make a living of it. Probably you could already now! But maybe you have other plans. Againa, Thanks!!!

    Regards,
    Luigi

    p.s. Hope that you will receive a lot of positive feedback!

  20. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    no problem, you are very welcome! :-) Thanks for your encouraging words, I really appreciate it!

    Best wishes,
    Tobias

  21. huwang
    Member
    Posted 1 year ago #

    To MommyBlogDesigns,

    Hello, I just came cross your site (http://www.mrsjanuary.com). The thing really interest me is how you have the searchbox and start search button to search the Tablepress table. Can you please give me some idea how to achieve it?

    What I want to do is have a search box in my front page and then search the Tablepress table in another page.

    Thanks a lot if you can share some info with me.

  22. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    thanks for your question. As you have asked basically the same in the thread at http://wordpress.org/support/topic/how-can-i-put-the-search-box-into-a-widget-area I will answer there shortly.

    Regards,
    Tobias

  23. kryzler
    Member
    Posted 8 months ago #

    is there a way to add a range for example
    Number of years (drop down or search box) 5 -(drop down or search box) 10. or this is a better example http://www.mediafire.com/?8jj14hawlylhadw

  24. TobiasBg
    Member
    Plugin Author

    Posted 8 months ago #

    Hi,

    thanks for your question.

    Sorry, from what I know, this is not possible directly or without custom coding. You'll need to develop something on a custom basis for your site, e.g. with the help of http://datatables.net/examples/plug-ins/range_filtering.html

    Regards,
    Tobias

  25. kryzler
    Member
    Posted 8 months ago #

    i was thinking maybe its possible to clone a drop down and maybe that does the trick. By the way great plug in!.

  26. TobiasBg
    Member
    Plugin Author

    Posted 8 months ago #

    Hi,

    I don't think that it will be that easy, sorry :-( Unfortunately, I don't know what the best approach would be here, as I'm not the developer of that piece of JavaScript code. I only made it available for use as a TablePress Extension, and therefore can not help with such customizations.

    Regardless, good to hear that you like the plugin! :-) I'd appreciate it, if you would rate TablePress here in the plugin directory. Thanks!

    Regards,
    Tobias

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic