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

Pagelist - How to select really all rows?

(0) Share

Report

Posted on by proceed-it-solutions

Hi,

Our customer uses pre-defined filters in the Posted Sales Invoices (143, List), using 'select all rows' to send the invoice by email or print. (or any other action)

When pressing 'select all lines', only the lines that are visible (loaded in the page) are checked. However, a section is not actually highlighted, because even more lines become visible when scrolling.

As a result, only part of 'all selected lines' will be marked when sending the emails (or printing).

We are aware that the records are partially visible for performance reasons and are loaded as you scroll further down.

But how can anyone actually select all the lines in a normal way?

Thanks

Kind regards,

Jeffrey

All responses (9)

Answers (0)

Jun Wang 7,443 Super User 2024 Season 2 on at

Like (0)

Report

RE: Pagelist - How to select really all rows?

if you know the total no of records, you could continue copy the rest. This is not the most elegant way, but works if the total amount is manageable. otherwise, consider use config package as suggested by Kaspars.
Peter F. 34 on at

Like (0)

Report

RE: Pagelist - How to select really all rows?

We got the same problem and at the moment, on standard, the only solution is configuration packages.
KasparsSemjonovs 3,962 Super User 2024 Season 2 on at

Like (0)

Report

RE: Pagelist - How to select really all rows?

You can use Configuration packages - it will export to excel all entries.
Or create a custom export.
proceed-it-solutions 45 on at

Like (0)

Report

RE: Pagelist - How to select really all rows?

Hi,

When CTRL+A is pressed, then CTRL-C, the message shows the number of copied rows.

After scrolling down, I noticed the page is filled up with additional records, then pressed CTRL-A and CTRL+C shows a differtent no. of rows

Even on pressing CTRL+END and CTRL+A, the no. of records isn't correct.

When we export the records (including the used filter) we retreive 400+ records.
Suggested answer

Jun Wang 7,443 Super User 2024 Season 2 on at

Like (0)

Report

RE: Pagelist - How to select really all rows?

you can try a workaround:

first you run the table in BC instead of viewing/selecting directly on the page.

Check how many rows the table have, then Control A while scrolling down.

If it doesn't copy everything, then try again.
Suggested answer

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

Like (0)

Report

RE: Pagelist - How to select really all rows?

I provided the custom solution based on your comment that standard solution doesn't work.

I tried Ctrl+A and also select more and clicking on the top left icon and in both cases it selected all records that are not on the list.
Suggested answer

KasparsSemjonovs 3,962 Super User 2024 Season 2 on at

Like (0)

Report

RE: Pagelist - How to select really all rows?

CTRL+A should select all rows, but it could work the same as select all... can try.
proceed-it-solutions 45 on at

Like (0)

Report

RE: Pagelist - How to select really all rows?

We are more looking for a standard solution
Mohana Yadav 59,194 Super User 2024 Season 2 on at

Like (0)

Report

RE: Pagelist - How to select really all rows?

Create boolean field "Selected" and add an action called select all which makes selected to true

use that boolean in your code for sending records.