Hi all,
I've created a new Meetings dashlet that is not too different than the original -- but what I'd like is to have it only display meetings from certain contacts.

Basically, I have a custom field(a checkbox) in Contacts, and I only want meetings displayed if the contact in question has the box checked. It seems to me that the relationship (meetings_contacts) already exists, but I don't know where/how to use that relationship to add an extra filter to the dashlet.

(I'm not above modifying the sql query directly (which I've already done for a number of other dashlets), but I only know where to modify the 'where' clause, and don't know how to add in the additional JOIN to the query.)

Thanks --
Eileen