How to obtain the staking amount for non-active validators?

Question

Using substrate-interface I'm trying to get the amount of DOT in staking for non-active validators, those that are waiting. I can get the active validators' amount by using the storage_function ErasStakers, but I can't find any for the rest of the validators.

I get the {'total': 0, 'own': 0, 'others': []} but just for the active stakers of the current era (Staking:ActiveEra):

active_validator = substrate.query_map(
    module='Staking',
    storage_function='ErasStakers',
    page_size=300,
    params=[era_index]
)

Is there any call or combination of calls I could use to get the staked amount for the full set of validators (active+waiting)?

Answer 1

I believe you will need to do a few queries here to get the data you want:

1. Get all validator stash accounts from iterating over the Validators storage map
2. Get all the controller accounts by mapping the validator stash to the validator controller via the Bonded storage map
3. Get the amount of tokens staked for that validator from the Ledger storage map

From there, you need to add up all the values to get the total amount staked.