Uploaded image for project: 'Subscription Watch'
  1. Subscription Watch
  2. SWATCH-2105

Constrain tally floorist exports to 1 day's range

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Normal
    • 2024-02-05 - API
    • None
    • None

    Description

      Currently, the where clause includes this expression

      snapshot_date > now() - interval '2 day'

      However, depending on timing, this sometimes gathers 1 days data, sometimes 2 days worth.

      Instead, change the clause to

      snapshot_date=date_trunc('day', now() - interval '2 day') 

      which will force the query to pull only data from tallies for 2 days ago.

      Attachments

        Activity

          People

            jcarvaja@redhat.com Jose Carvajal Hilario
            khowell@redhat.com Kevin Howell
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: