Filter and sort database records to find the data you need.
Recorded with an earlier Twidget interface. Names, control locations and available options may differ; use the linked documentation for current guidance.
Watch tutorial (2:28)In Twidget, you can easily filter and sort data within the database tables view. This allows you to refine and manipulate the data as needed. Below are the steps and options available for filtering and sorting data.
To filter data:
Click on the Filter Button: In the table toolbar, click the "Filter" button.
Add Individual Filters: You can add individual filters based on:
Table Column: Choose the column you want to filter.
Operator: Choose an operator from options such as equals, not equals, greater than, less than, contains, and many more.
Value: Enter the value to filter by.
To sort data:
Click on the Sort Button: In the table toolbar, click the "Sort" button.
Select a Field: Choose the field by which you want to sort the data.
Choose the Order: Select whether you want the results in ascending or descending order.
After applying filters, you can export the refined data:
Apply Filters: Ensure your data is filtered as per your requirements.
Export Data: Click on the export button to download the filtered data. This option is usually available within the table toolbar.
Table Field Types
Each table column in Twidget has a data type. The available data types are: - Text - Number - Boolean - Date - Object Field Type Adherence. Data added to the table should adhere to the column's field type. When you manually enter data via the web application, the value editor will use the input type...
Database Indexes
Indexes help Twidget find records quickly. A unique index also prevents duplicate values from being saved. Choose the right index. Use a lookup index for a field you regularly filter or sort, such as an order date. Use a unique index when a value must not appear twice, such as a membership number. A...
Related Records
Include related information in the same result instead of adding a separate lookup for each record in a list. Example: orders with customers. Suppose your Orders table stores a `customerId`, and your Customers table contains the corresponding customer record. 1. Add Get Multiple Data and select Orde...
Database Change Triggers
Run an event automatically when a record is created, updated or deleted in a Twidget table. For example, send a welcome message after adding a customer, or refresh a summary when an order changes. Prepare the event. Create an event containing the steps you want to run. Add an Object input named `tri...
Table Relationships
In Twidget, you can connect database table data using the `_id` field that is automatically generated for every row in a table. This `_id` field is essential for creating and maintaining relationships across different tables. Types of Relationships. A one-to-one relationship occurs when a single row...
