Back to all

$MAX(Datetime) on Tasks

Hi,

I am trying to use the API to find the next task and the most recent task dates and description for each client and write them back on to a UDF. The database has 30,000 records in it. Is there a way I can do this other than making 30,000 API requests to find the top 1 task for each ab entry key to find the last completed task, and then doing another 30,000 API request to find the top 1 uncompleted task?

Thanks
David