[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