Mismatch in results

[yogesh-bansal]

It says chain 1 has 29 rounds, while we can count 30 in https://indexer-grants-stack.gitcoin.co/data/1/rounds/
Any reason why is that so?

[ccerv1]

I replicated the issue.

I see 31 rounds on the indexer and 29 projects in the database. Specifically, these two rounds are not in the database:

• 0x4377F757b36C1012887A02Db672063BB8ff4f50a
• 0x69e423181f1D3E6BEbF8aB88030C36DA73785f26

To make it easier to replicate the query:

SELECT "chainId", "roundId"
FROM public."Round"
WHERE "chainId" = 1

[ghostffcode]

This is usually caused by the cut-off date when the data was indexed. If a round isn't available in the Gitcoin grants indexer by the time the ETL is run, it won't be available in the ETL. Currently working on a feature to allow indexing a specific round using the round address.