[track] RPC pagination and sorting about lightning HOT 4 OPEN

Now that pagination was added (v23.08) for invoices could we plan pagination for payment for v23.11? 🙏

from lightning.

Forwards should also be paginated, because some big nodes are gonna have an enormous number of (failed) forwards. We have been running CLN for barely over a week and lightning-cli listforwards is already getting very slow

from lightning.

Another point I brought up is that the paginator that will expose should also be UI framework friendly.

All the modern frameworks provide a standard way to paginate content so that no one will implement code for paginator on the UI side nowadays.

Maybe we should do some research on the API that we want to expose

A good feedback is here #6098 (comment)

from lightning.

I hope to support status filtering in listinvoices like listsendpays.

from lightning.