Skip to content

Latest commit

 

History

History
28 lines (24 loc) · 692 Bytes

File metadata and controls

28 lines (24 loc) · 692 Bytes

Get count of Web3Name's Ownerships that have not being released yet:

query UnreleasedWeb3NamesCount {
  ownerships(
    orderBy: CLAIM_BLOCK_ID_DESC
    filter: { releaseBlockExists: false }
  ) {
    totalCount
    aggregates {
      distinctCount {
        id
        nameId
        bearerId
        claimBlockId
        releaseBlockId
      }
    }
  }
}

ids are the Ownership.id, like #3_w3n:john. nameIds are the Web3Name.id, like w3n:john.

If the distinct count of ids and nameIds do not match, it would mean that the database has two owners for the same web3name. Like #5_w3n:john and #7_w3n:john still being the claimers of the w3n:john name.