Skip to main content
Bahasa Indonesia Bălgarski Čeština Cymraeg Cрпски Dansk Deutsch Eesti keel English English (UK) Español Français Gaelic Hrvatski Íslenska Italiano Latviešu valoda Lietuvių kalba Magyar Malti Nederlands Norsk Polski Português (Brasil) Português (Europeu) Pусский Română Slovenčina Slovenian Svenska Tiếng Việt Türkçe Ελληνικά македонски الإنجليزية فارسی 日本語 英语（美国） 영어
Ota yhteyttä

New to Deskpro Support? Register for an account

Need a password reminder?

Reporting Assist - Palaute / Feature Request - Deskpro Support

New Feature Request
Reporting Assist Palaute
3

Reporting Assist Finished

I am trying to pull a list of unresolved tickets older than 30 days. I have the report in a semi-working state. 


It looks to me like your date placeholders would show tickets within the last 30 days. We want ALL tickets that are OLDER than 30 days. Essentially the inverse of this. We want to exclude tickets younger than 30 days and show everything else.

Comment (1)

Matthew Wray
Hi Adam, I think you should be able to achieve the needed using the DPQL referenced in this Guide section: https://support.deskpro.com/en/guides/reports-guide/example-reports/ticket-backlog-with-a-custom-timeframe-old WHERE tickets.date_created > (NOW() - INTERVAL 30 DAY)
New Feature Request
Reporting Assist Palaute

Tunnisteet

Date & Time Reports
Tekijä
Adam Zweimiller
Last update
21.3.2019