You need something like:
$self->_OpenParen;
$self->SUPER::Limit(
ALIAS => $self->{_sql_transalias},
FIELD => 'Type',
VALUE => 'Comment',
ENTRYAGGREGATOR => 'AND'
);
$self->SUPER::Limit(
ALIAS => $self->{_sql_transalias},
FIELD => 'Type',
VALUE => 'Correspond',
ENTRYAGGREGATOR => 'OR'
);
$self->_CloseParen;
On 9/12/06, Roy El-Hames <[EMAIL PROTECTED]> wrote:
Hi there;
(rt-3.6.1 , mysql, apache2 mod_perl)
I have a search criteria where it looks for any tickets updated by a
particular user, I got it working for all kind of transactions and I
wonder if anyone can help me put the final tweak to get it to return
ticket where the User just Commented/Corresponded ..I have the following
function in Tickets_Overlay.pm:
sub _TransUser {
my ($self, $field, $op, $value, @rest ) = @_;
$RT::Logger->error("the field = $field and op is $op and value is
$value and rest is @rest");
$self->{_sql_transalias} = $self->NewAlias('Transactions')
unless defined $self->{_sql_transalias};
$self->{_sql_Usersalias} = $self->NewAlias('Users')
unless defined $self->{_sql_Usersalias};
$self->_OpenParen;
#Search for the right field
$self->_SQLLimit(
ALIAS => $self->{_sql_Usersalias},
FIELD => 'Name', ### for the Updated by in particular
may change later
OPERATOR => $op,
VALUE => $value,
CASESENSITIVE => 0,
@rest
);
$self->_SQLJoin(
ALIAS1 => $self->{_sql_Usersalias},
FIELD1 => 'Id',
ALIAS2 => $self->{_sql_transalias},
FIELD2 => 'Creator'
);
$self->_SQLJoin(
ALIAS1 => 'main',
FIELD1 => 'Id',
ALIAS2 => $self->{_sql_transalias},
FIELD2 => 'ObjectId'
);
$self->SUPER::Limit(
ALIAS => $self->{_sql_transalias},
FIELD => 'ObjectType',
VALUE => 'RT::Ticket',
ENTRYAGGREGATOR => 'AND'
);
$self->_CloseParen;
}
Any help will 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
--
Best regards, Ruslan.
_______________________________________________
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
