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
The rt-users Archives
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
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.
