[rt-users] RT or SearchBuilder bug?

[Todd Chapman]

Jesse,

But this isn't a matter of permissions checking. If iterating over the query
results skips disabled rows then Count should be able to eliminate them too.
Right?

-Todd

On Tue, Sep 16, 2008 at 12:56 PM, Jesse Vincent <jesse at bestpractical.com>wrote:

>
> On Sep 16, 2008, at 11:41 AM, Todd Chapman wrote:
>
>  $QueueObj->TicketCustomFields->Count  includes disabled fields in it's
>> Count. Should that be?
>>
>> If I do it this way:
>>
>> my $cfs = $QueueObj->TicketCustomFields;
>> $cfs->ItemsArrayRef;
>> my $count = $cfsw->Count;
>>
>> the the correct number is returned.
>>
>> SB version 1.48, RT version 3.6.3
>>
>> Is my technique wrong or is there a bug?
>>
>
> This is the same issue you see when doing a ticket search in RT. "Count"
> does a raw COUNT() in the database if you haven't previously actually loaded
> all the data from the database. Otherwise, it counts the rows on the perl
> side.
>
> ItemsArrayRef fully instantiates the list.
>
> You could get the same behaviour by calling:
>
> $cfs->First; $cfs->Count;
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080916/e3a331e1/attachment.htm>