Reporting Assist - Community / Feature Request - Deskpro Support

New Feature Request

3

Reporting Assist Finished

Adam Zweimiller

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.

Sylw (1)

Matthew Wray

5 years ago

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

Awdur: Adam Zweimiller
Last update: 21 Maw 2019

Reporting Assist - Community / Feature Request - Deskpro Support

Reporting Assist Finished

Sylw (1)

Labelau