mWater / mwater-visualization

GNU Lesser General Public License v3.0
3 stars 5 forks source link

Failure to cache time-dependent chart data #428

Closed grassick closed 5 years ago

grassick commented 5 years ago

Charts with "Days since" or similar expressions that use the current time and date aren't cached properly, as each query looks different!

Ideas:

grassick commented 5 years ago

Affected operators are:

All three could use the to_json(now() at time zone 'UTC')#>>'{}' trick, but does mean adding "at time zone" function to jsonql.