Combining filter row_order and hide_columns

  • Resolved Johan Legrand

    (@johan-legrand)


    12 years, 5 months ago

    Hi,

    I have a question about my table on this page: http://www.us-ophain.be just below “Activités et festivités du Club”

    I actually try to use a combination of different functions:
    – filter_full_cell_match=”true”
    – row_order=”SORT”
    – row_order_sort_column=”C”
    – row_order_sort_direction=”DESC”
    – filter=”activité fort”
    – hide_columns=4,5,6,7,8

    All of them works like a charm except the sorting function.
    Do you think there is a workout to combine all of these?

    Thanks,
    Johan

    http://ww.wp.xz.cn/plugins/tablepress/

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

    (@tobiasbg)

    12 years, 5 months ago

    Hi Johan,

    thanks for your question, and sorry for the trouble.

    Please try with a lower case "sort" for the row_order parameter:

    row_order="sort"

    The capitalized version of this value will not work here.

    Regards,
    Tobias

    Thread Starter Johan Legrand

    (@johan-legrand)

    12 years, 5 months ago

    Hello Tobias,

    Thanks for your reply. I tried already several combinations but without any success.
    For the moment I use the following code:

    [table id=12 filter_full_cell_match=”true” use_datatables=”false” row_order=”sort” row_order_sort_column=”Date” row_order_sort_direction=”DESC” filter=”activité fort” hide_columns=4,5,6,7,8 /]

    Full cell match works well, filter and hide columns works like a charm but the third column “Date” (or “C”) is never sorted.
    Could it be the date format I use that is bothering?

    Regards,
    Johan

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    12 years, 5 months ago

    Hi Johan,

    that Shortcode looks good, except for that "Date" value. That has to be either “C” or “3”.
    However, the actual problem likely is that those are date values. The sorting algorithm in the Extension currently can only sort strings, but not dates, so that’s where the wrong order might be coming from 🙁

    How about manually sorting the rows (via drag and drop) on the “Edit” screen beforehand? You won’t need the Row Sorting then.

    Regards,
    Tobias

    Thread Starter Johan Legrand

    (@johan-legrand)

    12 years, 5 months ago

    Hi Tobias,

    Ok, I will do that. Thanks for your answer.

    For your info, the main problem is that some tables contains columns I use as a filter, columns that are never displayed (Thanks to the great option ‘filter_full_cell_match’ and ‘hide_columns’!). Doing so I can display some lines only on some pages and not display them on other pages and based on the same table I can filter the lines differently for other pages by using another column as filter.
    One table contains data for several pages and several subjects…

    Regards,
    Johan

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    12 years, 5 months ago

    Hi Johan,

    yes, that’s a great use case of the hiding and filtering 🙂 Very nice!

    Best wishes,
    Tobias

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

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

The topic ‘Combining filter row_order and hide_columns’ is closed to new replies.

Tags