For CiviCRM 4.6+ go to Administer menu > Customize Data and Screens > Date Preferences. From there, change the Start Offset of SearchDate.
For CiviCRM versions before 4.6, this is part of the Advanced Date settings linked from Administer > Localization > Date Format.
There is a non-code fix for this:
You could make a profile with the fields you want to display.
And then you search using Advanced Search, and you could select that profile in the "display result as".
As pointed out by Philipp Michael in the comments below, you could also choose a certain profile as the default one, in the admin settings ( at /...
CiviCRM Contact Distance Search requires views module and since your system is missing required modules you won't be able to enable it. Once you install Views module you will need to configure it with civicrm so that drupal can access data from civicrm.
You can do it in two steps:
Search for all contacts, and put these in a tag (or group).
Do a second search, for all contacts WITH a donation. And then remove these from you tag (or group) using action Untag Contact (or Remove contact from group).
The best solution would be to use search builder like so:
However as Laryn noted there was a bug preventing this from working. I've filed an issue for this, and worked up a fix that hopefully will make it into the next release.
Yes, there is no such field in contribution table that holds when a contribution record was actually created. However an activity is created when a contribution is recorded with status completed. If contribution is created with pending status and updated later after day or 2 then it is very difficult to track via Activity.
I have an extension that uses ...
The quick answer is "no."
For some back-story, that feature was contributed (circa 4.3) by a volunteer from the community who was enough of a coder to be able to get it to work, but not really a CiviCRM architect. His implementation was done by hard-coding that list of fields directly into the template.
The result of his good-faith effort is that:
We have ...
Adding the Summary Fields extension is the way to go. Use Advanced Search to find contacts with zero lifetime donations to create a smart group or list of people who have never given. Subsequent donations from those contacts will automatically remove them from the smart group.
If you are interested in finding people who have given at some point, but not ...
I don't think it helps with passing the filters in the URL, but you can save the search as a Smart Group and then use the link to the contact list for that group. I think you can strip of the qfkey portion of the URL in this case. Something like this (although this smart group on the demo site will be deleted shortly, the URL structure is what I want to show)...
I found it quite hard to replace the customization done with hook_civicrm_contactListQuery (CiviCRM <= 4.4) with the new hook_civicrm_apiWrappers (CiviCRM >= 4.5).
So I am sharing my results here.
My goal is to have a way to search quickly either by contact name, or by a custom field that stores a member identifier (different from internal identifier ...
Memberships have three primary dates, the join date (member since), start date and end date. The join date is the date the contact first signed up for a membership with your organisation. Unless it is altered manually it will never change from that first value. The start date is the date the current continuous period of membership began. The end date is the ...
Yes, using Advanced Search (Search menu » Advanced Search). Set up the search the same way you would in order to find the children. Additionally, set the "Display Results As" at the top to "Related Contacts", and select the "Parent of" relationship.
As Coleman said, no, for adding fields, but we removed certain fields for our setup with jQuery so our users wouldn't mis-click.
EDIT: I went back to look at the code, and I remembered that we tried removing the fields with simple jQuery .hide() or .remove(), but realized that the standard classes we were trying to use were used elsewhere so it did more ...
We have had great success using Jasper Reporting with CiviCRM.
It does require knowledge of the underlying CiviCRM database, and writing SQL against it, but the formatting capabilities are powerful and fairly easy to use.
Once a report is created, it can easily be added to the CiviCRM menu.
More details here: https://civicrm.org/blogs/lcarter/civicrm-...
I've done this sort of thing by using the Include / Exclude custom search (Search => Custom Searches => Include/Exclude Contacts in a Group/Tag)
Include a group that has all the contacts that you're looking at. In your case you may need to create a smart group that has all the people in the country. Then in the exclude list all the groups that they should ...
In civicrm.settings.php, you can enable:
Then run the "Advanced Search" and look at the output in files/civicrm/ConfigAndLog/CiviCRM*log*. This will output for several queries; to avoid accumulation of junk data, you should probably disable the CIVICRM_DEBUG_LOG_QUERY after running the query.
There's some more ...
when you click in the QuickSearch (white search box very top left) you should see a drop down of 'what do i want to search for' and External ID is in there. So you can select that and then just enter the Ext ID that you are looking for.
You can also add the Ext ID field to a Profile which you have set up for Search or Listing if you want this more public eg ...
Use the Advanced Search (in the Search menu) and check the box labeled 'Search in Trash (deleted contacts)'. It is a small check box in the Search Settings part of the Basic Criteria section. Whatever search you do will look in the 'Trash' rather than among active contacts.
Once those search results come up, you can select your desired contacts and, from ...
The 'Include/Exclude' search is very handy for situations like this:
create a group of all contacts of interest
create a group of those who DO meet some criteria
use include/exclude to include group 1 and exclude group 2 to
produce those who DON'T meet the criteria
So in your case:
create a group of all people
create a group who do have a relationship (...
CiviCRM does not store information of who accessed what, for better and worse.
If you have the advanced logging turned on, you can see changes users made. The CMS may have a record of when they last accessed the site, if that's helpful. There's also an extension that adds a permission to restrict exports. While any of those might be helpful, none are ...
This is a workaround, but it will get what you need with minimal effort. Use the Import Contacts feature. On the first screen, choose Update. Instead of a CSV file as the source, use the SQL query option like so:
c.ID AS InternalContactID
c.contact_type = 'Individual'
AND NOT EXISTS (
SELECT 1 ...
Another alternative is writing a custom report. It's not all that difficult, though it is writing PHP code. Even if you need to hire out for it, you'll have exactly what you need.
The details on how to create a report template extension are here: http://wiki.civicrm.org/confluence/display/CRMDOC/Create+a+Report-Template+Extension
Most likely, you'll just ...
You can save the result of an advanced Search as a Smart Group. If you want a link to that smart group in the menu, you can add a menu option for it with Administer > Customize Data and Screens > Navigation Menu.
You could tag the Employers, then search for them, but set 'display results as' (top right of Adv Search pre-4.6, bottom of first section in 4.6) to 'show as related contacts' which you would set to 'employees of'