Filter accounts by balance

[altitude]

No description provided.

[nicoabie]

We have a requirement of detecting when was the last time an account hit zero probably having the transaction that made that happen. So we can do calculations from that point onwards with the newer transactions after that event.

Is this ticket intended to solve this?

[nicoabie]

@altitude looking at how data is stored in the log table a way to accomplish what I'm saying would be to query the postCommitVolumes.
I'd look if there exists that address in the volume and inside that address the asset's balance is zero.
If I order by txid I should have the last transaction.

does that make sense?

[xgenvn]

Hi, just jump across the project and see it's great in terms of the arch. For this feature, is it reasonable to rely on transaction events, and event filtering to trigger different use cases?