This project has moved and is read-only. For the latest updates, please go here.


Tickets By Author includes inactive users


I would love to see this query only use active users as disable or inactive users data does not seem relevant and should have been closed, deleted or assigned to another user. Unfortunately I cannot change the Select statement as the rebuild would require purchasing the reporting tool. I cannot see how to do this with only the designer since the required u1.status is not selected in the query. Would it be possible to include this flag in the next release so that the report can be customized with only active users?

Great utility by the way.
Closed Jul 23, 2015 at 3:05 PM by JBartlau
Closed with V 2.0


eAlacali wrote Jun 15, 2015 at 9:45 AM

Hi Jason,
Thank you for the suggestion.
We check if we implement the request in the next release.
Best regards

eAlacali wrote Jun 17, 2015 at 1:52 PM

Hi Jason,
we have added the columns u1.status for Author and Assigned User now it is possible to create a filter.
The new columns will be available with the next release.
Best regards

wrote Jul 23, 2015 at 3:05 PM