Got it....the space in the custom field name was causing it to fail...
/opt/rt3/bin/rt list -i "'CF.{Severity Level}' = 'Sev 4'"
That works. Thanks for pushing in the right direction...sometimes I
just need a nudge.
-Stark
The contents of this communication are considered SumTotal Confidential,
and should not be shared with anyone outside of SumTotal, either
electronically or verbally, without the express permission of the
author(s).
-----Original Message-----
From: Kenneth Marshall [mailto:[EMAIL PROTECTED]
Sent: Friday, July 06, 2007 11:00 AM
To: Jeff Stark
Cc: Kevin Falcone; RT Users
Subject: Re: [rt-users] RT CLI and Custom Fields
Do any of the CLI custom field queries work? Is the rt command using the
correct RT URL? These errors look similar to ones I received with RT
3.4.
Ken
On Fri, Jul 06, 2007 at 07:52:45AM -0700, Jeff Stark wrote:
> Strangely enough....this works just fine:
>
> /opt/rt3/bin/rt list -i "Status = 'in-review' AND Resolved < '2 days
> ago'"
>
> -Stark
>
>
> -----Original Message-----
> From: Kenneth Marshall [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 06, 2007 10:47 AM
> To: Jeff Stark
> Cc: Kevin Falcone; RT Users
> Subject: Re: [rt-users] RT CLI and Custom Fields
>
> Wow. The next step for me would be to run the CLI rt in debug mode and
> check that the commandline arguments are being passed in correctly.
> It may be that you need to do some more escaping to have it work.
>
> Ken
>
> On Fri, Jul 06, 2007 at 07:43:25AM -0700, Jeff Stark wrote:
> > When I remove the parenthesis and try this I get the following:
> >
> > [EMAIL PROTECTED] obj]# /opt/rt3/bin/rt list -i 'CF.{Severity Level} =
> > "Sev 3"'
> > rt: Invalid query: ''.
> > Invalid query: ''.
> >
> > [EMAIL PROTECTED] obj]# /opt/rt3/bin/rt list -i "CF.{Severity Level} =
> > 'Sev 3'"
> > rt: Invalid query: ''.
> > Invalid query: ''.
> >
> >
> > -Stark
> >
> >
> >
> > -----Original Message-----
> > From: Kenneth Marshall [mailto:[EMAIL PROTECTED]
> > Sent: Friday, July 06, 2007 10:18 AM
> > To: Jeff Stark
> > Cc: Kevin Falcone; RT Users
> > Subject: Re: [rt-users] RT CLI and Custom Fields
> >
> > Why are you putting the value in parentheses? The simple string in
> > single quotes should work.
> >
> > Ken
> >
> > On Fri, Jul 06, 2007 at 07:10:59AM -0700, Jeff Stark wrote:
> > > I just tried very similar to what you have Kevin, still no luck.
> > >
> > > [EMAIL PROTECTED] obj]# /opt/rt3/bin/rt list -i ('CF.{Severity Level}
> > > =
>
> > > "Sev 3"')
> > > -bash: syntax error near unexpected token `('
> > >
> > >
> > > - Stark
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED] On Behalf Of
> > > Kevin
>
> > > Falcone
> > > Sent: Thursday, July 05, 2007 3:59 PM
> > > To: RT Users
> > > Subject: Re: [rt-users] RT CLI and Custom Fields
> > >
> > >
> > > On Jul 5, 2007, at 3:16 PM, Jeff Stark wrote:
> > >
> > > > has anyone successfully used the CLI to query RT Custom fields?
> > > > I
>
> > > > found a few posts, but with no responses.
> > > >
> > > > Here is an example:
> > > >
> > > > /opt/rt3/bin/rt list -i ('CF.{Severity Level}' = 'Sev 3'")
> > >
> > > This works fine for me
> > >
> > > ./bin/rt ls -i 'CF.{foo} = "bar"'
> > >
> > > -kevin
> > > _______________________________________________
> > > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> > >
> > > Community help: http://wiki.bestpractical.com Commercial support:
> > > [EMAIL PROTECTED]
> > >
> > >
> > > Discover RT's hidden secrets with RT Essentials from O'Reilly
Media.
>
> > > Buy a copy at http://rtbook.bestpractical.com
> > >
> > > _______________________________________________
> > > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> > >
> > > Community help: http://wiki.bestpractical.com Commercial support:
> > > [EMAIL PROTECTED]
> > >
> > >
> > > Discover RT's hidden secrets with RT Essentials from O'Reilly
Media.
> > > Buy a copy at http://rtbook.bestpractical.com
> > >
> >
> >
>
>
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
