I am looking for an option to start an AdvancedDataGrid with quite a large ArrayCollection to start of displaying at a certain record. The ArrayCollection contains a list of items each with a date, both into the past and the future and I would like to start the DataGrid to show the data of the actual (system-)date. Can't seem to find out how.
I handled this by restricting my dataset itself. I.e. when I do my initial HTTPService call, I restrict the SQL statement to the current date and limit the number of rows returned. Then, when the user scrolls, I intercept the scroll action and send another HTTPService request for a new set of rows based on the direction the user scrolled.