What would be the best way to get all the addresses with a position on a particular reserve?

Question

What would be the best way to get all the addresses with a position on a particular reserve? Is there a query I can perform on the subgraph to retrieve so?

Answer

You can use this subgraph query:

```
{
userReserves(where: {reserve: "lowercase_asset_address"}){
  user{
    id
  }
  reserve {
    liquidityIndex
    variableBorrowIndex
  }
  scaledATokenBalance
  scaledVariableDebt
    principalStableDebt
  stableBorrowRate
}
}
```

More [info](https://aave.peeranha.io/feed).

What would be the best way to get all the addresses with a position on a particular reserve?

Answers 1