Ninja Tables offers you a powerful feature known as Custom Filters, which lets you filter data from tables in various ways.

Custom Filter is a Pro Feature!

  • First, go to the Ninja Tables dashboard and click on the Edit option of your preferred table.
  • Next, click the Table Configuration tab and pick Custom Filters from the left menubar.

custom filters in data tables

Add Custom Filters #

  • Click on the Custom Filters, there a new tab will open with an Add New Filter button.

  • Now, click the Add New Filter button, then a pop-up form with a set of configuration options will appear.

custom filter in ninja tables

This pop-up has various options to choose from to make your table’s filter more interactive. The following options can be found in the custom filter pop-up form –

Filter Title #

This input field is for the filter title, which determines the filter name.

Filter Label #

This input field is used if you want to add a label to your filter. Keep it blank if you don’t need any filter instructions in the frontend.

Filter UI Type #

You can choose the filter type to display the filter’s base in the frontend. There are eight subsets in the Filter UI type.

Such as:
-Select Dropdown
-Radio
-Checkbox
-Date Picker
-Date Range
-Text Input
-Number Range
-Reset Filter Button.

Placeholder #

The default placeholder is All. But if you want to change the text, you can type in your desired text.

Value Type #

Select How the value will be populated to the select dropdown. There are two types of Value types, including Manual Data and dynamic Data from the Table.

Manual Data #

When you choose Manual Data, some options will appear below.

manual data in custom filter
Filter Options #

This lets you place the value through which the filter will be implemented. Put your desired values to display on the frontend, be aware that those values need to match your cell data on that table. Filter options feature three sequential fields called LabelFilter Value, and Action Button.

  • Label: The label of the filtered value is entered in the Label field.
  • Filter Value: Put the value you want filtered in the Filter Value field.
  • Action Buttons: There are 2 action buttons to add (+) and delete (-) in each of the Label and Filter Value fields.
Dynamic Data from Table Column #

When choosing Dynamic Data from Value Type, more options will appear below.

  • Target Column: This option enables you to select the column that you want to populate data.
dynamic data custom filter
  • Parse Comma Separated Words: If you enable this option, and you choose multiple value types, values will be shown with Comma.
  • Disable automatic filter Value sorting: By default, value sorting is disabled. The value sorting option will also be activated if you select this option.
  • If Disable automatic filter value sorting is unchecked, then two more options will appear below, such as Sort Dynamic Value as & Sort Algorithm.
  • Sort Dynamic Value as: By this option, you can select either an Ascending order or Descending order.
  • Sort Algorithm: You can sort the algorithm as a text basis or a Numeric basis.
  • Enable Multi-Select: Enable this select field if you want to choose the multi-select value type.
  • Strict Mode: Enable this mode if you want the results to be accurately matching the values.

Filter Columns #

This option is to pick the columns you wish to apply the filter. You can choose any single column, or you can pick multiple columns.

Example of Custom Filters #

Let’s have a look at an example where you could better understand Custom Filters.

  • If you have a table like this with a numeric column (data type must need to as Numeric Value) and you would like to include the option to filter by selecting the range, then you can quickly do it.
custom filter on numeric column

  • You can add a new filter by selecting the Add New Filter button under Custom Filters. Next, enter a filter title, choose the filter UI type and value type, and provide the filter label and value in the filter options. Choose the Column to which you wish to apply the filter as well.

  • Here, For Greater than = {gt} yourValue
  • For Less than = {lt} yourValue
  • From firstValue to lastValue ~firstValue: lastValue

  • Don’t forget to click on the Update button when you are done with your configuration.
select dropdown in custom filter

Filter Appearance #

Once you’ve set the filter, go to the main “Custom Filter” tab.

You can choose any option in Filter Appearance between Show Filter inputs as Inline and Show Filter inputs as Columns.

custom filter appearance

  • Show Filter inputs as Inline: It will show the filter inputs in a row.
  • Show Filter inputs as Columns: The filter input area will be displayed as a column.

See how Filter Appearance works in the table.

custom filter appearance

Here’s a WP Posts table created with Ninja Tables. It has custom filters enabled. The filter UI type is “checkbox.” You can select a checkbox and the corresponding filter will apply to the table.

