TicketSQL for dependencies

RT folks,

Is there a reasonable way to search for tickets that have no
dependencies? The TicketSQL page on the wiki suggests that “DependsOn
is NULL” should work, but I get this error from the RT 3.6.6 “Edit
Query” form:

Error near ->NULL<- expecting a VALUE in 'DependsOn is NULL’
I’m lost

This is just a first step toward understanding how to search ticket
relationships. Ideally I would like to end up with a set of saved
searches that will make RT more useful for project management: I’d like
to have searches for “next actions” (tickets with no new/open
dependencies) and top-level projects (tickets with dependencies and that
nothing depends on).

Aaron D. Ball adb@broad.mit.edu
Senior Systems Analyst
Broad Institute of MIT and Harvard

quote NULL with single or double quote charOn Wed, Sep 3, 2008 at 12:09 AM, Aaron D. Ball adb@broad.mit.edu wrote:

RT folks,

Is there a reasonable way to search for tickets that have no
dependencies? The TicketSQL page on the wiki suggests that “DependsOn
is NULL” should work, but I get this error from the RT 3.6.6 “Edit
Query” form:

Error near ->NULL<- expecting a VALUE in 'DependsOn is NULL’
I’m lost

This is just a first step toward understanding how to search ticket
relationships. Ideally I would like to end up with a set of saved
searches that will make RT more useful for project management: I’d like
to have searches for “next actions” (tickets with no new/open
dependencies) and top-level projects (tickets with dependencies and that
nothing depends on).


Aaron D. Ball adb@broad.mit.edu
Senior Systems Analyst
Broad Institute of MIT and Harvard


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

Ruslan Zakirov wrote:

quote NULL with single or double quote char

Thanks! Oddly enough, searching on

DependsOn is ‘NULL’

seems to return only tickets that do depend on another ticket. I get
the same result with

DependsOn is not ‘NULL’

but it looks like

DependsOn = ‘NULL’

and

DependsOn != ‘NULL’

do what I want in that respect. I can’t say I have a terribly good
sense of the syntax of TicketSQL at this point, though.

Any suggestions for how to find tickets whose dependencies, if any, are
all closed? Is there a DependsOnStatus or something?

Aaron D. Ball adb@broad.mit.edu
Senior Systems Analyst
Broad Institute of MIT and Harvard

Ruslan Zakirov wrote:

quote NULL with single or double quote char

Thanks! Oddly enough, searching on

DependsOn is ‘NULL’

seems to return only tickets that do depend on another ticket. I get
the same result with

DependsOn is not ‘NULL’

but it looks like

DependsOn = ‘NULL’

and

DependsOn != ‘NULL’

do what I want in that respect. I can’t say I have a terribly good
sense of the syntax of TicketSQL at this point, though.

Any suggestions for how to find tickets whose dependencies, if any, are
all closed? Is there a DependsOnStatus or something?
Nope :frowning:


Aaron D. Ball adb@broad.mit.edu
Senior Systems Analyst
Broad Institute of MIT and Harvard


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

Thanks, Ruslan. I have updated the wiki page to reflect what I have
learned and cleaned it up a little:

http://wiki.bestpractical.com/view/TicketSQL

By the way, is there any kind of syntax reference for the “Wifty” wiki
you’re using? This page was a mess before because the kwiki syntax that
had been used wasn’t getting parsed properly, but I couldn’t find a
reference for the new syntax, even in the svn source for Wifty. I ended
up inferring enough syntax that I could make a usable page, but it was
harder than it had to be.

Aaron D. Ball adb@broad.mit.edu
Senior Systems Analyst
Broad Institute of MIT and Harvard

By the way, is there any kind of syntax reference for the “Wifty” wiki
you’re using? This page was a mess before because the kwiki syntax that
had been used wasn’t getting parsed properly, but I couldn’t find a
reference for the new syntax, even in the svn source for Wifty. I ended
up inferring enough syntax that I could make a usable page, but it was
harder than it had to be.

Generally, Wifty uses Markdown, but because this wiki was converted from
Kwiki, it uses Kwiki markup. Sadly, the only extant Kwiki parser
outside of Kwiki is Text::Kwikiformatish. Which clearly isn’t everything
we’d like it to be. The easiest fix is to patch that. Or write a
converter to move us to something more common. Either would be a
fantastic contribution to the community.