github PolymeshAssociation/polymesh-subquery v20.0.0-alpha.1

pre-release4 hours ago

20.0.0-alpha.1 (2026-11-16)

  • feat!: 🎸 link multisigs, PIPs, subsidies, EVM and confidential assets to their accounts (20bb87f)
  • feat!: 🎸 index eras, elected validators and slashes (beeda48)
  • feat!: 🎸 index corporate actions, ballots, checkpoints and offerings (8a43137)
  • feat!: 🎸 record settlement parties and approvals per holder (a9e908c)
  • feat!: 🎸 merge the external agent entities into AssetAgent (1550d24)
  • feat!: 🎸 hold assets at portfolio and account grain, one row per token (8f6bd0f)
  • feat!: 🎸 key claims and compliance as the chain does (b559001)
  • feat!: 🎸 record identity keys as time-bounded memberships (2b396e4)
  • feat!: 🎸 record POLYX as a double-entry ledger, matched to chain balances (c19b924)
  • feat!: 🎸 record where every row came from, and store arguments canonically (fb2b7c1)
  • feat!: 🎸 build the database from the schema, with no SQL migrations (c24a78b)
  • feat!: ⬆️ 🎸 run on Postgres 18, Node.js 24.22.1 and node-core 19.4.0 (dd3943d)

Features

  • 🎸 decode every event, call and storage item by name, checked per runtime (119db74)
  • 🎸 start an index from any block, seeded from chain storage (25a3b81)