TitleStatus
Jahan Liza05-Jun-24Recovering Lost Sales: 10 Shopping Cart Abandonment SolutionspublishTips
Nusrat Fariha09-Jun-24Announcing Free WordPress Table Templates Page!publishWordPress Plugins
Nusrat Fariha10-May-24How to Create a Product Review Table?publishWordPress Plugins
Jahan Liza30-Apr-247+ Woocommerce Statistics and Trends Shaping Revenue in 2024publishTips, WooCommerce
Nusrat Fariha25-Apr-24Transform Value: Turn Text into HyperlinkpublishNinja Tables
Mohiuddin Omran17-Apr-24Misleading Statistics: Learn, Spot, Avoid, and Get Rid of them publishTips
Jahan Liza03-Apr-24A Guide to Comparison Tables for Products, Services, and FeaturespublishTips
Nusrat Fariha19-Mar-24Ninja Tables Features That Simplify Your LifepublishNinja Tables
Jahan Liza06-Mar-247 Techniques to Speed up WooCommerce CheckoutpublishTips, WooCommerce
Editorial Panel01-Mar-245 Best WordPress Pricing Table Plugins in 2024publishWordPress Plugins
Jahan Liza27-Feb-24Ninja Tables Turns 6!publishNinja Tables, Review
Jahan Liza28-Feb-24Color Palettes for Data VisualizationpublishTips
Nusrat Fariha09-Feb-24Best Chart Plugins in WordPress: Improve UX with Interactive ChartspublishTips, WordPress Plugins
Mohiuddin Omran26-Jan-24How to Make a Graph in Google SheetspublishTips
Jahan Liza15-Jan-24Export-Import Tables in WordPresspublishNinja Tables, Tips
Mohiuddin Omran10-Jan-24Best jQuery Table Plugins in 2024publishTips, WordPress Plugins
Jahan Liza28-Dec-23Mapping Tomorrow: Emerging Data Trends for 2024publishTips
Mohiuddin Omran22-Dec-23FluentSnippets Review: Facts, Features, and AlternativespublishReview, WordPress Plugins
Nusrat Fariha09-Jan-24Links in Data Tables: Dynamic Data VisualizationpublishNinja Tables
Mohiuddin Omran04-Dec-23Amazon Affiliate Program: Everything You Need to KnowpublishTips
Nusrat Fariha20-Dec-23Ninja Tables in 2023: Year In ReviewpublishNinja Tables, Review
Jahan Liza23-Nov-23Conditional Formatting in WordPress TablespublishTips, WordPress Plugins
Jahan Liza07-Nov-23Guiding Data Table Examples for Great Website VisualizationpublishTips
Tanzil Ebad Chowdhury27-Oct-239 WordPress Data Visualization Plugins You Can't Overlook!publishWordPress Plugins
Jahan Liza20-Oct-23Introducing FluentBooking: WordPress Scheduling PluginpublishReview, WordPress Plugins
Jahan Liza18-Oct-23Get in The Spirit of Holiday Sales with 13 Halloween Marketing IdeaspublishTips
Mohiuddin Omran12-Oct-23Bootstrap Table: Beginners Guide with Usable ExamplespublishTips
Mohiuddin Omran27-Sep-23A Comprehensive Guide on How to Center a Table with CSSpublishTips
Jahan Liza07-Sep-23How to Generate Leads, Increase User Engagement, and Drive TrafficpublishTips
Nusrat Fariha24-Aug-23FOMO Marketing Ideas: Create Urgency and Drive ConversionspublishTips
Tanzil Ebad Chowdhury23-Aug-237+ Dynamic Data Types: Toolkit for Configuring Table ColumnspublishTips, WordPress Plugins
Jahan Liza21-Aug-23How to Create Stackable Tables with Ninja TablespublishNinja Tables, WordPress Plugins
Jahan Liza31-Jul-23How to Add Media to a Data TablepublishNinja Tables, WordPress Plugins
Tanzil Ebad Chowdhury27-Jul-232 Easy Ways to Merge Cells in WordPress Tables (+Pro Tips)publishNinja Tables, Tips
Nusrat Fariha20-Jul-23Simplifying Data Presentations & Common MistakespublishNinja Tables, Tips
Mohiuddin Omran18-Jul-23How to Make a Table in Google Sheets: In-depth TutorialpublishTips
Tanzil Ebad Chowdhury12-Jul-237 Types of Comparison Charts for Effective Data VisualizationpublishTips
Jahan Liza14-Jul-23Closer Look at Charts vs Tables: The Right Data VisualizationpublishComparison, Ninja Tables
Mohiuddin Omran03-Jul-23How to Write a Google Review for a Company + ExamplespublishReview, Tips
Nusrat Fariha22-Jun-23Effective Summer Marketing Tips to Boost Your SalespublishTips
Jahan Liza19-Jun-23How To Design a Table the Right Way: Mastering Data Table DesignpublishNinja Tables, Tips
Tanzil Ebad Chowdhury15-Jun-23Creating Responsive Tables in WordPress | No-Code SolutionpublishNinja Tables
Md Shahjahan08-Jun-23Introducing Ninja Tables 5.0.0: Smoother, Lighter, and More PowerfulpublishNinja Tables
Nusrat Fariha02-Jun-23How To Customize Default WooCommerce ButtonpublishNinja Tables, WooCommerce
Jahan Liza07-Jun-23Limitations of WooCommerce and Best AlternativespublishNinja Tables, WooCommerce
Tanzil Ebad Chowdhury25-May-23TablePress vs Ninja Tables: Which Is Better?publishComparison
Jahan Liza22-May-23What Makes a Good Website: Checklist for Business OwnerspublishTips
Mohiuddin Omran11-May-23TablePress Review: Is It Worth Upgrading to Pro Or Not?publishComparison, WordPress Plugins
Tanzil Ebad Chowdhury08-May-23Good Data Visualization: Master the Art of Visual StorytellingpublishTips
Nusrat Fariha29-Apr-23Color Customizing WordPress TablespublishNinja Tables, WordPress Plugins
Mohiuddin Omran17-Apr-23WooCommerce Inventory Management: Why, How, WhatpublishTips, WooCommerce
Nusrat Fariha10-Apr-23Table Data Visualization: Efficiency and GuidelinespublishWordPress Plugins
Mohiuddin Omran30-Mar-23WordPress WooCommerce Tutorial: Step-by-Step GuidepublishWooCommerce
Mohiuddin Omran30-Mar-23History, Pros, Cons, and Brief Overview of WooCommercepublishWooCommerce
Nusrat Fariha23-Mar-23Optimize WooCommerce for Higher Conversion RatespublishWooCommerce
Mohiuddin Omran08-Mar-23Data Visualization Basics, Skills & TechniquespublishTips
Nusrat Fariha07-Mar-23Reviews of Ninja Tables Google Sheets IntegrationpublishWordPress Plugins
Mohiuddin Omran23-Feb-23Making a Product Comparison Table in WordPresspublishNinja Tables, WordPress Plugins
Mohiuddin Omran17-Feb-23Ninja Tables Is Turning 5!publishNinja Tables, Review
Nusrat Fariha10-Feb-23Easily Add Restaurant Reservation System to WordPresspublishTips, WordPress Plugins
Mohiuddin Omran07-Feb-23Valentine’s Day Marketing Ideas, Strategies & ExamplespublishNinja Tables, Tips
Nusrat Fariha06-Feb-23Create Charts in WordPress With a Free Charts PluginpublishNinja Tables
Nusrat Fariha02-Feb-23How To Create WP Posts TablepublishNinja Tables
Mohiuddin Omran27-Jan-23Valentine’s Ideas for Your Business to Celebrate LovepublishTips
Nusrat Fariha24-Jan-23Ninja Tables Free vs PropublishNinja Tables, WordPress Plugins
Mohiuddin Omran10-Jan-23Ways to Create a Responsive Table in WordPresspublishNinja Tables, Tips
Nusrat Fariha11-Jan-23Best WooCommerce Product Table PluginspublishWooCommerce, WordPress Plugins
Nusrat Fariha03-Jan-23How To Integrate WooCommerce With Ninja TablespublishNinja Tables, WooCommerce
Mohiuddin Omran14-Dec-22Ninja Tables 2022 Year in Review: What's New, What's next?publishNinja Tables, Review
Nusrat Fariha09-Dec-22Designing Data Tables for ChristmaspublishTips, WooCommerce
Mohiuddin Omran07-Dec-22Bad Data Visualization Examples: Fix It or Risk ItpublishTips
Mohiuddin Omran04-Jan-23Easiest Way to Make Beautiful Restaurant Menu for WebsitepublishNinja Tables, Tips
Mohiuddin Omran10-Nov-22Use SEO-Optimized Tables to Get Rich Snippets in SERPpublishTips
Nusrat Fariha09-Nov-22Ninja Tables Advanced Features ExplainedpublishNinja Tables
Mohiuddin Omran03-Nov-22wpDataTables Review: Pros, Cons, Pricing, and SubstitutepublishReview, WordPress Plugins
Mohiuddin Omran31-Oct-22How to Design A Converting Pricing Table to Engage CustomerspublishNinja Tables, Tips
Nusrat Fariha27-Oct-22Marketing Tips to Increase Sales for WordPress UserspublishTips
Mohiuddin Omran24-Oct-22How To Create League Points Table in WordPress with Ninja TablespublishNinja Tables, Tips
Nusrat Fariha19-Oct-22Online Pricing Tables Without CodingpublishNinja Tables
Md Shahjahan13-Oct-22Ninja Tables 4.3.1: Bug Fixes And A Lot of ImprovementspublishNinja Tables
Nusrat Fariha06-Oct-22WooCommerce Halloween Sales 2023publishNinja Tables, WooCommerce
Mohiuddin Omran04-Oct-22Comparison Table Best Practices to Boost Customer ExperiencepublishNinja Tables, Tips
Mohiuddin Omran27-Sep-22Pricing Tables: Strategies, Examples, and Best PracticespublishNinja Tables, Tips
Mohiuddin Omran15-Sep-22Paymattic: The Ultimate Payment and Fundraising PluginpublishReview, WordPress Plugins
Mohiuddin Omran09-Sep-22Best WooCommerce Product Table AlternativespublishComparison, WooCommerce
Mohiuddin Omran02-Sep-22wpDataTables Alternatives: Best Way to Visualize Table DatapublishComparison
Mohiuddin Omran29-Aug-22How To Create WooCommerce Product Table EffortlesslypublishNinja Tables, WooCommerce
Nusrat Fariha26-Aug-22Barn2 Plugins Vs Ninja Tables | Posts Table & WooCommerce Product TablespublishComparison, WooCommerce
Nusrat Fariha23-Aug-22Barn2 Plugins Bundle Offer or Standalone Ninja Tables?publishComparison, WooCommerce
Nusrat Fariha19-Aug-22Ninja Tables vs wpDataTables | Best Table Plugin in WordPresspublishWordPress Plugins
Mohiuddin Omran18-Aug-22Diving into the Best Table Plugins With Google Sheets IntegrationpublishWordPress Plugins
Nusrat Fariha15-Aug-22A Beginner’s Guide to Ninja Tables Drag and Drop BuilderpublishNinja Tables
Mohiuddin Omran12-Aug-22Best TablePress Alternatives to Make Data Tables More EfficientpublishComparison
Mohiuddin Omran10-Aug-22Image Gallery Plugin for WordPress: Create Awesome GalleriespublishNinja Tables, Tips
Mohiuddin Omran06-Aug-22How to Create an Image Gallery in WordPresspublishNinja Tables, Tips
Nusrat Fariha23-Sep-22The Right Tools To Boost WooCommerce SalespublishWooCommerce, WordPress Plugins
Mohiuddin Omran29-Jul-22How to Create Responsive Tables Without Compromising UXpublishNinja Tables
Nusrat Fariha02-Aug-22WordPress Tables With Online Form EntriespublishNinja Tables
Mohiuddin Omran27-Jul-22Product Comparison Table: Best WP Plugin to Create Amazon Affiliate TablespublishWordPress Plugins
Mohiuddin Omran22-Jul-226 Strategies to Optimize WooCommerce Product PagepublishTips, WooCommerce
Mohiuddin Omran18-Jul-22Create Online Tables Easily with Drag and Drop Table BuilderpublishNinja Tables, Tips
Nusrat Fariha25-Jul-22Best Form Plugins in WordPresspublishWordPress Plugins
Nusrat Fariha05-Jul-22Ninja Tables & WP Table Builder ComparedpublishComparison, Ninja Tables
Nusrat Fariha04-Jul-22Why Use Table Plugins | Benefits & ImportancepublishNinja Tables
Nusrat Fariha23-Jun-22Best Drag and Drop Table Plugin In WordPresspublishNinja Tables
Nusrat Fariha23-Jun-22Best Uses of Ninja Tables For WooCommercepublishNinja Tables, WooCommerce
Nusrat Fariha23-Jun-22Best Uses Of WooCommerce Table PluginspublishNinja Tables, WooCommerce
Nusrat Fariha22-Jun-22Google Sheets Integration In WordPress TablepublishNinja Tables
Nusrat Fariha22-Jun-22Best Ways To Create WordPress TablespublishNinja Tables

Progressive Filter #

The user can filter any dynamic options in Progressive Filter to quickly access his specific requirements or desires. This option is enabled by default.

Let’s see how this works!

This is how you can use Custom Filters in the table step by step!

6 Comments

  1. Hi, I’ve loved Ninja Tables thus far but have one question. When using the checkbox custom filters, is there a way to filter for items using AND? Currently, checking multiple boxes on my site will match any rows that match one of the check-boxes, in an OR fashion. If using AND is not possible, could it be considered for a future update? Thanks!

  2. Como puedo ocultar la paginación de mi tabla?
    Tengo 100 filas y solo muestro 3 final de ejemplo y de ahi el usuario busca. Pero no quiero que salga la paginación, como lo oculto

  3. I want to buy the Pro version, but I need to know if there is a way to hide the logs and only show the log with the search, this is limited to 10 searches, for example.

Leave a Reply

Your email address will not be published. Required fields are marked *