[Rt-devel] SearchBuilder help needed

[Agnislav Onufrijchuk]

Hi all.

Can you please help me with constructing query using native RT methods?

I need to override Email Gateway method with adding additional check. I 
use following sql-query:

select
   CC.customer_id from CustomerContacts CC
LEFT JOIN
   ContactEmails CE ON (CC.id = CE.Contact_Id)
WHERE
   CE.Email = "some at email.com";

What object should I use as base - RT::CustomerContacts or 
RT::ContactEmails? And what sequence of Join and Limit methods should I 
use?

I'm new in DBIx::SearchBuilder and need a bit help to start :)

-- 
Agnislav Onufrijchuk
PortaOne, Inc., RT Developer
Tel: +1-866-SIP VOIP (+1 866 747 8647) ext. 7670

   Meet us at Internet Telephony East
   February 2-4, 2009 - Booth 826
   Miami Beach Convention Center