Skip to content

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

@catalunha

Description

@catalunha

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    type:bugImpaired feature or lacking behavior that is likely assumed

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions