Column filtering options, tips and tricks

Sometimes you want to filter specific columns, not just the whole table. This is called column filtering and in this tutorial we present the various options you have and some useful tricks you can use for fine tuning. When you define a column filter you specify either explicitly or implicitly the following parameters:

  1. Column ID
  2. Control Type
  3. Search Method

Let's see them one by one.

Available options for responsive patterns

Some of the available responsive patterns have options for fine tuning the responsive behavior of your table. Since responsive design is a principle rather a distinct implementation it's always good to bear in mind that a pattern that looks really good in one case may not be appropriate in another. That's why Tabulizer brings you the top best responsive designs to choose from!

How to resolve typical dataTable warnings

Sometimes if you create a table with dynamic features, such as search/filtering, pagination and sorting you may get the following javascript error:

DataTables warning (table id = 'tab_82GIgA72AZ'): Cannot reinitialise DataTable.
To retrieve the DataTables object for this table, pass no arguments or see the docs for bRetrieve and bDestroy

Displaying really large tables with Tabulizer (+10,000 rows)

Let's say you have an Excel file with 10,000 rows or a database query with 30,000 rows. Showing these data as a table is not a trivial task, because if you simply load all the data along with the web page, not only it will take too much time but it's possible that the client's browser will crash due to memory or processing limitations. This is especially true for older mobile devices.

Combining data from multiple sources with data source merger.

One of the advanced features of the latest Tabulizer version is that you can merge data from various sources into a single table. Let's say you keep the sales reports on a different Excel sheet for different regions and you want to combine them into a single table, or you have one CSV file where you keep a list of names and phones and another database table where you keep a list of names and emails for the same group of people, and you want to combine them into a single table. The figures below shows a few case scenarios of how you can combine the input data sources: