Data can be sorted, filtered, created, deleted in an intuitive way in Basedash.
Creating new records
Creating records is possible on editable database tables and views that don’t include joined tables.
You can click the button to create a new record at the bottom of a view or within the expandable sidebar.
Deleting records is possible on editable database tables and view 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 or view by clicking on the header for the column that should be sorted. You are only able to apply one sort at a time on connection tables. However, you can apply multiple sorts from a view. When you apply sorts on a view from the view editor, you are essentially applying the “default sorting” mechanism for a view. In other words, users will be able to click on the column headers of views to set a new sort order.
Filters can be applied to a table or view 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. When applying filters from the view editor, those filters will always be applied to the view. In other words, users won’t be able to override those filters using the filter popover outside of the view editor. Any additional filters applied outside of the view editor will be in addition to the filters defined from the view editor.
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 read-only permissions
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 database 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.