[rt-users] RT CLI CF query operators

support at pureview.com support at pureview.com
Fri Aug 28 21:05:58 EDT 2015


Loos,

Thank you for the help but after I rectified the typo. I still getting a
different errors.

rt list -i 'CF.{Modtrak} > 0 AND Created >= "2015-07-01" AND Created <=
"2015-07-31"'
rt: Invalid query: 'Wrong query, expecting a AGGREGATOR in 'CF.{Modtrak} >
0 AND Created >='"2015-07-01'>" AND Created <='"<--here2015-07-31'"' at
/opt/rt4/sbin/../lib/RT/SQL.pm line 130.

Stack:
  [/opt/rt4/sbin/../lib/RT/SQL.pm:130]
  [/opt/rt4/sbin/../lib/RT/Tickets.pm:2979]
  [/opt/rt4/sbin/../lib/RT/Tickets.pm:2997]
  [/opt/rt4/share/html/REST/1.0/search/ticket:89]
  [/opt/rt4/share/html/REST/1.0/autohandler:54]
  [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:680]
  [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:368]
  [/opt/rt4/share/html/autohandler:53]
'.
Invalid query: 'Wrong query, expecting a AGGREGATOR in 'CF.{Modtrak} > 0
AND Created >='"2015-07-01'>" AND Created <='"<--here2015-07-31'"' at
/opt/rt4/sbin/../lib/RT/SQL.pm line 130.

Stack:
  [/opt/rt4/sbin/../lib/RT/SQL.pm:130]
  [/opt/rt4/sbin/../lib/RT/Tickets.pm:2979]
  [/opt/rt4/sbin/../lib/RT/Tickets.pm:2997]
  [/opt/rt4/share/html/REST/1.0/search/ticket:89]
  [/opt/rt4/share/html/REST/1.0/autohandler:54]
  [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:680]
  [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:368]
  [/opt/rt4/share/html/autohandler:53]

> Am 26.08.2015 um 21:25 schrieb support at pureview.com:
>> rt list -i "'CF.{Modtrak}' > 0 AND Created >= '2015-07-01' AND Create <=
>> '2015-07-31'"
>> rt: Invalid query: 'Unknown field 'Create' in ''CF.{Modtrak}' > 0 AND
>> Created >= '2015-07-01' AND Create <= '2015-07-31'' at
>> /opt/rt4/sbin/../lib/RT/Tickets.pm line 2943.
>
> The error message says all.
> It's just a typo, the ticket field is called Created and not Create.
>
> Chris
>





More information about the rt-users mailing list