Get interests for contact
Some tooltip text!
• 1 minute to read
• 1 minute to read
To get a list of interests checked off for a contact:
SELECT * FROM contactinterest WHERE contact_id = 123
To get the names of the checked-off interests for a contact:
SELECT * FROM contactinterest, contint
WHERE contactinterest.contact_id = 123
AND contactinterest.cinterest_idx = contint.contint_id
| contactinterest_id | contact_id | cinterest_idx | > | ContInt_id | name | rank | tooltip | deleted |
|---|---|---|---|---|---|---|---|---|
| 53459 | 123 | 594 | 594 | SAP | 142 | 0 | ||
| 53640 | 123 | 1569 | 1569 | Developers | 195 | This company has... | 0 |