How to limit a number of records loaded when a ListPage is open?

(0) Share

Report

Posted on by Leo Fox

105

Hi,

I've been trying to find out an answer to a question which probably belongs to a "common knowledge" domain, but unfortunately those tricks I tried by far haven't brought me anywhere...

I have a ListPage form in AX 2012 which loads a very large number of records (over 30000). The query uses aggregate functions and groupings over even larger amount or records. No wonder it takes long for the form to load.

What I need is a way to load only a handful of records initially, just enough to fill a screen or two, not the the whole lot of 30000+. When scrolling the form down, a new bunch of records should be requested, but again, not the whole lot.

The query used to populate a form is properly indexed, it returns a small number of records (few hundreds) real fast, so the only problem is to make AX to send such requests for small portions of data.

Any ideas please!

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Dick Wenning 8,705 Moderator on at

Like (0)

Report

just add the correct properties on the form.

things like find first fast on the query

on the datasource use onlyfatchactive

those realy make a difference.

also avoid innerjoins incase of more than 100.000 records

Was this reply helpful? Yes No
Suggested answer

Dick Wenning 8,705 Moderator on at

Like (0)

Report

Leo did it work out?

Was this reply helpful? Yes No
Leo Fox 105 on at

Like (0)

Report

Hi Dick,

thank you for your input.

I guess my ListPage form wasn't written properly to start with: there was no AX Query object on AOT, no interaction class, all the loads/refreshes were done in the code calling data source refresh methods. That was why the properties "onlyfetchactive" didn't make any difference: the whole dataset was loaded and reloaded again and again...

I'm in the process of re-writing the form the way Microsoft recommends for ListPage and the results look promising: the form gets only portions of data and the performance has drastically improved. I'm setting "onlyfetchactive" on the form and "firstfast" on the query. Seems like the problem for me now shifted in a different direction: at the time I set initial values on newly added controls (like a checkbox) an exception gets thrown telling "FormCheckBoxControl object not initialized", although a constructor super() is called at the top of the method... I'm still missing something...

Was this reply helpful? Yes No
Verified answer

Leo Fox 105 on at

Like (0)

Report

Hi , just confirming that after

1) changing the form such as to define datasources through AOT Query rather than straight from an existing View and

2) setting properties FirstFast=Yes on the Query and OnlyFetchActive=true on the datasource

the goal was achieved: a small subset of all the available records is now retrieved on a form load.

Thank you Dick

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

to limit the number of visible records on the listpage...

type set the properties of the Grid on the ListPage

For Grid we have one property called 'VisibleRows'

Validate by setting this property and see if it is fine as per your requirement

Was this reply helpful? Yes No

Community site session details

How to limit a number of records loaded when a ListPage is open?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

How to limit a number of records loaded when a ListPage is open?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates