Tablepress feature request – exclude column, exact search

  • Resolved prink1

    (@prink1)


    12 years, 7 months ago

    Really like the plugin, and I’d be willing to pay for these features. I have a couple of large tables that I use as sort of a site index. I teach English to Japanese people, and one of my tables is like a searchable dictionary.

    Column 1 has the English word.
    Column 2 has the Japanese definition.

    Because column one also contains html that links each entry to its main page using target=”_blank”, searching “get” will return everything. So, I need to either put the link in a separate column and exclude that column from search or make it so that “get” doesn’t return words containing “get” like “target”.

    Like I’m said, I’m willing to pay for a solution here, and if you already have something implemented to solve this, I’ll pay for a personalized explanation. I didn’t see anything when I search around for a solution.

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

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

    (@tobiasbg)

    12 years, 7 months ago

    Hi,

    thanks for your post!

    Unfortunately, excluding HTML (or certain words, like “target”) from the search is not possible, as all cell contents are treated as text by the search algorithm.
    Thus, you should look into the idea of having a separate column, and that’s actually quite easy to achieve:
    1. On the table’s “Edit” screen, add a new column (probably right next to the column with the links) and add the words there again.
    2. Then, on the same page, add this to the “Custom Commands” textfield:

    "aoColumnDefs": [ { "bSearchable": false, "aTargets": [ 0 ] }, { "bVisible": false, "aTargets": [ 1 ] } ]

    That will prevent the first column (the columns with the links) of the table from being searchable (indicated by the “0”), and it will hide the second column (the column with just the words) of the table from the user (indicated by the “1”).

    Regards,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘Tablepress feature request – exclude column, exact search’ is closed to new replies.