我可以分别收回每个帐户的代币余额。通过这两种方法，可以算出分别回收余额的方法：

方法1

val heldByAccount = QueryCriteria.VaultQueryCriteria().withExternalIds(accountId)
val queryCriteria = tokenAmountWithIssuerCriteria(myTokenType, issuer)
        .and(heldByAccount)
        .and(sumTokenCriteria())
val results = serviceHub.vaultService.queryBy(
        contractStateType = FungibleToken::class.java,
        criteria = queryCriteria)
val tokenbalance = rowsToAmount(myTokenType, results)

方法2

val sumAmount = builder { PersistentFungibleToken::amount.sum() }
val sumAmountCriteria = QueryCriteria.VaultCustomQueryCriteria(sumAmount)
val heldByAccount = QueryCriteria.VaultQueryCriteria().withExternalIds(accountId)

val sumAmountFromDB = serviceHub.vaultService.queryBy(
        contractStateType = FungibleToken::class.java,
        criteria = heldByAccount.and(sumAmountCriteria)
).otherResults

在我的方案中，我需要多次收回多个帐户的余额，而单独执行此操作很慢。通过按帐户对余额进行分组，是否可以在单个查询中恢复帐户列表的余额？

我想在PersistentFungibleToken :: holder列中使用groupByColumns，但是它不起作用。

在下面的链接中，有一种方法可以通过在银行查询来恢复余额。 https://www.corda.net/blog/cordas-accounts-tokens-making-blockchain-more-inclusive/

我在数据库上运行了以下查询，它确实可以收回余额。有人知道这是否是从帐户列表中恢复余额的唯一方法吗？

select ACCOUNTS.IDENTIFIER, sum(FUNGIBLE_TOKEN.AMOUNT)
from VAULT_STATES, FUNGIBLE_TOKEN, STATE_PARTY, PK_HASH_TO_EXT_ID_MAP, ACCOUNTS
where VAULT_STATES.TRANSACTION_ID = FUNGIBLE_TOKEN.TRANSACTION_ID
and VAULT_STATES.OUTPUT_INDEX = FUNGIBLE_TOKEN.OUTPUT_INDEX
and VAULT_STATES.TRANSACTION_ID = STATE_PARTY.TRANSACTION_ID
and VAULT_STATES.OUTPUT_INDEX = STATE_PARTY.OUTPUT_INDEX
and PK_HASH_TO_EXT_ID_MAP.PUBLIC_KEY_HASH = STATE_PARTY.PUBLIC_KEY_HASH
and ACCOUNTS.IDENTIFIER::text = PK_HASH_TO_EXT_ID_MAP.EXTERNAL_ID
group by ACCOUNTS.IDENTIFIER