DE Date table filter

  • Resolved Florian

    (@pictibe)


    7 years, 6 months ago

    Hi Tobias,

    i read this topics but it doesnt work. Is it deprecated?
    https://ww.wp.xz.cn/support/topic/display-by-date/

    I use this shortcode:

    [table id=1 datatables_locale="de_DE" responsive=flip responsive_breakpoint=tablet datatables_columnfilter=true datatables_fixedheader=top datatables_columnfilterwidgets=true datatables_columnfilterwidgets_exclude_columns=1,2,3,5,8,9 filter_date=future filter_date_columns=2 row_order=sort row_order_sort_column=B row_order_sort_direction=ASC /]

    and

    "columnDefs": [ { "type": "date-de", "targets": [ 2 ] } ], "order": [[ 2, 'asc' ]]

    and this small shortcode wont work too:

    [table id=1 filter_date=future filter_date_columns=2 /]

    I find the documentation but i cant get it work: https://datatables.net/plug-ins/sorting/

    This plugins are activated:

    TablePress Extension: DataTables Column Filter

    TablePress Extension: DataTables ColumnFilterWidgets

    TablePress Extension: DataTables FixedHeader

    TablePress Extension: DataTables Sorting plugins

    TablePress Extension: Responsive Tables

    TablePress Extension: Row Filtering

    TablePress Extension: Row Filtering based on date

    TablePress Extension: Table Row Order

    The date have the normal German date format: 17.11.2018

    Any solution?

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 6 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    The Row Filter by Date Extension does only support the mm/dd/yyyy format.

    (In addition, but a separate issue, date-de does not exist in your “Custom Command”, only date-eu.)

    Regards,
    Tobias

    Thread Starter Florian

    (@pictibe)

    7 years, 6 months ago

    Wow, thanks for the fast reply. And how can we filter by German date?
    Is it possible with commands to adapt from / to .?

    The extra column with /-date is not a user friendly solution.

    • This reply was modified 7 years, 6 months ago by Florian.
    Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 6 months ago

    Hi,

    no, sorry, that’s not directly possible, due to the used date comparison functions.
    Your best chance is to add an extra column with the mm/dd/yyyy date format to your table, and use that for the filtering. You could then hide that column from the visitor on the “Edit” screen or using CSS code.

    Regards,
    Tobias

    Thread Starter Florian

    (@pictibe)

    7 years, 6 months ago

    if i change the date without extra row and set / between numbers, the rows arent displayed. I can’t understand what happened.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 6 months ago

    Hi,

    I’m not sure what you mean here. Do you have an example?

    Also, I can only recommend to do this step by step. The large first Shortcode that you posted will definitely lead to problems and it will not even work like this.

    Regards,
    Tobias

    Thread Starter Florian

    (@pictibe)

    7 years, 6 months ago

    If i change the date from 22.11.2018 to 22/11/2018, then the row goes away in frontend. I test the large and the small shortcode on one site to compare the solutions.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 6 months ago

    Hi,

    22/11/2018 is still the wrong format, it’s dd/mm/yyyy. You need to change it to mm/dd/yyyy, which would be 11/22/2018 in this example.

    Regards,
    Tobias

    Thread Starter Florian

    (@pictibe)

    7 years, 6 months ago

    Ok thats no way. Is no German date possible? It couldn’t be so complicated!?!

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 6 months ago

    Hi,

    no, sorry, there is no direct way, as the internal PHP sorting functions don’t directly support this. Your best chance is to use a second (hidden) column with the other format.

    Regards,
    Tobias

    Thread Starter Florian

    (@pictibe)

    7 years, 6 months ago

    Can i book your for a fix?
    Please write me an email if possible: info at pictibe de

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 6 months ago

    Hi,

    unfortunately, I’ll have to disappoint you here. As I’m not a professional web developer, I simply don’t have enough time and ressources to offer such services.

    Regards,
    Tobias

Viewing 11 replies - 1 through 11 (of 11 total)

The topic ‘DE Date table filter’ is closed to new replies.