Get ALL marked records from form including rows not visible.

(0) Share

Report

Posted on by Scott_F.

Hello!

I'm trying to select marked records from a grid and loop through them to perform some processing, but the problem I'm having is the datasource will only find 39 records (the number of visible rows), even though I may have 100 or more.

I'm using code patterned after the following:

studentLocal = student_ds.getFirst(1);

while (studentLocal)
{
info(studentLocal.Name +" " +studentLocal.ID);
studentLocal = student_ds.getNext();
}

This is expected behavior because a datasource is made to display the information, not buffer up everything in the table. Scrolling to the last selected records will bring more data in, but this to me seems to be an unreliable approach.
Does anyone know of a good way to select records in a datasource grid and have AX return more than the visible rows without scrolling up and down to force the buffer to fill?

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Heinz Schweda 1,367 on at

Like (1)

Report

Hi, have you tried using MultiSelectionHelper?

Was this reply helpful? Yes No
Suggested answer

Rustem Galiamov 8,072 on at

Like (1)

Report

I think you should use data source query.

Was this reply helpful? Yes No
Scott_F. on at

Like (0)

Report

Hello Heinz Schweda,

Yes. Its nice to use, but still didn't retrieve the records beyond my visible rows. It stops at 39.

Was this reply helpful? Yes No
Verified answer

Scott_F. on at

Like (1)

Report

Hello Crispin.

Yes. You and Rustem Galiamov are right.

This is the limitation to using the datasource from a form for selecting and processing multiple records.

I cannot see anyway around it through property settings or whatnot.

The solution I'm employing is to add a boolean 'marked' column on the grid and using the query generated by the datasource to check and uncheck the marked column.

By way of that code, I will select and update the records.

Was this reply helpful? Yes No