Author Topic: Organizing users based on creation date (Read 1077 times)

perka · November 09, 2007, 06:31:12 am

Hi, I would like to select groups of individuals based on their creation date. Does someone have the SQL to do this or is there a way to do it using search?

If only by SQL the output format would have to be in a form which could be exported and then imported to update the corresponding entries.

Dave Greenberg · November 13, 2007, 02:29:12 pm

I'm assuming that when you say "users", you're referring to CiviCRM contact records (rather than Drupal or Joomla user records)...

You can use the Change Log panel in Advanced Search to find contacts who've been CREATED or MODIFIED within a date range (and then export your results).

Otherwise, I think you'll need to write the query for this (and then hopefully post it back to the Useful Queries section on the wiki - http://wiki.civicrm.org/confluence/display/CRMDOC/Useful+SQL+queries)

The creation date for contact will be the civicrm_log record with the lowest ID (primary key) for any given contact ID (which is stored in civicrm_log.entity_id WHERE civicrm_log.entity_table = 'civicrm_contact').

CiviCRM Community Forums (archive)

News:

Author Topic: Organizing users based on creation date (Read 1077 times)

perka

Organizing users based on creation date

Dave Greenberg

Re: Organizing users based on creation date