I am looking to create a list of filters for my employees to use on their own to track their progress or work.
I would like to create a GM Filter to show all pending callbacks for that employee. Currently this is what I have below.
WHERE c1.U_KEY4 = 'BM' AND c2.CALLBACKON <= GETDATE ()
Currently I am trying to call every contact record that has a KEY4 value of the employees initials (in this case BM) and if that has a pending callback (c2.callbackon). However it is not returning the correct value reflected in the activity list for all open calls.