How to Add Pagination to the Table in Elementor

Firstly, make sure that you have created a table using JetEngine Tables Builder. If you have not done it yet, we have a table-building guide for you. 

If this step has already been taken, do not hesitate to make some adjustments. One of these is Query Pagination Limit.

To make some changes to the number of items that will be shown in your table, proceed to WordPress Dashboard > JetEngine > Query Builder. There, you can create a new Query or modify an existing one. We click “Add New” to build a new query.

Complete the query’s Name. In our example, it is set to “Products Query for Table.”

Then select the required Query Type. For instance, we have selected “WC Product Query”. It will represent all the data about our products.  

Also, set the unique Custom Query ID to connect the query, filter, and table. It should be identical in all the mentioned elements. We put the “table-pagination” value.

There are some additional settings that you can adapt to your desires. However, we are now fully interested in the Pagination settings, so we open the corresponding tab. 

First, ensure that you have toggled Enable Pagination on. This allows the table Query and Pagination to function as intended.

To work with this option, proceed to the Limit field. Let us start with “4” items.

Do not forget to save changes by clicking on the “Add/Update Query” button.

To check the results, open a page where your table is displayed, or build one if you haven’t done it yet in the Elementor editor.

Add a Dynamic Table widget to the page and select the built table in the Table dropdown field.

You will see that the number of the displayed items is now the same as the Limit set in the Query. In our case, four products are displayed.

You can also apply the style settings to the table if desired. We have adjusted the style settings in the Style tab.

Suppose we want to show fewer products in our table, for example, only two. In that case, we have to return to WordPress Dashboard > JetEngine > Query Builder, select the already created query limited to four products, and change the Limit to “2” in the Pagination settings.

Now we need to save our query again.

One more time, check whether the adjustments are applied in the Elementor editor or on the front end. To do so, proceed to the page where the table is presented.

In this way, you already know how to change the number of products displayed in the table. 

If you want to display more products by using the Pagination widget, there is a solution. Let’s find out how to implement it with the help of Elementor.

Also, check our guide on How to Add Pagination to the Table in Gutenberg.

To add Pagination to the already existing table, begin by checking the page editor.

If you have already added a table in Elementor, just type in “Pagination” in the Search Box, and you will spot the Pagination widget from the JetSmartFilters plugin. 

Drag and drop it below the Dynamic Table.

The first step to displaying our pagination correctly is to choose the source from which the data will be pulled. In our case, we will select the appropriate provider, “JetEngine Dynamic Table” in the Pagination drop-down in our Content tab. 

There is also an opportunity to change the Apply Type from “AJAX” to “Page Reload” or “Mixed”. 

Then fill in the Query ID with the value you set earlier in the Query Builder. In our case, “table-pagination”.

The next step is adjusting the Controls settings.

You can choose to show or hide the “Prev/Next” buttons. It depends on your personal preferences. Below that toggle, there are Prev Text and Next Text fields that allow you to enter the text shown on the button labels before and after the pagination numbers.

Moreover, you can work with offset numbers to set different values for display.

Also, work on the Style tab of the Pagination widget if needed.

Then, navigate to the Advanced tab. Here, in the Layout tab, paste the ID that connects the query, the Pagination filter, and this dynamic table. In our case, it’s “table-pagination”.

Now, publish/save the page.

Open the just-edited page on the front end. Here, now the table is displayed with the pagination below.

Click one of the pages to see if the pagination works correctly.

In addition, you can check how pagination works for the Dynamic Product Table on its live demo page.