Domain Events

Fetch recent events for a Domain by its canonical name. This example joins the events, domain_events, and domains tables to retrieve domain events associated with the vitalik.eth name. See Connect for setup.

SQL
ensdb-sdk (TypeScript)

SQL

SELECT
  e.chain_id,
  e.block_number,
  e.transaction_hash,
  e.log_index,
  e.address as contract_address,
  e.sender,
  d.id as domain_id
FROM "ensindexer_0".events e
JOIN "ensindexer_0".domain_events de ON e.id = de.event_id
JOIN "ensindexer_0".domains d ON de.domain_id = d.id
WHERE d.canonical_name = 'vitalik.eth'
AND d.canonical = true
ORDER BY e.block_number DESC, e.log_index DESC
LIMIT 5;

Output

#	chain_id	block_number	transaction_hash	log_index	contract_address	sender	domain_id
1	`11155111`	`6023942`	`0x6206e95dc5ba5fc8d0804283498f17bac18081437b4198c824b62ee851622ba5`	`194`	`0xfed6a969aaa60e4961fcd3ebf1a2e8913ac65b72`	`0x225f137127d9067788314bc7fcc1f36746a3c3b5`	`11155111-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0xee6c4522aab0003e8d14cd40a6af439055fd2577951148c14b6cea9a53475835`
2	`11155111`	`6023942`	`0x6206e95dc5ba5fc8d0804283498f17bac18081437b4198c824b62ee851622ba5`	`193`	`0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85`	`0x225f137127d9067788314bc7fcc1f36746a3c3b5`	`11155111-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0xee6c4522aab0003e8d14cd40a6af439055fd2577951148c14b6cea9a53475835`
3	`11155111`	`4107392`	`0xf143118eb4100361f040b1ae5627562125f0cf1717073a8204befe5e512c80d4`	`22`	`0x0635513f179d50a207757e05759cbd106d7dfce8`	`0x179a862703a4adfb29896552df9e307980d19285`	`11155111-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0xee6c4522aab0003e8d14cd40a6af439055fd2577951148c14b6cea9a53475835`
4	`11155111`	`4107386`	`0x6410de03e9a2f12543e491d1048209e5638d702948cf23d48a63d96a50efd20d`	`19`	`0xfed6a969aaa60e4961fcd3ebf1a2e8913ac65b72`	`0x179a862703a4adfb29896552df9e307980d19285`	`11155111-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0xee6c4522aab0003e8d14cd40a6af439055fd2577951148c14b6cea9a53475835`
5	`11155111`	`4107386`	`0x6410de03e9a2f12543e491d1048209e5638d702948cf23d48a63d96a50efd20d`	`16`	`0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e`	`0x179a862703a4adfb29896552df9e307980d19285`	`11155111-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0xee6c4522aab0003e8d14cd40a6af439055fd2577951148c14b6cea9a53475835`

Output matches a result snapshot; live output depends on your ENSNode instance.

TypeScript

import { and, desc, eq } from "drizzle-orm";

const name = "vitalik.eth";
const limit = 5;

const domainEvents = await ensDb
  .select({
    chainId: ensIndexerSchema.event.chainId,
    blockNumber: ensIndexerSchema.event.blockNumber,
    transactionHash: ensIndexerSchema.event.transactionHash,
    logIndex: ensIndexerSchema.event.logIndex,
    contractAddress: ensIndexerSchema.event.address,
    sender: ensIndexerSchema.event.sender,
    domainId: ensIndexerSchema.domain.id,
  })
  .from(ensIndexerSchema.event)
  .innerJoin(
    ensIndexerSchema.domainEvent,
    eq(ensIndexerSchema.event.id, ensIndexerSchema.domainEvent.eventId),
  )
  .innerJoin(
    ensIndexerSchema.domain,
    eq(ensIndexerSchema.domainEvent.domainId, ensIndexerSchema.domain.id),
  )
  .where(
    and(
      eq(ensIndexerSchema.domain.canonicalName, name),
      eq(ensIndexerSchema.domain.canonical, true),
    ),
  )
  .orderBy(
    desc(ensIndexerSchema.event.blockNumber),
    desc(ensIndexerSchema.event.logIndex),
  )
  .limit(limit);

console.log(domainEvents);

Output

#	chainId	blockNumber	transactionHash	logIndex	contractAddress	sender	domainId
1	`11155111`	`6023942`	`0x6206e95dc5ba5fc8d0804283498f17bac18081437b4198c824b62ee851622ba5`	`194`	`0xfed6a969aaa60e4961fcd3ebf1a2e8913ac65b72`	`0x225f137127d9067788314bc7fcc1f36746a3c3b5`	`11155111-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0xee6c4522aab0003e8d14cd40a6af439055fd2577951148c14b6cea9a53475835`
2	`11155111`	`6023942`	`0x6206e95dc5ba5fc8d0804283498f17bac18081437b4198c824b62ee851622ba5`	`193`	`0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85`	`0x225f137127d9067788314bc7fcc1f36746a3c3b5`	`11155111-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0xee6c4522aab0003e8d14cd40a6af439055fd2577951148c14b6cea9a53475835`
3	`11155111`	`4107392`	`0xf143118eb4100361f040b1ae5627562125f0cf1717073a8204befe5e512c80d4`	`22`	`0x0635513f179d50a207757e05759cbd106d7dfce8`	`0x179a862703a4adfb29896552df9e307980d19285`	`11155111-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0xee6c4522aab0003e8d14cd40a6af439055fd2577951148c14b6cea9a53475835`
4	`11155111`	`4107386`	`0x6410de03e9a2f12543e491d1048209e5638d702948cf23d48a63d96a50efd20d`	`19`	`0xfed6a969aaa60e4961fcd3ebf1a2e8913ac65b72`	`0x179a862703a4adfb29896552df9e307980d19285`	`11155111-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0xee6c4522aab0003e8d14cd40a6af439055fd2577951148c14b6cea9a53475835`
5	`11155111`	`4107386`	`0x6410de03e9a2f12543e491d1048209e5638d702948cf23d48a63d96a50efd20d`	`16`	`0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e`	`0x179a862703a4adfb29896552df9e307980d19285`	`11155111-0x00000000000c2e074ec69a0dfb2997ba6c7d2e1e-0xee6c4522aab0003e8d14cd40a6af439055fd2577951148c14b6cea9a53475835`

Output matches a result snapshot; live output depends on your ENSNode instance.