CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Can you sort contact search by creation date?
Pages: [1]

Author Topic: Can you sort contact search by creation date?  (Read 1300 times)

mcsmom

  • I post frequently
  • ***
  • Posts: 266
  • Karma: 23
    • Official Joomla! Book
  • CiviCRM version: 4 and 3.4
  • CMS version: Joomla!
Can you sort contact search by creation date?
September 15, 2007, 04:28:39 am
Contact search (in the jooma! backend) is now sorted alphabetically, but my user would like to be able to sort by creation date and just export the new users. Is there a way to do this?

I know I can sort of do this in the front end using the profile search and exposing contactid, but I can't export from there.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Can you sort contact search by creation date?
September 15, 2007, 09:21:28 am
One possible approach is to kuse Advanced Search - Change Log panel to search on records "modified" w/in a time period. This will give NEW and CHANGED records but might be "close enough" (esp since exports include the internal contact ID).

I "thought" you could also do this by creating a Profile used for "search results" and including "Internal Contact ID" as a profile field. However, I tried this and contact ID column is empty in the results. I've filed a bug report for 2.1 for this - but that won't help you know :-(
Protect your investment in CiviCRM by  becoming a Member!

mcsmom

  • I post frequently
  • ***
  • Posts: 266
  • Karma: 23
    • Official Joomla! Book
  • CiviCRM version: 4 and 3.4
  • CMS version: Joomla!
Re: Can you sort contact search by creation date?
September 15, 2007, 10:52:28 am
Actually it doesn't give you new, just changed. There is no changelog entry when a record is created. :( Sounds like a feature request to me. :)

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Can you sort contact search by creation date?
September 15, 2007, 11:46:34 am

The first entry is the date for when the record was "created", i.e. the one with the lowest id

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

mcsmom

  • I post frequently
  • ***
  • Posts: 266
  • Karma: 23
    • Official Joomla! Book
  • CiviCRM version: 4 and 3.4
  • CMS version: Joomla!
Re: Can you sort contact search by creation date?
September 15, 2007, 12:21:34 pm
There is no entry. It is blank for everyone. Maybe because they are coming in from a stand alone?? Puzzling.

The people I imported using civicrm do have creation dates.
« Last Edit: September 15, 2007, 12:23:34 pm by mcsmom »
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Can you sort contact search by creation date?

This forum was archived on 2017-11-26.