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 _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com