Reporting Help!

[Stephen.whittle]

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. 

[Steven Boardman]

@Stephen.whittle give the following a try

* Sort on the date logged column descending

There is also the Service Manager reports, there is an aged tickets report which can be configured 

Hope that helps

 

[Stephen.whittle]

Thanks @Steven Boardman I'll give that a try. 

[Victor]

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(...)