Hi Matt,
On 30/06/11 19.21, Matt wrote:
If anyone else was interested, I figured this out. Still hard to
understand what's going on behind the scenes, but this works:
SELECT id AS ticket, a.summary AS Summary, a.priority AS Priority,
a.status AS Status, a.owner AS Owner
FROM ticket a
WHERE
a.status<> 'closed'
and type='task'
and a.id NOT IN(SELECT ticket FROM ticket_custom WHERE name =
"drp_resources")
ORDER BY priority, time
the table that Agilo uses storing links between tickets is called
agilo_link.
You can use that table if you want to filter in/out tickets based on link
predicates.
Here is an example that might fit you case
SELECT a.id AS ticket, a.summary AS Summary, a.priority AS Priority,
a.status AS Status, a.owner AS Owner
FROM ticket a
LEFT JOIN agilo_link link ON a.id = link.dest
LEFT JOIN ticket b ON link.src = b.id
WHERE
a.status <> 'closed'
and a.type='task'
and b.type <> 'story'
ORDER BY a.priority, a.time
Do you think that this might work for you?
Cheers
Stefano Rago
--
Follow Agilo on Twitter: http://twitter.com/agiloforscrum
Please support us by reviewing and voting on:
http://userstories.com/products/8-agilo-for-scrum
http://ohloh.net/p/agilo-scrum
http://freshmeat.net/projects/agiloforscrum
You have received this message because you are subscribed to
the "Agilo for Scrum" Google Group. This group is focused on
supporting Agilo for Scrum users and is moderated by
Agilo Software GmbH <http://www.agiloforscrum.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
