Counting records

(0) Share

Report

Posted on by Community Member Microsoft Employee

I Am trying to filter within a lookup for purchase lines. I want to say if there is only 1 record after the filter, open up the card page, if there are multiple, open up a listpage with the results.

How can i count the records after the filter. I thought this would work

IF recPurchLine.COUNT = 1 THEN BEGIN;
PAGE.RUN(PAGE::"G/L Receipt Line Receipt Card", recPurchLine);
END ELSE BEGIN
GLLinesFilter(recPurchLine);
PAGE.RUN(PAGE::"G/L Receipt Lines List", recPurchLine);
END;

*This post is locked for comments

All responses (4)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Counting records

Yes thank you, the following solution worked.

My assumption was the filters would come through from a previous function.

IF NOT GLLinesExist THEN

EXIT;

GLLinesFilter(recPurchLine);

intGlLinesCount := recPurchLine.COUNT;

IF intGlLinesCount = 1 THEN BEGIN

PAGE.RUN(PAGE::"G/L Receipt Line Receipt Card", recPurchLine);

END ELSE BEGIN

PAGE.RUN(PAGE::"G/L Receipt Lines List", recPurchLine);

END;

// TIO000006 : END
Verified answer

Jan Veenendaal 510 on at

Like (0)

Report

RE: Counting records

GLLinesFilter(recPurchLine);

IF recPurchLine.COUNT = 1 THEN BEGIN

PAGE.RUN(PAGE::"G/L Receipt Line Receipt Card", recPurchLine);

END ELSE BEGIN

PAGE.RUN(PAGE::"G/L Receipt Lines List", recPurchLine);

END;

Looks like you did not set the filter before the COUNT ??
Suggested answer

Mohana Yadav 59,139 Super User 2024 Season 2 on at

Like (0)

Report

RE: Counting records

Is it working now?
Community Member Microsoft Employee on at

Like (0)

Report

RE: Counting records

* The ; After the BEGIN was a mistake, now removed*