[rt-users] Method LimitCustomFields

[Ruslan Zakirov]

I couldn't give you full solution, but I remeber that there were fixe
for queries like "CF.XXX has value" in the latest RT3.4 releases.

May be you should try:
$tickets->LimitCustomField( CUSTOMFIELD => 'Resubmission' ,
                               OPERATOR => 'IS NOT',
                               VALUE => 'NULL'  );

Check SQL log.

On 11/17/05, Peter Reich <reich at adesso.de> wrote:
>
> Hello,
>
> i have some difficulties with LimitCustomFields(). I tried to write a perl
> script that looks for tickets, which have a custom field that is not empty.
> Here's the code:
>
> ---snip---
>   my $tickets = new RT::Tickets($RT::SystemUser);
>   $tickets->LimitStatus(VALUE => 'stalled');
>   $tickets->LimitQueue(VALUE => $queue->Id);
>   $tickets->LimitCustomField( CUSTOMFIELD => 'Resubmission' ,
>                               OPERATOR => '!=',
>                               VALUE => '' );
> ---snap---
>
> As a result, i got all stalled tickets in the queue, no matter if the CF is
> empty or not.
>
> I could use some help, please.
>
> Peter
> --
> a d e s s o  AG       http://www.adesso.de|  Fon   : +49 231 930 - 9247
> Stockholmer Allee 24                      |  Fax   : +49 231 930 - 9331
> 44269 Dortmund                            |  eMail: reich at adesso.de
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>
> Download a free sample chapter of RT Essentials from O'Reilly Media at http://rtbook.bestpractical.com
>
> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
> San Francisco - Find out more at http://bestpractical.com/services/training.html
>


--
Best regards, Ruslan.