How can I query weekly scores from my Firebase leaderboard in Swift?

To filter scores within a specific date range (such as a week), you'll need to store a timestamp (for example, a Unix epoch value) with each score entry in your database. Once each entry has a timestamp, you can query for items within a week by using the range methods (StartAt and EndAt) together with an order‑by method.

Steps to Achieve This

1. Add a Timestamp Field
   When saving a new score, include a "timestamp" field representing when the score was recorded. For example:

   SWIFTCopied
   let scoreData: [String: Any] = [
       "ID": "007O000000000000",
       "name": "meda",
       "number": "214",
       "timestamp": Date().timeIntervalSince1970 // Unix epoch time
   ]
   rootRef.child("Usernames").childByAutoId().setValue(scoreData)

2. Compute the Start and End of the Week
   Determine the Unix timestamp for the beginning and end of the week you’re interested in. For example:

   SWIFTCopied
   // This is just an example; adjust as needed for your regional calendar.
   let calendar = Calendar.current
   let now = Date()
   let startOfWeek = calendar.date(from: calendar.dateComponents([.yearForWeekOfYear, .weekOfYear], from: now))!
   let endOfWeek = calendar.date(byAdding: .day, value: 7, to: startOfWeek)!
   
   let startTimestamp = startOfWeek.timeIntervalSince1970
   let endTimestamp = endOfWeek.timeIntervalSince1970

3. Query Scores for the Week
   Use Firebase’s query methods to filter based on the timestamp field:

   SWIFTCopied
   let weekQuery = rootRef
       .child("Usernames")
       .queryOrdered(byChild: "timestamp")
       .queryStarting(atValue: startTimestamp)
       .queryEnding(atValue: endTimestamp)
       
   weekQuery.observe(.value) { snapshot in
       for child in snapshot.children.allObjects as! [DataSnapshot] {
           if let value = child.value as? NSDictionary {
               let userName = value["name"] as? String ?? "Name not found"
               let score = value["number"] as? String ?? "0"
               let id = value["ID"] as? String ?? "ID not found"
               
               // Process only those scores you actually need
               if let intScore = Int(score), intScore >= 50 {
                   // Add score to the array, save to Core Data, etc.
               }
           }
       }
   }

Key Points

• Data Structure:
  Your current database entry does not include date information. Without storing a timestamp along with your data, Firebase won’t be able to filter by date.

• Query Methods:
  Use queryOrdered(byChild:) to order the data by the timestamp and then use queryStarting(atValue:) and queryEnding(atValue:) to fetch only those scores within the specified week.

By adding the timestamp field and using these query methods, you can successfully fetch only those scores from Firebase that were recorded within a week.