+Returns alias for transactions table with applied join condition.
+Always return the same alias, so if you want to build some complex
+or recursive joining then you have to create new alias youself.
+
+=cut
+
+sub TransactionAlias {
+ my $self = shift;
+ return $self->{'_sql_transaction_alias'}
+ if $self->{'_sql_transaction_alias'};
+
+ my $res = $self->NewAlias('Transactions');
+ $self->Limit(
+ ENTRYAGGREGATOR => 'AND',
+ FIELD => 'TransactionId',
+ VALUE => $res . '.id',
+ QUOTEVALUE => 0,
+ );
+ return $self->{'_sql_transaction_alias'} = $res;