Title: Filter data
Last modified: August 30, 2016

---

# Filter data

 *  Resolved [Rioxs](https://wordpress.org/support/users/rioxs/)
 * (@rioxs)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/filter-data/)
 * Hello, is there anyway that I can filter the data showed in the page/post from
   my database?
 * For example, something like this [Filter Image](http://www.telerik.com/help/winforms/media/gridview-filtering-excel-like-filtering001.jpg)
 * The idea is to obtain all user data from my database (MySQL) and filter the data
   I need without make any query or modify the page/post query… I don’t know if 
   I make myself clear.
 * Great plugin btw!
    Thanks and waiting for your quick response!
 * [https://wordpress.org/plugins/inline-google-spreadsheet-viewer/](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)

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

 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/filter-data/#post-6215862)
 * There’s a text filter added to every table. Unless you moved it, it’s in the 
   top-right corner of each table. The text filter lets you hide rows that don’t
   match a given phrase.
 * If you’re trying to filter the table data _before_ it gets printed to the screen,
   then you need to write a custom function in your `functions.php` file and attach
   that function to the `gdoc_table_html` [filter hook](https://codex.wordpress.org/Plugin_API/Filter_Reference).
 *  Thread Starter [Rioxs](https://wordpress.org/support/users/rioxs/)
 * (@rioxs)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/filter-data/#post-6215865)
 * I mean for the printed data. The option Show/Hide Columns, hide the complete 
   column, what I was trying to say is filter the column not hide… for example:
 * Column A Column B
    Name 1 Brazil Name 2 Brazil Name 3 USA Name 4 Brazil
 * In this case, filtering the Column B by the keyword “Brazil”, the results will
   show in the webpage as:
 * Column A Column B
    Name 1 Brazil Name 2 Brazil Name 4 Brazil
 * Without the Name3 which has USA.
 * Is it possible?
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/filter-data/#post-6215873)
 * Yes. Like I said, there’s a text filter at the top-right of each table, right
   next to the “Show/Hide Columns” button. If you have that table and start typing“
   Brazil” in that text field, the only rows that will show are the ones with “Brazil”
   somewhere in them.
 *  Thread Starter [Rioxs](https://wordpress.org/support/users/rioxs/)
 * (@rioxs)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/filter-data/#post-6215930)
 * Excellent Meitar thanks for your response. One last thing, that filter (text 
   field) accept multiple columns or only one?
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/filter-data/#post-6215935)
 * Try it and see. 😉
 *  Thread Starter [Rioxs](https://wordpress.org/support/users/rioxs/)
 * (@rioxs)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/filter-data/#post-6215936)
 * It works perfectly =)
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/filter-data/#post-6215943)
 * 😉

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

The topic ‘Filter data’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/inline-google-spreadsheet-viewer.
   svg)
 * [Inline Google Spreadsheet Viewer](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/)
 * [Active Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/reviews/)

## Tags

 * [filter](https://wordpress.org/support/topic-tag/filter/)

 * 7 replies
 * 2 participants
 * Last reply from: [Meitar](https://wordpress.org/support/users/meitar/)
 * Last activity: [10 years, 11 months ago](https://wordpress.org/support/topic/filter-data/#post-6215943)
 * Status: resolved