Refreshing listview on change with infinite scroll

Is this not possible or am I just an idiot and can't figure it out?

I have a listview that I want limited to 10 per page as the user scrolls AND for it to listen for any changes and make them visibly appear.

Ok....enable infinite scroll and listen for changes. Nope, enabling infinite scroll disables live refresh.

OK. Fine. Let's do a manual refresh of the database request on a 'pull to refresh' action....oh wait nope. Can only be done on single-time queries.

Ok. Let's turn on the single-time query. Nope - have to disable infinite scroll -_-

Is there any way to limit the number of results (and scroll for additional results) in a listview backend query, while still being able to either a) manually refresh to add new items OR b) add in items live (how listview typically works without infinite scroll on)

41
59 replies