Hi Ronan,

You fetch data from the database every time you use an Aggregate or the SQL tool... can you explain in more detail what is it you are trying to achieve? From your explanation above it does seem to be exactly like how pagination is usually implemented in OutSystems.

Hi Ronan T,

If you don't want to use the outsystem pagination, then you can create your own.

To Achieve this follow the below steps-

1- Create a link buttons just like pagination.

2- Create a action to fetch the set of data.write a query inside this action then refresh the list record table.

3:- Get the start row number and end row number by using the page number and record per page

4- Pass the start row number and end row number in the query

5- Using start row and end row number fetch the data from the database.

6-Assign this action to the destination of the links.

I will suggest you to use this pagination if you have huge volume of data.

Thanks

Rajendra Singh

HI Rohan,

As per my understanding there are only two way to Achieve this functionality.,first is use the outsystem pagination and second is to create your own pagination by writing some logic.

If you don't want to go with oustsystem one.Then you have to write some logic. and yes there will be some limitation to achieve this.

I have achieved the similar functionality in my project. While creating a search page, because of the huge record in the result set pagination was responding too slow.

Don't use the link button use expression with link.

Put maximum number of expression with link, i am sure pagenumber link will between 3 to 10 add two more next and previous, For example if you will click on the next button it should change the value of the expression which will increment by 1. use the site property to hide/show the link according to the page number (Total records/record per page).

In your case you can write a small extension on .net or java with two input parameter pagenumber or offset, select query and one output parameter of list type.

Thanks

Rajendra Singh

HI Rohan,

As per my understanding there are only two way to Achieve this functionality.,first is use the outsystem pagination and second is to create your own pagination by writing some logic.

If you don't want to go with oustsystem one.Then you have to write some logic. and yes there will be some limitation to achieve this.

I have achieved the similar functionality in my project. While creating a search page, because of the huge record in the result set pagination was responding too slow.

Don't use the link button use expression with link.

Put maximum number of expression with link, i am sure pagenumber link will between 3 to 10 add two more next and previous, For example if you will click on the next button it should change the value of the expression which will increment by 1. use the site property to hide/show the link according to the page number (Total records/record per page).

In your case you can write a small extension on .net or java with two input parameter pagenumber or offset, select query and one output parameter of list type.

Thanks

Rajendra Singh