Hi Stefano.
A couple hours after this, I realized that Agilo adds drp_resource as
a name in ticket_custom automatically, and that any imported tickets
that were "touched" in agilo would contain this value.
I searched for the Agilo data schema and eventually found something
and wrote this:
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 dest FROM agilo_link)
ORDER BY priority, time
I think your query is the same but written better.
I don't understand why Agilo doesn't have their schema posted
somewhere easy to find! Almost all the work it took me to do this was
spend guessing and hunting for the schema!
thanks,
m.
On Jul 1, 4:03 am, Stefano Rago <[email protected]>
wrote:
> 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
