Black-Desk

The plugin is designed with people with basic technical knowledge in mind. It is designed to be easy, straight-forward, and intuitive to use. However, some of the database capabilities like creating related tables require you to be acquainted with how relations are made in order to put them into practice. If you have basic data management knowledge, you will be right at home, and if not, try the plugin for free, and don't be too surprised when you find out how easy it is to create database tables, populate them with data, and query your data.

When viewing your table, clicking on a value you wish to edit will render it an input field. While focused on the input field, press Enter to update the value or Esc to cancel editing.

Yes and no, depending on the action you took. Yes, the plugin uses soft delete functionality when deleting data while viewing a table. Deleted records can be restored from the table trash view. However, if you delete the whole table or truncate table data while viewing the list of tables, those two actions cannot be undone, as the user is warned beforehand when prompted to confirm if they are sure they want to delete or truncate the table.

Yes, and to view data from related, joined tables you can create and save a query by setting one of its conditions so that the value from the first table column is equal to the second table column/field (effectively indicating a foreign key column and pointing it to another table's primary key). Example of such query condition: [review.product_id] [equal to] [FIELD] [product.id] See USAGE > CREATING QUERIES section for the detailed instructions on query creation and use.

You can find complete, detailed shortcodes usage instructions in your WordPress dashboard > Tables > Shortcodes submenu page, with examples of usage for each shortcode. For basic information purposes, info on shortcodes functionality is available in the USAGE > SHORTCODES section.