CiviCRM Community Forums (archive)

Hi,

I was doing an advanced search today for contacts added in a certain date range it seemed to pick up contacts that were modified in the date range as well as added?

I ran the same search but selecting 'modified' instead of 'added' and I got the same results, can anyone confirm this behaviour?

If so, I'll raise an issue.

Cheers,

Dave

Was this issue resolved?  We've got an installation (Drupal/ Civi 3.4.8 ) causing the same problem for our client.  They're trying to pull all contacts added in a date range, and the query is including contacts whose records have been changed during that time too.  We took a look at the code identified above and we see this. 

function changeLog ( &$values )
    {
        list( $name, $op, $value, $grouping, $wildcard ) = $values;
       
        $targetName = $this->getWhereValues( 'changed_by', $grouping );
        if ( ! $targetName ) {
            return;
        }

        $name = trim( $targetName[2] );
        $name = strtolower( CRM_Core_DAO::escapeString( $name ) );
        $name = $targetName[4] ? "%$name%" : $name;
        $this->_where[$grouping][] = "contact_b_log.sort_name LIKE '%$name%'";
        $this->_tables['civicrm_log'] = $this->_whereTables['civicrm_log'] = 1;
        $this->_qill[$grouping][] = ts('Changed by') . ": $name";
    }

Any suggestions?
Thanks,
-Mary Kay

I'm having a similar problem with the date range search box in advanced search. 

When I select "Added" and include a date range in the Change Log area of the advanced search, the results only return contacts created after the first of date range, but seems to ignore the second. 

Further, I replicated the problem in the Joomla-CiviCRM4.1 demo site.  I've attached screencap's of both.   

Would be great if you can get your developer / consultant to take a look at the query code and see if they can spot the error. If you do so, please submit a patch with the issue

lobo

Thanks for the replies Lobo, I appreciate it.

I'll try the patch, though we've got way more contacts than that... and no developer .

Thanks!
Josh

I tried using Search >Custom Searches >Contacts By Date Added, and if I narrow it down by a specific group the search results will show the correct results.

However, when I try to export these contacts or add them to a group, it will export ALL contacts (disregarding the group setting).

E.g. The search results will show 1600 contacts (all contacts by date added within a range AND in a group), but the export will export 2500 contacts (all contacts by date added within a range).