TrackQuery

[Aquarius]

Dear community,

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?

Thanks in advance,
Ruben.

[Stefano Rago]

Hi Ruben,

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