BREAKING CHANGES

  • MultiSig.address is the Account relation account; read accountId.
    MultiSig.creator and creatorAccount are nullable. MultiSigAdmin.identityId is the Identity
    relation admin; read adminId.
  • ProposalVote.account, MultiSigProposal.creatorAccount and BridgeEvent.recipient
    are Account relations; read the *Id column. EvmTransaction.fromAddress is fromAccountId.
    Proposal.owner is nullable.
  • ConfidentialAccount.account is renamed publicKey, and encryptionKey is a
    relation; read encryptionKeyId. ConfidentialAsset.auditors and mediators, and the MediatorKey
    type, are replaced by keys { role encryptionKeyId accountId }.
    ConfidentialSettlement.assetRootBlock is nullable.
  • Proposal.balance is removed; read pips.deposits(pipId, proposer) from the chain.
  • EvmAccountMapping is removed. Find an account by its H160 with
    accounts(filter: { evmAddress: { equalTo: $h160 } }), and read revive.originalAccount(h160) for
    whether it is mapped.
  • StakingEvent.stashAccount is the Account relation stash; read stashId.
    StakingEvent.rewardDestinationAccount is an Account relation; read rewardDestinationAccountId.
  • Investment.stoId is the offering's id (asset/number) instead of its number.
    Investment.offeringAssetId and raisingAssetId, and Sto.raisingAssetId, are Asset relations, null
    for an off-chain raising asset, whose ticker is in raiseToken and raisingTicker.
  • Sto.tiers carries price, remaining and total as "123", not "123n".
  • Leg's from, to, fromAccount, toAccount, fromPortfolio and toPortfolio, and
    InstructionParty's, InstructionAffirmation's and InstructionEvent's identity, account and
    portfolio, are relations; read the *Id column or walk the entity. OffChainReceipt.signer is
    signerId. An off-chain leg's assetId is null, and its ticker is in ticker.
  • an account-level holder is no longer its own InstructionParty.
  • InstructionAffirmation is one row per holder, created Pending with the
    instruction; a withdrawal sets it back to Pending; InstructionEvent.identity is the caller for
    affirm, withdraw and auto-affirm events. A mediator's affirmation row is instructionId/mediator/did,
    and a withdrawn one stays, as Pending.
  • a rejection writes no InstructionAffirmation; read Instruction.rejectedBy and
    rejectedBySigner. AffirmStatusEnum.Rejected is removed and Pending added.
    InstructionAffirmation.portfolios and InstructionParty.portfolios are removed; read portfolioId
    per holder row.
  • AssetMandatoryMediator.addedBy is nullable.
  • AssetPreApproval is removed. Whether a receiver must affirm is the runtime API
    settlementApi.getReceiverAffirmationRequirement(receiver, assetId), and the pre-approval alone is
    asset.preApprovedAsset(did, assetId); what an instruction did is
    InstructionAffirmation.isAutomaticallyAffirmed.
  • TickerExternalAgent is renamed AssetAgent, and its caller field identity;
    TickerExternalAgentHistory is renamed AssetAgentHistory, whose type is the AgentHistoryType enum
    instead of a String, and which has no updatedEvent; TickerExternalAgentAction is renamed
    AssetAgentAction. The tickerExternalAgents, tickerExternalAgentHistories and
    tickerExternalAgentActions queries become assetAgents, assetAgentHistories and assetAgentActions,
    and callerId filters become identityId. AgentGroupMembership.member is an Identity relation;
    read memberId.
  • PortfolioMovement and PortfolioMovementTypeEnum are removed. Query
    assetTransactions with isInternalTransfer: { equalTo: true }; fungible and non-fungible
    movements differ by amount or nftIds being null.
  • NftHolder and Identity.heldNfts are removed. An identity's holding of an asset,
    fungible or NFT, is its AssetHolder, and its tokens are nfts filtered by holding.
  • Asset.isUniquenessRequired is removed.
  • AssetTransaction.fromAccount and toAccount are Account relations; read
    fromAccountId and toAccountId.
  • a memo that is not ASCII text changes. Non-ASCII UTF-8 decodes correctly, and a
    binary memo, or one with a NUL or control character in it, is the 0x-prefixed hex of all 32
    bytes. Event and call arguments keep memos as hex.
  • text set before v14 keeps its spaces, and an asset created with no funding round
    name has fundingRound "".
  • Claim ids include the issuer, so claim counts rise where issuers used to
    collide. A Custom claim without a scope has a null scope and the id
    target/issuer/Custom/.
  • the ClaimScope entity is removed. Query Claim.scope with { contains: … }, as the
    SDK already does.
  • TrustedClaimIssuer.issuer is an Identity relation: filter on issuerId, and read
    the identity through issuer.
  • ClaimTypeEnum loses InvestorUniqueness, InvestorUniquenessV2 and NoData.
  • from 7.0, an asset-scoped claim's scope.value is the asset id, not the ticker.
    Read the asset from scope.assetId.
  • the TransferManager entity, TransferRestrictionTypeEnum and the
    transferManagers query, Asset.transferManagers included, are removed.
  • Identity.secondaryAccounts is removed. Read
    Identity.keys(filter: { role: { equalTo: SecondaryKey }, validToBlockId: { isNull: true } }), which
    returns IdentityKey rows, each with an account relation.
  • the AccountHistory and Permissions entities are removed, and so is
    Account.permissions. Read key-membership history and per-interval permissions from IdentityKey;
    an account's current permissions are its active IdentityKey row's permissions.
  • the ChildIdentity entity and Identity.children are removed.
  • Identity.primaryAccount is an Account relation; read primaryAccountId.
    Authorization.toKey is removed: a key's authorization is toAccountId, an SS58 address.
  • pre-7.0 rows of IdentityKey.permissions.transactions, AgentGroup.permissions,
    JoinIdentity and RotatePrimaryKeyToSecondary Authorization.data, and every built-in group's
    AssetAgentHistory permissions hold the map form.
  • polyxTransactions is replaced by polyxEntries. A query that matched an account
    across the from and to columns filters on one accountId. BalanceTypeEnum is removed; use
    PolyxEntry.pool, kind and direction. The same staking event name means a lock before the v8
    upgrade and a hold after it.
  • createdBlock and updatedBlock are removed from every entity; read
    createdEvent { block } instead, and order by ID_* where CREATED_BLOCK_ID_* was used. datetime,
    eventIdx and extrinsicIdx are removed wherever an entity copied them; read
    createdEvent { block { datetime } }, createdEvent { eventIdx } and
    createdEvent { extrinsic { extrinsicIdx } }. Identity.eventId, Account.eventId and
    DistributionPayment.eventId are removed. AssetTransaction's scheduled-transaction signal, which
    was a null extrinsicIdx, is a null createdEvent { extrinsic }.
  • Event.attributesTxt and Event.eventArg_0 to eventArg_3 are removed, and so are
    the Event columns claimType, claimScope, claimIssuer, claimExpiry, corporateActionTicker,
    fundraiserOfferingAsset and transferTo. Read Event.args, and find events by what they involve
    through Event.refs. Extrinsic.paramsTxt is removed; read Extrinsic.args. Values are in the
    canonical encoding, not toHuman text, so a moment needs Number() before new Date().
  • Instruction, Venue, Proposal and Authorization ids are zero-padded to 10 digits
    ("0000014712", not "14712"). A filter or join on the unpadded id must use the padded form.
  • generated collection names are replaced by declared ones, for example
    claimsByTargetId by claims, and Asset.assetTransactions by Asset.transactions.
  • the FoundType and Debug entities and their queries are removed.
  • a database built by an earlier release cannot be upgraded in place. Drop it and
    reindex from genesis.
  • the database is a new Postgres major version with a new volume path. An existing
    data volume has to be recreated, and the chain reindexed from genesis.

Don't miss a new polymesh-subquery release

NewReleases is sending notifications on new releases.