Real-Dev-Squad / website-backend

The backend code for all our website-related apps
https://api.realdevsquad.com/
MIT License
55 stars 258 forks source link

Indexes needed for searching ProfileDiffs #2202

Closed lakshayman closed 1 month ago

lakshayman commented 1 month ago

Issue Description

We must create the following Firestore indexes for the profileDiffs collection. These indexes are required to handle search queries.

Indexes to be Created: Index 1:

Collection: profileDiffs
Fields:
approval: Ascending
userId: Ascending
timestamp: Descending
__name__: Descending

The index below should be in Prod, please create it if it is not there. Index 2:

Collection: profileDiffs
Fields:
approval: Ascending
userId: Ascending
timestamp: Ascending
__name__: Ascending
ankushdharkar commented 1 month ago

First index already exists. Second one has been created in prod

image