The following View shows Contacts that have Tasks attached to them.
Leave this blank to use the default fields.
The following clause limits the list of Contacts to those with Tasks attached. Contacts without any Tasks attached will drop out of the View:
EXISTS (SELECT 1 FROM dp_Tasks T WHERE T.Completed = 0 AND T._Record_ID = Contacts.Contact_ID AND T._Table_Name = 'Contacts' )
To use the same technique on Pages other than Contacts, replace the highlighted clause with the Table name:
EXISTS (SELECT 1 FROM dp_Tasks T WHERE T.Completed = 0 AND T._Record_ID = Contacts.Contact_ID AND T._Table_Name = 'Contacts' )
To only show Tasks assigned to the logged in user, alter the View Clause by adding the highlighted clause:
EXISTS (SELECT 1 FROM dp_Tasks T
WHERE T.Completed = 0
AND T._Record_ID = Contacts.Contact_ID
AND T._Table_Name = 'Contacts'
AND T.Assigned_User_ID = dp_UserID )