Parse-SDK-Flutter icon indicating copy to clipboard operation
Parse-SDK-Flutter copied to clipboard

'pure query' and 'QueryBuilder.and' different results

Open catalunha opened this issue 1 year ago • 1 comments

New Issue Checklist

Issue Description

See the simple query for a range of dates. Or I believe any other query.

  final QueryBuilder<ParseObject> query =
      QueryBuilder<ParseObject>(ParseObject('TableOrClass'));
  final start = DateTime(2023, 06, 25);
  final end = DateTime(2023, 06, 27);

  query.whereGreaterThanOrEqualsTo(
      EventEntity.day, DateTime(start.year, start.month, start.day));
  query.whereLessThanOrEqualTo(
      EventEntity.day, DateTime(end.year, end.month, end.day, 23, 59));
query.query();

The result is as expected. The filter. Result: Correct filter

Now the same query but passing through QueryBuilder.and but with the same simple query as before.

  final QueryBuilder<ParseObject> query =
      QueryBuilder<ParseObject>(ParseObject('TableOrClass'));
  final start = DateTime(2023, 06, 25);
  final end = DateTime(2023, 06, 27);

  query.whereGreaterThanOrEqualsTo(
      EventEntity.day, DateTime(start.year, start.month, start.day));
  query.whereLessThanOrEqualTo(
      EventEntity.day, DateTime(end.year, end.month, end.day, 23, 59));

  QueryBuilder<ParseObject> queryAnd =
      QueryBuilder.and(ParseObject(EventEntity.className), [query]);

queryAnd.query();

The result should be the correct filter. But it returns all the data. In other words, it ignores the filter. But the and is pure. Shouldn't it be the same as the previous one? Result: all data

Steps to reproduce

any pure query and QueryBuilder.and

Actual Outcome

different results

Expected Outcome

different equals

Environment

Parse Flutter SDK

  • SDK version: 5.1.0
  • Flutter version: 3.10.5
  • Dart version: 3.0.5
  • Operating system version: POP

Server

  • Parse Server version: 4.10.4

Logs

catalunha avatar Jul 06 '23 20:07 catalunha

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.