Help Center/
Huawei Cloud Astro Canvas/
User Guide/
Widget Management/
Using the Background Pagination Function of Advanced Tables
Updated on 2025-03-24 GMT+08:00
Using the Background Pagination Function of Advanced Tables
The background pagination function requires global variables. To implement background pagination, add the total field to the total number of data records during widget preview.
Background Pagination
- Log in to Huawei Cloud Astro Canvas by referring to Logging In to Huawei Cloud Astro Canvas.
- Create a large screen page, drag the advanced table widget from the All > Text area to the blank area of the canvas.
- Enable the background pagination function.
Figure 1 Enabling the background pagination function
- Create global variables.
The background pagination function requires global variables. Create pageSize and offset variables (names can be customized) and set default values for them. The two variables are required when the pagination function is triggered or the number of records per page changes. Therefore, they need initial values; otherwise, data configuration cannot work.Figure 2 Creating global variables
- Set the interaction.
- Select the advanced table widget and click
to configure the widget interaction.
- Add an interaction action under the pagination switching area.
Figure 3 Interaction action during pagination switching
- Add an interaction action under the number of data records on the current page is switched area.
Figure 4 Interaction action when the number of data records on the current page is switched
- Select the advanced table widget and click
- Set the widget data.
- Select the widget. Click
above the widget.
- Select the required data type.
- In the configuration process, use SQL statements to obtain data.
In the SQL statements for data access, add the global variables offset and pageSize created in 4 to limit the data obtained each time.Figure 5 Entering SQL statementsFigure 6 Entering $ to add a global variable
- In the widget preview area, drag the fields in the table to the corresponding configuration area.
- Click Save.
- Select the widget. Click
- Save the page and preview the effect.
Figure 8 Checking the background pagination effect
Parent topic: Widget Management
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot