Demo 2: Column filters

Demo2 (Column filter)

This demo shows how to filter the columns you want to display in the resultset. You might not want to show ALL fields and you might also want to change the column heading displayed in the grid. Have a look at the code to see how this is done.

Show grid | Show code

 

The query is still simply a select all select * from tinycrm to show that the resultset still contains ALL data, but we will only display name, surname and status

When viewing the grid, you can:

  • Click on any column to sort the grid by that column
  • Click again to toggle ASC / DES sort order
  • There are 10 rows displayed per page, use the pager to move through pages