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 supp...@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
>
