Back to All

Aptos indexer events ordering

Hi Nodit team,

I want to get Aptos events for the last month only.

I tried ordering by transaction_version and transaction_block_height and I tried where condition transaction_block_height: { _gte: ${maxBlockheight} } and without this condition.

Every time I get events that are from like November 2023.

const maxBlockheight = 352539186;
const query = `
        query MyQuery {
          events(
            offset: 0
            order_by: { transaction_version: desc }
            where: { 
              transaction_block_height: { _gte: ${maxBlockheight} }
            }
          ) {
            account_address
            creation_number
            data
            event_index
            indexed_type
            sequence_number
            transaction_block_height
            transaction_version
            type
          }
        }
      `;

Thanks for the help :)