CiviCRM Community Forums (archive)

I'm re-writing something that previously used crm_get_activity_history but there doesn't seem to be any equivalent in v2. Any chance we could add something? There is an API function civicrm_activities_get_contact but it doesn't take any parameters except the contact id, it doesn't return all the activity fields (eg missing activity_date_time), and doesn't allow for sort order.

I have resorted to writing an SQL query directly but I wonder (a) is there another way? (b) can we add something supported to the API codebase?

Here is the query I've used, based on getContactActivity in CRM/Activity/BAO/Activity.php:
  $query ="SELECT * FROM civicrm_activity activity, civicrm_activity_target target
             WHERE activity.id = target.activity_id
             AND target.target_contact_id = $contactId
             AND activity.activity_type_id = $activityTypeId
             ORDER BY activity_date_time DESC";
  $dao = CRM_Core_DAO::executeQuery( $query, CRM_Core_DAO::$_nullArray );