count() does not work when we add whereWithinKilometers() query for parse objects.

[hgandhi67]

New Issue Checklist

• [x] I am not disclosing a vulnerability.
• [x] I am not just asking a question.
• [x] I have searched through existing issues.
• [x] I can reproduce the issue with the latest version of Parse Server and the Parse Flutter SDK.

Issue Description

QueryBuilder().count() method does not work when we add whereWithinKilometers() query for any parse objects in QueryBuilder.or(EventsModel(),[query1 , query2]).

It returns InternalServerError, where as QueryBuilder().query() works completely fine in QueryBuilder.or(EventsModel(),[query1 , query2]) and returns the results as expected.

Steps to reproduce

final query1 = QueryBuilder(EventsModel());
query1.whereEqualTo(keyStatus, EVENT_STATUS_APPROVED);
query1.whereGreaterThanOrEqualsTo(keyDate, oneHrBeforeTime);
query1.whereContainedIn(keyEventStatus, [EVENT_STATUS_ONGOING, EVENT_STATUS_RESCHEDULED]);

final query2 = QueryBuilder(EventsModel());
query2.whereValueExists(keyRecurrentEvent, true);
query2.whereEqualTo(keyRecurrentEvent, true);
query2.whereEqualTo(keyStatus, EVENT_STATUS_APPROVED);
query2.whereContainedIn(keyEventStatus, [EVENT_STATUS_ONGOING, EVENT_STATUS_RESCHEDULED]);

final mergedQuery = QueryBuilder.or(EventsModel(), [query1, query2]);
mergedQuery.whereWithinKilometers(keyGeoPoint, currentUser.getGeoPoint!, 100);
mergedQuery.orderByDescending(EventsModel.keyTime);
mergedQuery.setLimit(100);

final response = await mergedQuery.count();

Actual Outcome

Status Code: 1 Type: InternalServerError Error: null

Expected Outcome

Function: ParseApiRQ.query Status Code: 200 Payload: [EventsModel(), EventsModel(), EventsModel()]

Environment

Parse Flutter SDK

• SDK version: 5.1.2
• Flutter version: 3.7.12
• Dart version: 2.19.6
• Operating system version: Mobile

Server

• Parse Server version: 5.1.2

Logs

[parse-github-assistant[bot]]

Thanks for opening this issue!

• 🚀 You can help us to fix this issue faster by opening a pull request with a failing test. See our Contribution Guide for how to make a pull request, or read our New Contributor's Guide if this is your first time contributing.

[mtrezza]

I'm closing this as it does not use the issue template provided when creating an issue and therefore lacks essential information required to investigate the issue. Please edit your initial post using the issue template and we can re-open this issue.