Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Hot answers tagged

15

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.


11

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". Edit: 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 /...


10

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).


10

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. Thanks Pradeep


9

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.


9

You should use the custom search "Include / Exclude Search" that does exactly what you want civicrm/contact/search/custom?csid=4&reset=1 on my install, likely the same custom search id on your install


7

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 ...


7

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 ...


7

Sure thing. Just upgrade to version 4.4 or later and it will be there :)


7

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)...


7

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 ...


7

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.


6

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 ...


6

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-...


6

In civicrm.settings.php, you can enable: define('CIVICRM_DEBUG_LOG_QUERY', 1); 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 ...


6

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 ...


6

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 (...


6

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 ...


5

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.


5

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 ...


5

Since they're using Drupal, you may want to check out Forena Reports. There will be a session on using Forena Reports with CiviCRM at CiviCon Denver in three weeks.


5

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 ...


5

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: SELECT c.ID AS InternalContactID FROM c9.civicrm_contact c WHERE c.contact_type = 'Individual' AND NOT EXISTS ( SELECT 1 ...


5

CiviCRM search pages don't accept filters from the url, but Drupal Views can. If you are using Drupal as your CMS, try that.


5

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'


5

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 ...


5

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 ...


5

Navigate to Administer - Customize data and screens - Display preferences and select the Custom field section listed under Contact search. After that you should see the Custom field accordion in the Advanced search


5

Not sure about "Search and Replace", but you can do the above from the "Update multiple contacts" task on the contacts returned on Advanced Search. All you need to do is add your field(I think it's IM Screen name in your case) to a profile (Created from Administer -> Customize Data and Screens -> Profiles). Use Search -> Advanced Search to filter and get ...


4

The easiest is probably to install the extension I just created, thanks to Nicholai magic sql suggestion: https://civicrm.org/extensions/lonesome-find-contacts-without-group Otherwise, the clunkier way I found is to use the custom search exclude/include and select every group in the exclude fields. It works, with two issues still - it does include ...


Only top voted, non community-wiki answers of a minimum length are eligible