Jump to content

Reporting Help!

Recommended Posts

Excuse my limited sql knowledge. I am trying to run a report in the reports module against outstanding requests older than X days. 

The preset variables do not allow for this specific detail so I would like to use the "customer criteria" option but simply pasting in some sql doesn't seem to be working for me. Is anyone able to help. Using this SQL. 


h_datelogged < DATE_SUB(CURDATE(), INTERVAL 30 DAY) and configured as per attached. The report is still resolving requests logged in less than 30 days in this example. 

Annotation 2020-05-27 174736.png

Link to comment
Share on other sites

Just to highlight where the issue is/was. The fields should not be added in the value section for custom criteria on that filter..


If you look at how that second criterion looks like you'll see why, as it basically says:

Date Logged is greater than Datelogged is less than DATE_SUB(...)

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...