How can I get all objects owned by an address?

[0x-j]

Is there a query that returns me all objects owned by an address? i.e. all objects whose ObjectCore'sowner is given address. For example. I can find this object when querying address 0xcab918f5f28bab478e237cd15c3750b3fa3f95ec0505510a24aa663efb348dd3 .

I run into this requirement when building an NFT marketplace, each NFT listing is stored in an object whose owner is the seller. In order to get all listings from a seller, I need this query.

[0x-j]

@gregnazario I think you have some context? I'm looking at your marketplace example, it looks like we must use custom processor to get all listings and offers (nft_marketplace_v2_xxx queries in hasura)?

[0x-j]

What I actually want is a query that returns all resources (type is listing struct) from all objects owned by an address.

[0x-j]

There's is an object table current_objects in lab hosted indexer, you can play with it on hasura.

Sample query

query MyQuery {
  current_objects(
    where: {owner_address: {_eq: "0x7aade3ee4d7fa7c56e1cb04cdf3387602ad887196a4d1b9cf78bde293b8e8e7a"}}
  ) {
    state_key_hash
    owner_address
    object_address
    last_transaction_version
    last_guid_creation_num
    allow_ungated_transfer
    is_deleted
  }
}

We don't have an API in ts sdk to query objects table, but you can use call the queryIndexer API and pass the graphql manually.

const objects = await aptos.queryIndexer({
  query: {
    query: `
      query MyQuery($ownerAddress: String) {
        current_objects(
          where: {owner_address: {_eq: $ownerAddress}}
        ) {
          state_key_hash
          owner_address
          object_address
          last_transaction_version
          last_guid_creation_num
          allow_ungated_transfer
          is_deleted
        }
      }
      `,
    variables: { ownerAddress:"0x12345" },
  },
});