brick icon indicating copy to clipboard operation
brick copied to clipboard

Getting right a query with date grater than now()

Open stefanorumi7 opened this issue 2 months ago • 0 comments

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?

stefanorumi7 avatar Nov 06 '25 15:11 stefanorumi7