[TicketQuery] with reports

[Markus.Staab]

Would be nice to output the tickets of a report with the TicketQuery macro

[marcus@…]

+1 This would be very useful!

[petr.odut@…]

I would appreciate this also :)

[Remy Blank]

Sounds useful indeed. A working patch would speed up the integration of this feature :-)

[Christian Boos]

Milestone 2.0 deleted

[ebersac@…]

+1

[kontakt at meitzner dot net]

I would need this functionality also. I have a report to list tickets from the latest/most recent milestone (actual Sprint backlog), which I resolve in SQL with a subselect on milestones, ORDER BY <milestone-date> DESC LIMIT 1. This can as of now not be done with TracQuery Syntax, so I cannot report on tickets from e.g. the actual backlog with the TicketQuery Macro without having to change multitudes of hard references to milestones in my reporting overview whenever I start a new Sprint.

It works with ​TicketBoxMacro (e.g. [[TicketBox([report:1])]], maybe some inspiration can derive therefrom), but TBM does not give me table output like TicketQuery Macro does.

So it would definitely be helpful to have something like [[TicketQuery(report=9,table)]], despite the plans to abandon SQL reports at all (plans I do not endorse unless TracQueries give me everything I can do with SQL, btw.)

[ben_12]

+1

[anonymous]

+1

[Ryan J Ollos]

Duplicate of #12810. See also ​th:WikiReportMacro.

[Ryan J Ollos]

Replying to kontakt at meitzner dot net:

So it would definitely be helpful to have something like [[TicketQuery(report=9,table)]], despite the plans to abandon SQL reports at all (plans I do not endorse unless TracQueries give me everything I can do with SQL, btw.)

Unlikely that TracReports will be abandoned. See also #12786.