[GraphQL] How to filter transaction list by token?

[mahnunchik]

The list of transactions by address can be obtained by the following query:

query fff($affectedAddress: SuiAddress) {
  transactionBlocks(
    filter: {
      affectedAddress: $affectedAddress
    }
    last: 10
  ) {
    nodes {
      digest,
      sender {
        address
      }
      effects {
        status
        balanceChanges {
          nodes {
            amount
            coinType {
              repr
            }
            owner {
              address
            }
          }
        }
      }
    }
    pageInfo {
      hasNextPage
      hasPreviousPage
      startCursor
      endCursor
    }
  }
}

Now the question: is it possible to filter transactions of a specific token that are received or sent from an address?

Will the filter help function: ?? - ?

[Emadalshamery]

Yes

[wlmyng]

Appreciate you giving graphql a try!

is it possible to filter transactions of a specific token that are received or sent from an address?

This is not supported out of the box unfortunately, because our base implementation is meant to be generic enough to extend upon, without privileging a particular app or protocol. This becomes problematic in light of the feature above. We would need a feature table that maps a token type to a transaction, similar to existing tables that map transactions to affected addresses. However, because every transaction uses at least SUI tokens for gas, this would be a very large table that doesn't do much to help optimize read queries.

Instead, someone can start their own custom indexing solution, perhaps by modifying the indexer to commit to a dedicated table that maps a particular token of interest to txs. You can then add a custom graphql resolver to expose this.

But if you can approximate this functionality using the transaction's function field, or some other available filter, that could also work. For example, if there is a specific function that interacts with a specific token, then you can just filter on that function + address.