[jifty-devel] SQL queries ?

[Jesse Vincent]

On Mar 16, 2007, at 10:58 PM, mraptor wrote:

> What about 3-4 tables JOIN ? How do I do this ...

Some random sample code that might help:

     my $histories = $self->join(
         alias1  => 'main',
         column1 => 'id',
         table2  => 'task_histories',
         column2 => 'transaction_id'
     );
     my $tasks_alias = $self->join(
         alias1  => 'main',
         column1 => 'task_id',
         table2  => 'tasks',
         column2 => 'id'
     $self->limit(
         alias            => $histories,
         column           => 'field',
         case_sensitive   => 1,
         operator         => '!=',
         entry_aggregator => 'AND',
         value            => $_
         )
         for (
         qw(completed_at depended_on_by_summaries depended_on_by_ids  
depended_on_by_count depends_on_summaries depends_on_count  
depends_on_ids)
         );


-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
Url : http://lists.bestpractical.com/pipermail/jifty-devel/attachments/20070320/7b5eff8c/PGP.pgp