Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Trivial
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.3.3
-
Fix Version/s: Unscheduled
-
Component/s: CiviCRM Search
-
Labels:None
-
Documentation Required?:None
-
Funding Source:Needs Funding
Description
If you use the built in custom searches like "Contributions made in year X but not in year Y" there is a list of contacts that is returned. If you select contacts, all or partial set, from the result and choose the action "Add to group" you get a SQL query error. The SQL query is looking for a column name contact_a.id when the only column in the result is contact.id. If you manually adjust the SQL you can get the query to execute and function properly adding/removing people to the group. The field selection on the SQL that is programmatically generated is just pulling in the wrong column names.