CODEWITHSUNDEEP
c#firebaseunity-game-enginegoogle-cloud-firestore
Mehmet
Mehmet

Reputation: 21

Firestore collectionGroup query returns empty result in Unity

My Firestore database setup is

enter image description here

i want to find "playerName" field value in "UserBasicInfo" subcollections. here is mycode:

`

Firebase.Firestore.Query query = db.CollectionGroup("UserBasicInfo").WhereEqualTo("playerName", name).Limit(1);

var queryNameTask = query.GetSnapshotAsync();

while (!queryNameTask.IsCompleted) await Task.Yield();

        var querySnapshot = queryNameTask.Result;

        foreach (DocumentSnapshot documentSnapshot in querySnapshot.Documents)
        {
            DatabasePlayerStats databasePlayerStats = documentSnapshot.ConvertTo<DatabasePlayerStats>();
            searchingName = databasePlayerStats.playerName;
        }`

even if "name" exist in "playerName" field value query always return empty.

here is my index Exemptions:

enter image description here

Upvotes: 1

Views: 517

Answers (1)

Mehmet
Mehmet

Reputation: 21

I tried another query same path but this condition is WhereGreaterThanOrEqualTo. and surprisingly query result is not empty but it provide WhereGreaterThan condition but not provide equal condition. here is my new query code:

Query query = db.CollectionGroup("UserBasicInfo").WhereGreaterThanOrEqualTo("playerName", name); var queryNameTask = query.GetSnapshotAsync(); while (!queryNameTask.IsCompleted) await Task.Yield(); var querySnapshot2 = queryNameTask.Result;

Could problem be related to the equality query only?

Upvotes: 1

Related Questions