CiviCRM Community Forums (archive)

Hi I am doing a custom search. We need a search to show us the number of activities per an activity type. My SQL works great, but I have an ORDER by in my SQL and I cannot figure out to inject that into the php code. Everything else is working fine, but the example in the Civicrm document does not talk about group by's.