Droptables: Tables from Database


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




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.



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




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



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.




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