Tablepress- Columnfilter widget – some fields can't filter.

  • Resolved Anonymous User 11014282

    (@anonymized-11014282)


    9 years, 5 months ago

    Dear Tobias.
    This is my 3 support tkt & all my previous tks are resolved by your valuable quicksupport.

    Now the issue is,
    1. Im using tablepress with column filter widgets
    2. My table has ~800 rows & 5 columns(Name, Language Date, Location, etc.,)
    3. All columns working fine except the Schedule column(Date)
    4. I uploaded as CSV file. I tried delete the table & recreated.
    5. Some date selections show no rows even got values inside. (ex:”02&03RD DEC”)

    Please help me. ThnX..

    My link is:
    http://eversafe.com.sg/es/?page_id=2081

    https://wordpress.org/plugins/tablepress/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    9 years, 5 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    The problem seems to be coming from the & which is causing in the JavaScript somehow. Unfortunately, I don’t see how this can be fixed easily. This would probably have to be done by the ColumnFilterWidgets developer.

    Now, from what I can see, even if this works, it would not be useful, because the “Schedule” dropdown has all the different date combinations, which is not useful for a visitor at all.
    Therefore, I suggest something else: In table, write all dates separately. For example, instead of

    01,02,03,04&05TH DEC

    write

    01TH DEC | 02TH DEC | 03TH DEC | 04TH DEC | 05TH DEC

    with ” | ” as the separator and the full day/month for each date.

    Then, add this parameter to the Shortcode:

    datatables_columnfilterwidgets_separator=" | "

    You will then only get the individual dates in the dropdown, which is much better to use.

    Regards,
    Tobias

    Thread Starter Anonymous User 11014282

    (@anonymized-11014282)

    9 years, 5 months ago

    Dear Mr.Tobias.
    Really happy to have your same kind of quick replies.

    Yes. You found that exact issue, and i replaced all “&” with “,” on my CSV file & than uploaded. Works like charm.

    Thank you.

    Plugin Author TobiasBg

    (@tobiasbg)

    9 years, 5 months ago

    Hi,

    no problem, you are very welcome! 🙂 Good to hear that this helped!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Tablepress- Columnfilter widget – some fields can't filter.’ is closed to new replies.