Hi Ruben, On 23/apr/2012, at 14:43, Aquarius wrote:
> Trying to build up list of tickets, e.g. bugs ordered in the way they > appear in backlog (that has this drag-n-drop ability). > > Using something like this within wiki page to show: > > [[TicketQuery(status=accepted|assigned|new|reopened| > accepted,priority=blocker|critical,order=???????,type=bug,col=id| > summary|owner|status|priority|sprint|reporter,format=table)]] > > What shall be placed instead of question marks as order so that > tickets appear accordingly? The priority attribute is not from the ticket itself but from the Agilo ticket. Hence you cannot use it in such query. You can, though, write a custom report query like this: select * from agilo_backlog_ticket bt left join ticket t on bt.ticket_id = t.id where bt.name = 'Product Backlog' order by bt.pos Replace the '*' with the fields you need and instead of 'Product Backlog' you can set any backlog name. If you need a specific ticket type, just add something like " and t.type = 'story' " to the 'where' clause. Hope this helps Cheers Stefano Rago -- Follow Agilo on Twitter: http://twitter.com/agilofortrac Please support us by reviewing and voting on: http://userstories.com/products/8-agilo-for-scrum http://ohloh.net/p/agilo-trac http://freshmeat.net/projects/agiloforscrum You have received this message because you are subscribed to the "Agilo for Trac" Google Group. This group is focused on supporting Agilo for Trac users and is moderated by Agilo Software GmbH <http://www.agilosoftware.com>. To post to this group, send email to [email protected] To unsubscribe from this group, send an email to [email protected] For more options, visit this group at http://groups.google.com/group/agilo
