Hello.
I'm trying to write a custom query that will return all Tasks that are
not Referenced By a User Story. I can't seem to get this to work
because I don't understand how Agilo makes this reference between
tickets. Does anyone know how to do this?
This is what I'm going for:
SELECT id AS ticket, summary, type, status, severity, priority,
owner,
time as created
FROM ticket
WHERE status <> 'closed'
and type='task'
and XXXXXXXXXXXXXXXXXX
ORDER BY priority, time
Where XXXXXXXXXX is a statement that will allow me to join into
whatever the reference table is that connects tickets in the
Referenced By/References relationship so that I can exclude any Tasks
that are referenced by a User Story.
I can write the query a few different ways, however I need to know the
name of the tables and fields. Trac provides a data schema, but I
can't find one for Agilo.
http://trac.edgewall.org/attachment/wiki/TracDev/DatabaseSchema/trac-schema-v2.png
thanks,
m.
--
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
