AQL function startOfDay() doesn't work when using >= operator

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Low
    • Component/s: Assets - AQL
    • None
    • 1
    • Minor

      Issue Summary

      The AQL operator GREATER_THAN_OR_EQUALS (>=) doesn't work with startOfDay() function when filtering by Date attribute.

      Steps to Reproduce

      1. Add an attribute Date to the object.
      2. Fill it with the today date.
      3. Use the AQL: "Date" >= startOfDay()
      4. If you added the date attribute with today's date, the AQL: "Date" = startOfDay() works, but the "Date" >= startOfDay() doesn't work.

      Expected Results

      The AQL should return the object when the date matches today's.

      Actual Results

      No object is found.

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

              Assignee:
              Unassigned
              Reporter:
              Cássio Wollmann
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated: