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;
}
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:
[snip]
Any help will be appreciated,
Regards;
Roy
Thanks for the code, I was just trying to do the same thing. I haven’t
figured out how to do that final tweak yet, either.
But anyway, here is a patch that completes this mod, bringing the search
into the UI and all.
I’m thinking CommentBy/CorrespondBy should/would be separate criteria,
though they could be built into the same limit function.
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 rfh@pipex.net 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;
}