Here is a power user's tip for querying the logs table directly.

Keep in mind: you'll want to add a `block_num` predicate since we don't have an index on tx_hash.

This is useful if you want all logs for a specific tx.

Here is a power user's tip for querying the logs table directly.

Keep in mind: you'll want to add a `block_num` predicate since we don't have an index on tx_hash.

This is useful if you want all logs for a specific tx.

https://www.indexsupply.net/query?query=select+topics%2C+data+%0Afrom+logs+%0Awhere+tx_hash+%3D+0x856230d65058272c1c53722e758c737f190722523f745b2e62dddcf33ee31179%0Aand+block_num+%3D+26774642&event_signatures=&chain=8453

Indexing Ethereum https://indexsupply.com

Support email: support@indexsupply.com

hello there, what is the best place to ask questions about index supply? i don't see a index supply channel, should i post the question to github issue? In our contract event there is a `struct`, is that possible to query the data based on a sub-field inside the struct/tuple?

nvm i've figured it out, using postgres json operator`->>` works

If you have a Pro plan we can setup direct chat support. Otherwise email: support@indexsupply.com -- or just mention on FC ;)

Yes! Sounds like you found the PG JSON arrow operator.