Saturday, January 9, 2010

Get vtigerCRM Contact List

The following query gets vtigerCRM Contact List

SELECT t1.contact_no
, t1.firstname
, t1.lastname
, t1.title
, t4.accountname
, t1.email
, t1.phone
, t3.user_name
FROM vtiger_contactdetails t1
INNER JOIN vtiger_crmentity t2 ON t1.contactid = t2.crmid AND t2.setype = 'Contacts'
INNER JOIN vtiger_users t3 ON t2.smownerid = t3.id
LEFT JOIN vtiger_account t4 ON t1.accountid = t4.accountid

No comments:

Post a Comment

Oracle Query