[Bug]: Analytics export filter uses display name "DoubtDesk AI" instead of email "ai@doubtdesk.com", inflating top contributor statistics

[vipul674]

Bug Description

The analytics CSV export endpoint (GET /api/analytics/export) has an incorrect filter string for excluding AI replies from the top contributors calculation. It uses "DoubtDesk AI" (a display name) instead of "ai@doubtdesk.com" (the actual email address used for AI replies). Since no reply has userEmail equal to "DoubtDesk AI", the filter never matches any rows, and AI replies are included in the top contributor counts — artificially inflating them.

Steps to Reproduce

1. Ensure the classroom has at least one AI reply (created with userEmail: "ai@doubtdesk.com")
2. As a teacher, call GET /api/analytics/export?classroomId=<id>
3. Download the generated CSV file
4. Observe that the "Top Contributors" section includes entries with name "DoubtDesk AI" or "ai@doubtdesk.com" (the AI)
5. Compare with the JSON analytics endpoint (GET /api/analytics) which correctly filters out AI replies

Expected Behavior

The export CSV should exclude AI-generated replies from the top contributors list, matching the behavior of the regular analytics JSON endpoint.

Actual Behavior

In src/app/api/analytics/export/route.ts (approximately line 174):

ne(repliesTable.userEmail, "DoubtDesk AI")

This uses the display name "DoubtDesk AI" which never matches any stored userEmail. The correct filter should be "ai@doubtdesk.com".

Compare with the regular analytics endpoint in src/app/api/analytics/route.ts (approximately line 98):

ne(repliesTable.userEmail, 'ai@doubtdesk.com')

The regular endpoint correctly uses the email address, so it properly excludes AI replies from top contributors. The export endpoint does not.

Environment

• OS: All
• Browser: All

Additional Context

The AI reply user email is stored as "ai@doubtdesk.com" (confirmed in the recentAIReplies query at line ~100 of the regular analytics route which filters eq(repliesTable.userEmail, 'ai@doubtdesk.com')). The export route's "DoubtDesk AI" string is likely a display name, not a database value, which is why it doesn't match any rows.

Files affected:

• src/app/api/analytics/export/route.ts — incorrect filter value
• src/app/api/analytics/route.ts — correct filter value (reference)

Suggested Fix

Change the filter in src/app/api/analytics/export/route.ts from:

ne(repliesTable.userEmail, "DoubtDesk AI")

to:

ne(repliesTable.userEmail, "ai@doubtdesk.com")

This will align the export endpoint's behavior with the regular JSON analytics endpoint.

GSSoC 2026

I would like to work on this issue under GSSoC 2026. Please assign it to me.

[vipul674]

/assign

[github-actions]

Hello @vipul674! 👋 Thanks for your interest in working on this issue.

We have automatically notified the maintainers for you. They will review your request and officially assign the issue to you shortly if it's available.

Note: Please do not start working or raise a pull request until you are officially assigned!

[vipul674]

@knoxiboy I would like to work on this issue under GSSoC 2026. Please assign it to me.

[aaniya22]

pls assign this to me under gssoc

[github-actions]

Hello @aaniya22! 👋 Thanks for your interest in working on this issue.

We have automatically notified the maintainers for you. They will review your request and officially assign the issue to you shortly if it's available.

Note: Please do not start working or raise a pull request until you are officially assigned!

[github-actions]

✅ Hi @vipul674, you have been assigned to this issue! You have 7 days to work on this issue and create a PR. Happy coding! 🚀

[github-actions]

Hi @vipul674! You were assigned to this issue 5 days ago. Please open a pull request within the next 2 days to keep your assignment, or you will be automatically unassigned. Thank you!

[github-actions]

Hi @vipul674, this issue has been automatically unassigned because you have not submitted a pull request within 7 days of being assigned. Feel free to request assignment again when you are ready to work on it! 🙏