Hi GameSparks team,

I need to count longest winning streak of user. I have a leader board set up to update monthly.

I store result of match in running collection with 3 variables: playerId, result, Date
Result is match’s result (W or L)

Date is a stored date of record but I don’t what I should do next.
I found in google:

http://www.sqlteam.com/article/detecting-runs-or-streaks-in-your-data

That should how to solve it by mysql but GameSpark use MongoDB. It’s quiet different.

I can use customCollection to find player by id and sort by date. After that I run for loop to count result value.
Do you have any better solution?

Thank you.

Thank you for your reply.

But we need to count longest winning streak. Your suggestion just only count number of win or lose match.

I think we should create a query to count of maximums consecutive records based on result.

Thanks 

Phuc