Field List

Leave this blank to use the default fields.

View Clause

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' )

Other Pages

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' )

My Assigned Tasks

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 )

Techniques

• EXISTS SQL Function
• dp_UserID

Other Resources

• Task system tables