Forums
$MAX(Datetime) on Tasks
last year by David Papworth
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
