Skip to content

Auto-Notify Module 1.5.1

Choose a tag to compare

@mullen2 mullen2 released this 09 Apr 18:22
· 63 commits to main since this release
  • Fixed age operators
    • Removed "age =" and "age <>" operators, because these server no practical purpose
      • Age is based on the time the query is executed, so except for the case where someone runs the query at the exact time of the value specified, "age =" will always be false and "age <> will always be true
    • Changed the underlying SQL time function used from TIMESTAMPDIFF to DATE_SUB
      • TIMESTAMPDIFF was truncating values based on the units specified, so specifying "age > 1 year" was equivalent to "age >= 2 years", because year values greater than 1 and less than 2 were truncated to 1, e.g., 1.7 was truncated to 1
      • Improved help for the age operators
  • Added option groups to the variable dropdown for conditions in the query builder
  • Made changes to make the capitalization of null values and generated SQL queries more consistent