[rt-users] Using ENTRYAGGREGATOR

Roy El-Hames rfh at vialtus.com
Wed Oct 22 04:53:53 EDT 2008


Hi;

(rt-3.6.3/apache2/mysql5/DBix 1.49)

We have our table within RT called Circuits and using factory I created 
Circuit.pm and Circuits.pm then added Circuits_Overlay.pm for the 
various functions.
Selecting with $self->Limit( FIELD => 'x', VALUE => "$y" ); works fine 
however I am not having any luck selecting when using ENTRYAGGREGATOR => 
'OR'
example: (from a function in my Circuits_Overlay.pm)
    $self->Limit (
                FIELD => 'DistributionRouter',
               VALUE => $icon,
               OPERATOR => 'LIKE',
                ENTRYAGGREGATOR => 'OR',
        );
        $self->Limit (
                FIELD => 'AEndPop',
                VALUE => $icon,
                OPERATOR => 'LIKE',
                 ENTRYAGGREGATOR => 'OR',
        );
        my $records = $self->RT::SearchBuilder::BuildSelectQuery();
        returning either $records or $self gives nothing  ..Tailing 
rt.log i see $self is referenced correctly , but the sql statement 
defaulting to AND
       from rt.log:
       'subclauses' => {
                                   'generic_restrictions' => 
'(main.DistributionRouter LIKE \'%xyz%\') AND (main.AEndPop LIKE \'%xyz%\')'
       },

       How can i force the condition to 'OR', I looked through all the 
modules within RT and I could n't figure out how to define a default 
ENTRYAGGREGATOR ;
       #By the way commenting out the second limit statement  I get 
results back so the function is correct with the exception of the OR clause.
Any help would be appreciated;

Regards;
Roy




More information about the rt-users mailing list