Sign Up

Filter Data

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.

-

Filtering Data

To filter data:

  1. Click on the Filter Button: In the table toolbar, click the "Filter" button.

  2. 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.

  1. Add Multiple Filters: You can add multiple filters to a query to narrow down the data to exactly what you need.

Sorting Data

To sort data:

  1. Click on the Sort Button: In the table toolbar, click the "Sort" button.

  2. Select a Field: Choose the field by which you want to sort the data.

  3. Choose the Order: Select whether you want the results in ascending or descending order.

Exporting Filtered Data

After applying filters, you can export the refined data:

  1. Apply Filters: Ensure your data is filtered as per your requirements.

  2. Export Data: Click on the export button to download the filtered data. This option is usually available within the table toolbar.

Related Topics

Generate CRUD Endpoints

With Twidget, you can efficiently generate CRUD (Create, Read, Update, Delete) endpoints for your database tables upon their creation. This functionality is designed to streamline the development process and ensure that essential API operations are readily available. Enabling CRUD Endpoints. 1. Crea...

Database Basics

Twidget offers a comprehensive database solution for all workspaces. Here's an overview of how databases are structured and managed within Twidget: Database Structure. 1. Tables: A database may contain multiple tables. Each table stores data in a structured format. 2. Fields: Tables consist of field...

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...

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 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...