Skip to content

Getting right a query with date grater than now() #659

Description

@stefanorumi7

I have the following query that is returning nothing, but according to the data, it should.

final query = Query(
      where: [
        Where('columnA', value: valueA),
        WherePhrase([
          const Or('dateColumn').isExactly(null),
          const Or(
            'dateColumn',
          ).isGreaterThan(DateTime.now().toUtc().toIso8601String()),
        ]),
      ],
      limit: 1,
    );

What am I doing wrong?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions