Table
Last updated
Last updated
Tables are the primary data sources in the App Builder. Tables is an intuitive way to access Resources and Projects data in your app and interactive with them in the app.
A Table corresponds to either 1. A table in Resources, or 2. A tab in Projects. Resources and Projects could be stored in Cloud in an unordered, parallel way to optimize the ability to process big data. However, an application need clean neat and tabular data. That is where the concept of tables comes out. Table node allows you to directly access the data in resources and project and turn into Table, Charts and even Data science application, ensuring a hassle-free experience during app development.
Tables needs no setup and ready-to-use in app construction. For example, Create a table and Create a list use a resource table.
You can find a list of Tables at Left Tool Bar - Data sources - Tables. For resources and projects that have multiple tables, click on them to expand. Hover on a table, you'll see a Preview button and a more button provides some quick operations including:
Use in Table: Apply the Table to a table in the current app, or add a new table with the Table to the current app
Use in Chart: Set data to this Table for a chart in the current app, or add a new chart with this Table to current app.
Create Query Create a Query in current app.
Default Page Size: Set the default page size per page for this table. This setting determines how many rows will be requested from the database.
Get Table Data
Retrieve table node data with certain page, search and order.
Page Size: The number of results to display per page. A higher page size will show more results on a single page, while a lower value will show fewer.
Page Number: The specific page (starting from 1) of results to display based on the defined Page Size. For example, if there are 400 rows and the Page Size is set to 100, selecting Page Number 3 will show results 201-300.
Search Fields: Specifies the database columns or attributes that should be searched. This helps in narrowing down the search to specific fields rather than searching across all columns.
Search Value: The actual text or value to search for within the chosen Search Fields. The database will return results that match or contain this value in the specified fields.
Sorting Field: Determines the database column or attribute by which the results should be sorted. For example, if you choose a 'Date' field, the results will be sorted based on dates.
Sorting Order: Determines the direction of the sort for the selected Sorting Field. Common values include 'Ascending' (A-Z, smallest to largest, or oldest to newest) and 'Descending' (Z-A, largest to smallest, or newest to oldest).
Insert Table Rows Insert rows into table data source. Specifically:
Resource Table: Insert rows directly into the table in the resource that the current Table corresponds to.
Data Prep Table: Inserting rows into Data Prep Tables is not recommended. The table will be overwritten once the Data Prep is synced, and any rows you insert will be lost.
Warning: Sync operations like Resource Full Refresh and Save Data Prep result in irreversible loss of the inserted data.
Data Update: Triggered when the data runs.
Data Update Error: Triggered when errors occur as the data runs.
