Droptables: Tables from Database

 

Droptables allows you create tables from your database tables. From the settings of the component, you should Enable database table.

 

database-config

 

Back to dashboard, firstly, you choose Table from database category and then click Create table , then all tables in your database will be listed below. Next, you'll be able to select tables and columns from your database. By hitting control you can select several tables, columns.

 

database-selection


On column selection you can define a custom title and a default order for your data in the table, when displayed on public side.

 

column-titleandordering

 

Then you got some options and filter to apply to your tables:

  • A pagination default level (to be used with a large amount of data)
  • Number of rows for the pagination
  • Apply some filter to your data ie. a column can be equal, different... from a defined value
  • The possibility to group some values in the columns

 

database-table-option


Finally, you can preview and generate your table like any other table. When your table is generated you will still have access to the table Database source and you can for example add a column in your table.

 

database-table-generated

 

Note: The only difference is that themes cannot be applied on tables but you can customize all the display like in any other table.