Custom Query

[dvelguru]

Maybe you can add a custom method to Sugar 5.5 that will allow developers to create custom queries.

Such as a query to retrieve leads -> email addresses which can be accomplished by connecting to DB externally using:

 SELECT * FROM leads JOIN email_addr_bean_rel ON leads.id = email_addr_bean_rel.bean_id JOIN email_addresses ON email_addresses.id = email_addr_bean_rel.email_address_id WHERE email_addresses.email_address = 'boogie@hofstra.edu' 
  

So to keep users in Sugar, which is something I would love to do, creating a custom query will be golden. There are too many limitations to get_entry_list query => ...

I've tried multiple times to get access to leads.email1 however, it is a no go with method get_entry_list. Please update me if I am wrong.

Thanx

[eggsurplus]

If you want to do something like that inside of Sugar check out ZuckerReports.