CiviCRM Community Forums (archive)

Hi guys,

When I do a search on "Advanced Search" with the change logs set to "Added" (by is blank) and the two and from dates being a year from now, even if I only do today's date the server times out (504 gateway error). Any ideas? Ideally I need these to be grouped by a specific custom data field.

Does anyone know where the change logs are stored in mysql? Hopefully I can honour this request manually!

Thanks,

Updated profile information, I didn't have access to it back when I created the profile. Also, not sure where the demo site is, and as I'm using custom data wouldn't I need to add the custom data to the demo site for it to work?

So I've managed, somewhat, to figure out the issue.

I was told about the custom search "Date added to CiviCRM" which accepts date ranges: so I created a group of all the relevant users and applied that. This was to get the total count, but not grouped by the custom data.

The problem is that every time we want to do this search we (presumably?) need to create a new group? Or make sure that new records are added to this group?

The MySQL command took me most of the way there, but it was only for those modified within a certain time period, not for those added within that time period. I've included it below in case it's of service.

SELECT count(distinct(civicrm_value_contact_reference_9.entity_id)) from civicrm_value_contact_reference_9 INNER JOIN civicrm_log ON civicrm_value_contact_reference_9.entity_id=civicrm_log.entity_id where how_do_you_want_to_help LIKE '%donate%' AND civicrm_log.modified_date > "2012-07-01" AND modified_date < "2013-08-01";

If anyone could help me over the finish line here that'd be great!