CiviCRM Community Forums (archive)

Hi all,

I'm trying to customise the built-in Contact Summary report to return a "thumbnail" glance of recently added contacts, to be used both as a dashboard widget and as an emailed report.

My challenge is to return the 15 most recent added contacts. (I would love to be able to say "15 most recent in the past day" but that's beyond my abilities at the moment.)

As of now, I've managed to customise a report based on Contact Summary to enable Contact ID as an Order By and require it, so the report is already returning results ordered descending by contact ID.

Now, I just need to know how to add in a limit of 15 to the SQL, but I can't find out how. I can't even sort out how to debug the SQL.

I'm using the exact code from the Summary.php form - the forum will not allow me to enter in the code for review, saying I'm not allowed to post links.

Assistance?

Eileen - thank you. That worked!