Reporting Assist - Предложения / 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.

Comment (1)

Matthew Wray

5 лет назад

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

Автор: Adam Zweimiller
Last update: 21 мар. 2019 г.

Reporting Assist - Предложения / Feature Request - Deskpro Support

Reporting Assist Finished

Comment (1)

Метки (тэги)