WordPress.org

Support

Support » Plugins and Hacks » [Resolved] Limit filter keyword search to single column

[Resolved] Limit filter keyword search to single column

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

    @tobiasbg

    Hi,

    thanks for the question.

    Yes, this is possible by adding the filter_columns parameter to the Shortcode, like

    [table_filter id=123 filter_columns="1" /]

    Regards,
    Tobias

    DavidBrugge

    @davidbrugge

    Humm,

    Perhaps I’m not understanding how the filter_columns parameter works.

    I have a three column table. I want to search a name and have the results show only the rows where the name matches column 1.

    I have the shortcode[table_filter id=4 filter_columns="1" /] but when I enter names into the search box, I still get results from columns 2 and 3.

    Am I implementing it wrong, or do I have a misunderstanding of the filter?

    Thanks

    Plugin Author TobiasBg

    @tobiasbg

    Hi,

    ah, ok. So you are refering to the search field directly above the table (the JS search). That’s totally unrelated to the Extensions that you are using, that’s why I might have been confused here.

    Could you maybe explain in more detail what you are trying to achieve, maybe with a link to the page with the table?

    Regards,
    Tobias

    DavidBrugge

    @davidbrugge

    Sorry, didn’t know that they were not connected.

    Assuming that they were, I was testing from the search box on page.

    Here’s the set up. This is for a church. It has Elders who are responsible for a dozen or so individuals and families. The assignments have been totally reworked and I want a way for members to go to the sight and find who their Elder is.

    I have page on with a search form for visitors to enter their name. The form directs to a page with the table. I want the form to filter out for just the family name. This part works fine.

    Members names in column 1, Assigned Elder in column 2, contact link in column 3.

    But when the name is the same as one of the Elders, everyone of the names assigned to the Elder appears. For instance, if Mrs. Jones enters her name and there is an Elder named Jones, then the table shows two pages of names.

    Not a big problem all in all, but not the elegant solution I want.

    Who is my Elder?

    Plugin Author TobiasBg

    @tobiasbg

    Hi,

    thanks for the explanation!

    For this, the suggested Shortcode parameter above is actually the correct solution, as you are using the two Extensions for this functionality (you are also using the JS based Search field above the table, but that’s independent here).

    So,

    [table_filter id=4 filter_columns=1 /]

    does not bring the desired behavior?

    Regards,
    Tobias

    DavidBrugge

    @davidbrugge

    Ah ha!

    The first examples had the numeral 1 within quotes.

    Now it works like a charm.

    Thanks ever so much!

    David

    If, others should come upon this post with the same question, how would one filter multiple columns?

    Plugin Author TobiasBg

    @tobiasbg

    Hi,

    Great to hear that this works now 🙂
    That with the quotes is weird though, as the quotes should not matter at all…

    If you want to filter multiple columns, you can pass a comma-separated list, or an hyphen-delimited range, or both, like

    [table_filter id=4 filter_columns=1-5,7-9,11 /]

    Best wishes,
    Tobias

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

    DavidBrugge

    @davidbrugge

    I have rated it and recommended it highly to my WP users group.
    I can see why your ratings are so high.

    Next paycheck, I owe you a baseball book.

    Plugin Author TobiasBg

    @tobiasbg

    Hi,

    thank you very much, I really appreciate that! 🙂 Great to hear that you like the plugin so much!

    Best wishes,
    Tobias

    help me i want to show data from the tablepress table when the user enter the key word enter in the search bar in the tablepress. like this site when enter the country name then show the data .the site link is
    http://www.menatelecom.com/en/residential/talk-rates.html
    but i want to search only user name ,designation and city name please help he i install the tablepress .

    help me i want to show data from the tablepress table when the user enter the key word enter in the search bar in the tablepress. like this site when enter the country name then show the data .the site link is
    http://www.menatelecom.com/en/residential/talk-rates.html
    but i want to search only user name ,designation and city name please help he i install the tablepress .

    Plugin Author TobiasBg

    @tobiasbg

    Hi,

    thanks for your question, and sorry for the trouble.

    Please try the suggestio that I made in the other thread at http://wordpress.org/support/topic/how-to-hide-the-whole-table-only-display-after-searching?replies=7

    Regards,
    Tobias

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘[Resolved] Limit filter keyword search to single column’ is closed to new replies.