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.
Adding Database Table Rows
In Twidget, you can easily add new entries (rows) to your database tables. This feature allows you to expand your data dynamically without the need for complex coding. This document provides a step-by-step guide on how to add rows to your database tables. Adding a New Entry to a Table. To add a new ...
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...
Database Tables
Database tables are essential components of your Twidget workspace, serving as the primary storage locations for your data. In Twidget, each table consists of rows and fields, meticulously designed for efficient data management and retrieval. Structure of Database Tables. - Rows: Each row in a datab...
Database Storage
Managing your database storage effectively is crucial for ensuring optimal performance and cost-efficiency when using Twidget. Each entry within your database table utilizes a certain amount of storage space. Twidget provides intuitive tools to help you monitor and manage this storage. Viewing Datab...
Export Data from Tables
Twidget allows you to export data from your database tables to a CSV file. This feature supports the export of both complete and filtered datasets. Here’s how you can utilize this functionality: Features. - Format: Export data in CSV format. - Data Handling: Object and list data types within your ta...