Data can be sorted, filtered, created, deleted in an intuitive way in Basedash.
Creating new records
Creating records is possible on editable data source tables and basic views that don’t include joined tables.
At the bottom of a table, you can create a new record.
Deleting records is possible on editable data source tables and basic views that don’t include joined tables.
You can delete a record by selecting the checkbox corresponding to a record and then clicking on the delete button at the bottom left. It’s possible to delete more than 1 record at a time by selecting multiple records.
Sorting and filtering
You can sort a column on a table by clicking on the header for the column that should be sorted. You are only able to apply one sort at a time on data source tables. However, you can apply multiple sorts from views.
Filters can be applied to a table by clicking on the filter icon and specifying the filter criteria that should be used. It’s possible to add multiple filters and they will be added with an “AND” condition. Currently it’s not possible to combine filters with “OR” conditions using basic views. For more advanced filters, consider creating an SQL view.
Based on the attribute type, you will be presented with a different set of filter options.
Date attributes will have the following filter operators available:
is on or before...
is on or after...
is not null
Number attributes will see the following filter operators available:
is not null
After an edit has been made, it is possible to undo the change from the toast that appears at the bottom right of the screen.
If a table cell appears greyed out, it means that the data is not editable and is read-only. There are many reasons for why data can be read-only:
- If a data source is configured to not allowing edits
- You have a read-only role
Note that primary key columns are always read-only.
Attribute and table display names
When displaying names of attributes and tables in the user interface, it’s possible to give them names that differ from the underlying name used in your database in order to make them more “human friendly”. For example, you might want to get rid of underscores or add spaces in your names.
When adding a new connection, Basedash will automatically “prettify” all your table and attribute names so that they appear in a more “human friendly” way in the user interface. You can change the display name for an attribute in the connection configuration pages.
It’s possible to mark attributes as “obscured” which will prevent the real value from being visible in the user interface. Obscured attributes are also not even sent through via API calls, but rather a random hash of characters is used instead so that obscured attributes cannot be accessed by users.
Upon adding a new connection, Basedash will automatically obscure attributes that correspond with the following database column names (case insensitive):
You can change the display name for an attribute in the connection configuration pages.
Our own custom Basehash font is used when displaying obscured data.
If more than one person is viewing a data source table or view, a realtime indicator will appear at the top of the page with the avatars of the other people currently viewing the data. If another user is focused on a particular table cell, that cell will be outlined with a color representing the user.