Small and medium business | Business Central, N...

How can I loop records displayed in a page?

(0) Share

Report

Posted on by Kuhicop

Hello,

I'm trying to loop all records displayed in a page, from the selected one to the end of the rows:

For example here, as I'm selecting only the 5th row it will loop through 5th and 6th row (as there are no more rows below)

What I've been trying is this:

ProdOrderLine := Rec;

REPEAT
UNTIL ProdOrderLine.NEXT = 0;

But it will loop through all records in the table which are not even displayed in the page...

How can I loop only the page records from the selected one to the latest?

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

hi

this is the correct code:

CurrPage.SETSELECTIONFILTER(ProdOrderLine);

REPEAT

UNTIL ProdOrderLine.NEXT = 0;

is the page that must assign the filters to your variable of type Record

check my answer if it helped you, thanks

DAniele

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

Hi, the key method is SETSELECTIONFILTER Function

https://learn.microsoft.com/en-us/dynamics-nav/setselectionfilter-function

Below are some simple examples that hopefully give you some hints.

https://yzhums.com/5625/

https://yzhums.com/27561/

https://yzhums.com/27185/

Thanks

ZHU

Was this reply helpful? Yes No
Kuhicop on at

Like (0)

Report

Hello ZHU, the problem is that SETSELECTIONFILTER will only loop the selected record, but I want to loop from the selected record to the latest record displayed, in the example, selecting row 5th it will loop 5th and 6th

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

hi

try this

CurrPage.SETSELECTIONFILTER(ProdOrderLine );

IF ProdOrderLine .FINDFIRST THEN

BEGIN

ProdOrderLine .SETFILTER("Line No.",'%1..',ProdOrderLine . "Line No.");

IF ProdOrderLine .FINDFIRST THEN

REPEAT

UNTIL ProdOrderLine .NEXT=0;

END;

check my answer if it helped you, thanks

DAniele

Was this reply helpful? Yes No
Kuhicop on at

Like (0)

Report

Hello, there's a problem with that code... the lines are not ordered by line no.

Was this reply helpful? Yes No
Kuhicop on at

Like (0)

Report

This worked making COPY instead of assign:

ProdOrderLine.COPY(Rec);

REPEAT

UNTIL ProdOrderLine.NEXT = 0;

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

Hi, is the last line distinguished by Line No.? I think you can first get the Line no. of the currently selected line (Using SETSELECTIONFILTER), then use Findlast to get the Line No. of the last line, and finally use setrange or setfilter to filter this range, and the loop will work.

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No