Forum

Hello there,
I want to use sql limit and line number.
How can I do that?

Select ..... limit, 5

Select rank () ....

Select rownumber () .....

   Query = New Query;
   Query.Text = "SELECT
                |   Table1.Code,
                |   Table1.Description ////using row number or limit ??
                |FROM
                |   Catalog.Table1 AS Table1";
   
   QueryResult = Query.Execute();
   
   SelectionDetailRecords = QueryResult.Select();

Hello, Erdogan, you can add TOP clause to the query:

   Query = New Query;
   Query.Text = "SELECT TOP 10
                |   Table1.Code,
                |   Table1.Description 
                |FROM
                |   Catalog.Table1 AS Table1";
   
   QueryResult = Query.Execute();
   
   SelectionDetailRecords = QueryResult.Select();

I want to make pagination.
Can I do it any other way?

I list the records with JSON.
Too many records.
I want to divide them (Paging).
I have to use it in the query for this.

How else can I do it?

Hello, Erdogan.

Maybe you could change the behavior to something better? In most cases you can't expect that the user will click on each page of the long list. Maybe you can display a message that there are N extra items in the database so the list is not full and add a button to export entire the list?

Hi, Erdoğan.

How I get your question, you need to get more data list in several pages that is related with row count and page maximum row count?

If question is true. You may examine an example that I prepared for you. External data processor message you how many pages can be created, will how many count in each page and totally how many rows in whole.

For that you need to open firstly 1TC:Ticaret Yönetimi + Genel Muhasebe configuration and then open data processor.

Wonderful...
Thank you so much.

Actually, I wanted to paginate.
I built a Web Store.
I list products by category.
I want to paginate it.

Pagination can be done using TSQL and PSQL. (Ms Sql Server, IBM DB2, Oracle, MySQL). It's very simple. We just need to write in the query. I wrote the examples in my first post. In ADO components, the RecordSet object can also paginate. How can we do this at 1C? I wanted to ask.

Is there a pagination for Query and RecordSet object in 1C?
Sample ;

QueryResult.PageSize
..
or
..
RecordSet.PageSize
..
or
...

Pagination is implemented in dynamic lists, but i'm afraid you can only emulate it in queries by skipping the required number of rows and returning ones that match the window.

Hi Erdogan, you can make pagination with sequential access like that

SELECT TOP <YourPageSize>
   Table1.Ref AS Ref,
   Table1.Code,
   Table1.Description
FROM
   Catalog.Table1 AS Table1
WHERE Table1.Ref>&LastPageRef

ORDER BY
   Ref