Development issueshttps://lab.civicrm.org/groups/dev/-/issues2022-04-22T15:51:44Zhttps://lab.civicrm.org/dev/core/-/issues/3237Search Kit: "Bypass Permissions" doesn't apply to in-place edit2022-04-22T15:51:44ZJonGoldSearch Kit: "Bypass Permissions" doesn't apply to in-place editAs the title says - "Bypass Permissions" doesn't allow for in-place editing.As the title says - "Bypass Permissions" doesn't allow for in-place editing.https://lab.civicrm.org/dev/core/-/issues/3236No pagination on Contribution Detail report2022-04-22T15:51:42ZJonGoldNo pagination on Contribution Detail reportThis seems to be a side effect of [this commit](https://github.com/civicrm/civicrm-core/commit/e6bab5eae9e7293dff9ecb9852f85e6aa01dad7f#diff-585f40aa84b2e15ef6b0768dd64bfd0c) fixing core#170. I'm not 100% sure why this isn't happening o...This seems to be a side effect of [this commit](https://github.com/civicrm/civicrm-core/commit/e6bab5eae9e7293dff9ecb9852f85e6aa01dad7f#diff-585f40aa84b2e15ef6b0768dd64bfd0c) fixing core#170. I'm not 100% sure why this isn't happening on the sandbox, but I'm reasonably certain it's because servers without Full Group By use a different code path.
There were 2.5 bugs that needed to be fixed:
* The first temp table for this report sets a limit of 50 rows - so the second time through `buildQuery()`, the SQL statement `SELECT * FROM civireport_contribution_detail_temp3 $this->_orderBy` will never return more than 50, so the pager won't be set.
* `setPager()` assumes that a) the last SQL statement executed includes `SQL_CALC_FOUND_ROWS`; b) that `$this->limit` is set.
Finally, I found a call to `setPager()` in a place where it would never be correct (on a temp table that's not the "final" temp table) so I removed it.JonGoldJonGoldhttps://lab.civicrm.org/dev/core/-/issues/3235WMF Search Discovery2022-04-22T15:51:38ZcolemanwWMF Search DiscoveryThe Core Team has been commissioned to improve Search & Reporting in CiviCRM.
* [Statement of Work](https://docs.google.com/document/d/1dG-aRyRs-pTHpd0XMoqsIhTRDNLQqFkUSzrZXLOb4AQ/edit?usp=sharing)
* [Analysis by Eileen](https://docs.g...The Core Team has been commissioned to improve Search & Reporting in CiviCRM.
* [Statement of Work](https://docs.google.com/document/d/1dG-aRyRs-pTHpd0XMoqsIhTRDNLQqFkUSzrZXLOb4AQ/edit?usp=sharing)
* [Analysis by Eileen](https://docs.google.com/document/d/1OyEXfGHq0s8MWxCqTz5bzdA5a86O4ad3bVefpEDKXuw/edit?usp=sharing)
* [A mental health plan for search](https://lab.civicrm.org/dev/report/-/issues/37)https://lab.civicrm.org/dev/core/-/issues/3234Search Kit: Selecting one row selects all rows when embedded in a contact tab2022-04-22T15:51:36ZJonGoldSearch Kit: Selecting one row selects all rows when embedded in a contact tabSome Search Kit forms don't allow selecting individual contacts when embedded in an afform on a contact tab.
### Steps to replicate
* Create a Search Kit search matching the one in the screenshot below.
* Create a display of type "table...Some Search Kit forms don't allow selecting individual contacts when embedded in an afform on a contact tab.
### Steps to replicate
* Create a Search Kit search matching the one in the screenshot below.
* Create a display of type "table". Keep the defaults except "Enable Actions" should be checked.
* Create a new Afform with this search. Place it on a standalone page, also embed it in a contact tab.
* On a contact that has multiple employers, attempt to check the box next to one employer to use the action.
![Selection_1137](/uploads/7239af533b8b44b1c32280b9860f9fef/Selection_1137.png)
### Expected behavior
Selecting one contact should only check the one box.
### Actual behavior
Checking any box checks/unchecks all boxes - but only on the form embedded on a tab. The standalone form works normally.
### Comments
I thought that perhaps PR [#20558](https://github.com/civicrm/civicrm-core/pull/20558) was related to this - but it certainly seems like a bug if the behavior on the standalone form and the form on the contact don't match.https://lab.civicrm.org/dev/core/-/issues/3233Address location type search errors when using a search profile2022-04-22T15:51:34ZMonish DebAddress location type search errors when using a search profileSteps to replicate the issue:
1. Create a profile for use as a search view. The fields I have used - address name, phone, city, state
2. Go to Advanced Search
3. Trigger a search using that profile, and select an address location type.
...Steps to replicate the issue:
1. Create a profile for use as a search view. The fields I have used - address name, phone, city, state
2. Go to Advanced Search
3. Trigger a search using that profile, and select an address location type.
_Environment details_
```
CiviCRM ver - 5.37.alpha1 / master
CMS - Drupal 7.78
```
Error:
```
DB Error: no such field
$Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => exceptionHandler
)
[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name
FROM civicrm_contact contact_a LEFT JOIN civicrm_address ON ( contact_a.id = civicrm_address.contact_id )
LEFT JOIN civicrm_location_type `1-location_type` ON ( ( `1-address`.location_type_id = `1-location_type`.id ) )
WHERE ( civicrm_address.location_type_id IN (5) ) AND ( 1 ) AND (contact_a.is_deleted = 0) [nativecode=1054 ** Unknown column '1-address.location_type_id' in 'on clause']
[type] => DB_Error
[user_info] => SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name
FROM civicrm_contact contact_a LEFT JOIN civicrm_address ON ( contact_a.id = civicrm_address.contact_id )
LEFT JOIN civicrm_location_type `1-location_type` ON ( ( `1-address`.location_type_id = `1-location_type`.id ) )
WHERE ( civicrm_address.location_type_id IN (5) ) AND ( 1 ) AND (contact_a.is_deleted = 0) [nativecode=1054 ** Unknown column '1-address.location_type_id' in 'on clause']
[to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name
FROM civicrm_contact contact_a LEFT JOIN civicrm_address ON ( contact_a.id = civicrm_address.contact_id )
LEFT JOIN civicrm_location_type `1-location_type` ON ( ( `1-address`.location_type_id = `1-location_type`.id ) )
WHERE ( civicrm_address.location_type_id IN (5) ) AND ( 1 ) AND (contact_a.is_deleted = 0) [nativecode=1054 ** Unknown column '1-address.location_type_id' in 'on clause']"]
)
Mar 10 08:47:38 [debug] $backTrace = #0 /Users/monish/src/civicrm-core/CRM/Core/Error.php(942): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /Users/monish/src/civicrm-core/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#2 /Users/monish/src/civicrm-core/vendor/pear/db/DB.php(998): PEAR_Error->__construct("DB Error: no such field", -19, 16, (Array:2), "SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n FROM civicr...")
#3 /Users/monish/src/civicrm-core/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-19, 16, (Array:2), "SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n FROM civicr...")
#4 /Users/monish/src/civicrm-core/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -19, 16, (Array:2), "SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n FROM civicr...", "DB_Error", TRUE)
#5 /Users/monish/src/civicrm-core/vendor/pear/db/DB/common.php(1928): PEAR->__call("raiseError", (Array:7))
#6 /Users/monish/src/civicrm-core/vendor/pear/db/DB/mysqli.php(936): DB_common->raiseError(-19, NULL, NULL, "SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n FROM civicr...", "1054 ** Unknown column '1-address.location_type_id' in 'on clause'")
#7 /Users/monish/src/civicrm-core/vendor/pear/db/DB/mysqli.php(406): DB_mysqli->mysqliRaiseError()
#8 /Users/monish/src/civicrm-core/vendor/pear/db/DB/common.php(1234): DB_mysqli->simpleQuery("SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n FROM civicr...")
#9 /Users/monish/src/civicrm-core/packages/DB/DataObject.php(2696): DB_common->query("SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n FROM civicr...")
#10 /Users/monish/src/civicrm-core/packages/DB/DataObject.php(1829): DB_DataObject->_query("SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n FROM civicr...")
#11 /Users/monish/src/civicrm-core/CRM/Core/DAO.php(454): DB_DataObject->query("SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n FROM civicr...")
#12 /Users/monish/src/civicrm-core/CRM/Core/DAO.php(1565): CRM_Core_DAO->query("SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n FROM civicr...", TRUE)
#13 /Users/monish/src/civicrm-core/CRM/Contact/BAO/Query.php(4988): CRM_Core_DAO::executeQuery("SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n FROM civicr...")
#14 /Users/monish/src/civicrm-core/CRM/Contact/Selector.php(1194): CRM_Contact_BAO_Query->alphabetQuery()
#15 /Users/monish/src/civicrm-core/CRM/Utils/PagerAToZ.php(92): CRM_Contact_Selector->alphabetQuery()
#16 /Users/monish/src/civicrm-core/CRM/Utils/PagerAToZ.php(121): CRM_Utils_PagerAToZ::getDynamicCharacters(Object(CRM_Contact_Selector), FALSE)
#17 /Users/monish/src/civicrm-core/CRM/Utils/PagerAToZ.php(36): CRM_Utils_PagerAToZ::createLinks(Object(CRM_Contact_Selector), NULL, FALSE)
#18 /Users/monish/src/civicrm-core/CRM/Contact/Form/Search.php(853): CRM_Utils_PagerAToZ::getAToZBar(Object(CRM_Contact_Selector), NULL)
#19 /Users/monish/src/civicrm-core/CRM/Contact/Form/Search/Advanced.php(305): CRM_Contact_Form_Search->postProcess()
#20 /Users/monish/src/civicrm-core/CRM/Core/Form.php(526): CRM_Contact_Form_Search_Advanced->postProcess()
```
Screencast:
![before](/uploads/38cc7c6898e1b2e9e89b279a6c40ea6a/before.gif)5.37.0Monish DebMonish Debhttps://lab.civicrm.org/dev/core/-/issues/3232Soft Credit report fails when Only Full Group By is enabled2022-04-22T15:51:29ZJonGoldSoft Credit report fails when Only Full Group By is enabledThis is replicable by running the report with no changes to defaults on dmaster.
The cause is that the Soft Credit report overrides `CRM_Core_Form::postProcess()` and calls `CRM_Core_DAO::executeQuery()` directly instead of `CRM_Core_Fo...This is replicable by running the report with no changes to defaults on dmaster.
The cause is that the Soft Credit report overrides `CRM_Core_Form::postProcess()` and calls `CRM_Core_DAO::executeQuery()` directly instead of `CRM_Core_Form::buildRows()`, which the FGB safeguards exist. So even though the report is marked as not optimized for FGB, it makes no difference.5.12.0JonGoldJonGoldhttps://lab.civicrm.org/dev/core/-/issues/3231Correct Mailing Report unique Count2022-04-22T15:51:27ZsunilCorrect Mailing Report unique CountMailing -> Scheduled and Sent Mailings -> Report
Unique Opens -> Report
Total Opens -> Report
Both Report show same count.Mailing -> Scheduled and Sent Mailings -> Report
Unique Opens -> Report
Total Opens -> Report
Both Report show same count.5.10https://lab.civicrm.org/dev/core/-/issues/3230Membership join date checkbox on constituent detail report has lost its label2022-04-22T15:51:23ZDaveDMembership join date checkbox on constituent detail report has lost its labelOn the columns tab there's a checkbox that has no label. It's supposed to be membership join date. I'm not sure when it started but seems to go back to at least 5.20.
In the report the line that defines join_date has always set it to nu...On the columns tab there's a checkbox that has no label. It's supposed to be membership join date. I'm not sure when it started but seems to go back to at least 5.20.
In the report the line that defines join_date has always set it to null and that hasn't changed, so maybe what changed is that at some point something elsewhere changed to show blank checkboxes instead of skipping them when the field definition is null.5.25.0https://lab.civicrm.org/dev/core/-/issues/3229When using the Search Kit and Form Builder to implement a front-end Search Li...2022-04-22T15:51:21Zjustinfreeman (Agileware)When using the Search Kit and Form Builder to implement a front-end Search Listing, how do I NOT output the CiviCRM breadcrumb as it duplicates the existing website breadcrumb?When using the Search Kit and Form Builder to implement a front-end Search Listing, how do I NOT output the CiviCRM breadcrumb as it duplicates the existing website breadcrumb?
# For an anonymous user visiting the website, this is what ...When using the Search Kit and Form Builder to implement a front-end Search Listing, how do I NOT output the CiviCRM breadcrumb as it duplicates the existing website breadcrumb?
# For an anonymous user visiting the website, this is what they see
They see two breadcrumb trails. The 2nd one being added by Form Builder and showing the name of the Form.
![Screenshot_20211116_113337](/uploads/3a91ac5c747633f33c1cf842624efa43/Screenshot_20211116_113337.png)
# For a logged in user with access to CiviCRM, this is what they see
They see two breadcrumb trails. The 2nd one being added by Form Builder and showing back-end CiviCRM breadcrumb.
![Screenshot_20211112_174423](/uploads/ab1f20aa77497cbdd3dfae8052e4394c/Screenshot_20211112_174423.png)https://lab.civicrm.org/dev/core/-/issues/3228Can't filter by anything other than contribution status in Contribution Aggre...2022-04-22T15:51:19ZDaveDCan't filter by anything other than contribution status in Contribution Aggregate by Relationship CiviReportThere's a hack(?) in the report to allow filtering by status: https://github.com/civicrm/civicrm-core/blob/08e8cd56136aed47f3c9e598c2d9f318d6c81977/CRM/Report/Form/Contribute/History.php#L432-L434
and then the query uses it at https://g...There's a hack(?) in the report to allow filtering by status: https://github.com/civicrm/civicrm-core/blob/08e8cd56136aed47f3c9e598c2d9f318d6c81977/CRM/Report/Form/Contribute/History.php#L432-L434
and then the query uses it at https://github.com/civicrm/civicrm-core/blob/08e8cd56136aed47f3c9e598c2d9f318d6c81977/CRM/Report/Form/Contribute/History.php#L688-L690
(Yes this report is in a file called History.php - I assume for _historical_ reasons...)
But choosing to filter by anything else doesn't apply the filter.
1. Create two contributions for a person, with different financial types.
1. Run the report and check the Aggregate Amount column and filter by one financial type.
1. It still includes both contributions.
There's an argument that this is "correct" in the sense described at https://lab.civicrm.org/dev/core/-/issues/2707#note_62816, i.e. "Find contacts that match the criteria, THEN run the report on them", so that it's finding _CONTACTS_ that have a contribution with that financial type, and then running the report and aggregating their contributions. But this report isn't a generic advanced search, it's specifically related to contributions, so I'd argue the contribution filters should apply to the contributions being included.
I can see why this might be a little difficult in this report because it needs to build the rows separately to handle the relationships, so it doesn't just use the stock civireport framework to do the filtering. But maybe the "hack" could be made more generic.
The report also gives an error `User deprecated function: Formatting non-numeric values is no longer supported: ... Caller: CRM_Utils_Money::formatLocaleNumericRoundedByPrecision` but that's separate. (Edit: Haha it seems I've noticed this before https://lab.civicrm.org/dev/core/-/issues/2819)5.45.0https://lab.civicrm.org/dev/core/-/issues/3227getAddressColumns defined `street_name` twice.2022-04-22T15:51:17ZJonGoldgetAddressColumns defined `street_name` twice.As reported [on Stack Exchange](https://civicrm.stackexchange.com/questions/26457/columns-available-for-sorting-in-civireport-seem-arbitrary-random), you can't sort by `address_name`, even though it's defined to allow it. That's because...As reported [on Stack Exchange](https://civicrm.stackexchange.com/questions/26457/columns-available-for-sorting-in-civireport-seem-arbitrary-random), you can't sort by `address_name`, even though it's defined to allow it. That's because it's defined twice in the `$spec` array.5.7JonGoldJonGoldhttps://lab.civicrm.org/dev/core/-/issues/3226500 error saving Search Kit Smart Group sorted on aggregated field2022-04-22T15:51:16ZBobS500 error saving Search Kit Smart Group sorted on aggregated fieldUpon saving a Search Kit Smart Group search sorted on an aggregated field, the server throws a 500 error (as seen in the browser console window) and the form continues to display the "Saving" status indefinitely.
Error occurs in Civi/Ap...Upon saving a Search Kit Smart Group search sorted on an aggregated field, the server throws a 500 error (as seen in the browser console window) and the form continues to display the "Saving" status indefinitely.
Error occurs in Civi/Api4/Query/Api4SelectQuery.php::buildOrderBy() with <br>
`Invalid field 'GROUP_CONCAT_DISTINCT_Contact_ActivityContact_Activity_01_subject'`
To recreate:
- Search | Search Kit: New Search
- Search for: Contacts.
- With Optional: Contact Activities If Contact Role = Activity Targets.
- Group By: Contact ID.
- Aggregate Fields: Subject: List Distinct.
- In the search result list, click the "Contact Activities: (List) Subject" header to sort by that column.
- Add: Smart Group.
- Enter titles for the Search Kit search and Smart Group
- Click Save.
- Observe "Saving" status, error in browser console and in Civi log file.
Civi 5.38.0. Confirmed on Demo site.https://lab.civicrm.org/dev/core/-/issues/3225SearchKit/Form: exposing a Date custom field has invalid year range2022-04-22T15:51:14ZbgmSearchKit/Form: exposing a Date custom field has invalid year rangeTo reproduce on dmaster:
1) Create a new Custom Field (ex: Lucky Day), type 'Date', searchable, by range.
![image](/uploads/06c2a53ea2ca237bf3b1e2a6332dc5cd/image.png)
Optionally you can update a contact, so that at least one has a Lu...To reproduce on dmaster:
1) Create a new Custom Field (ex: Lucky Day), type 'Date', searchable, by range.
![image](/uploads/06c2a53ea2ca237bf3b1e2a6332dc5cd/image.png)
Optionally you can update a contact, so that at least one has a Lucky Day, but it is not a requirement to reproduce the bug. For extra luck, I used 2021-08-13.
2) Create a SearchKit that lists Contacts, and display the field
3) Create a Form for that Search, and expose the Lucky Day field as a filter. Give the form an URL to view the page.
![image](/uploads/5ee592a6a1b483797d01b8712eb68761/image.png)
Then go view the form, and notice how the date filter only lets you select dates in 2021:
![image](/uploads/b7ce2b3f40df756fb8347586a9c4d0b4/image.png)
If you go back to the custom field configuration, and set a number of years in the "Dates may be up to" prior/after, then the filter works correctly. However, having these fields empty usually means that there are no restrictions (or they default to -20/+10 years).5.46.0https://lab.civicrm.org/dev/core/-/issues/3224Search Kit doesn't display related contact custom fields2022-04-22T15:51:13ZJonGoldSearch Kit doesn't display related contact custom fieldsIf you have a Search Kit that includes a related contact, displaying the related contact's custom data will actually show the main contact's custom data.
See screenshots below. Teresa has a most important issue of "Education", Santina'...If you have a Search Kit that includes a related contact, displaying the related contact's custom data will actually show the main contact's custom data.
See screenshots below. Teresa has a most important issue of "Education", Santina's is "Social Justice". When I build a search and include both the `Constituent Information: Most Important Issue` and `Contact Related Contacts: Constituent Information: Most Important Issue` columns, they both have the same value.
![Selection_1184](/uploads/ba7c2f496b001f8bd86536d9419b0035/Selection_1184.png)
![Selection_1185](/uploads/d28c833e256a6dcc091d5f1629a124f2/Selection_1185.png)
![Selection_1186](/uploads/65af3fd4f21cb09b60274a700ee2f580/Selection_1186.png)5.42.0https://lab.civicrm.org/dev/core/-/issues/3223Search > Merge: Not merging correctly with a DOCX file2023-12-27T05:03:25ZswebervnaSearch > Merge: Not merging correctly with a DOCX fileIf I perform an Advanced Search, select "Thank-you letters - print or email":
![image](/uploads/15c884703b5e46196d20feaac5e74be3/image.png)
..chose my options (group by Contact, separator Comma) and run the merge, it's not filling in any...If I perform an Advanced Search, select "Thank-you letters - print or email":
![image](/uploads/15c884703b5e46196d20feaac5e74be3/image.png)
..chose my options (group by Contact, separator Comma) and run the merge, it's not filling in any of my merge codes in the DOCX:
![image](/uploads/93e615c800a296d05bcb6daaa7d036a5/image.png)
1. I triple-checked, all merge codes are typed in exactly as they are in Civi.
2. I even tried using my doc with only a few merge codes, same issue.
3. No difference if I output merge from Civi in DOCX vs PDF.
4. Interestingly, the first time I did the merge everything filled in correctly except for the table at the bottom which groups contributions by "Comma", then all future merges done with this search don't merge correctly at all.
I'm guessing this is a bug with Civi, I tried the same thing on the demo and ran into the same problem with DOCX files.
**Workaround:**
My workaround is to replicate my letter as a Message Template in Civi since the native template works with the fields 100% each time - the downside to this is the limitations of CKEditor4. It's a pain to insert page breaks, center paragraphs, etc, way too basic formatting options.https://lab.civicrm.org/dev/core/-/issues/3222Search Kit: Can't add/remove more than ~500 contacts to a group2022-05-23T20:33:50ZJonGoldSearch Kit: Can't add/remove more than ~500 contacts to a groupTo replicate, do a SK search on a database with several thousand contacts that returns 1000+ contacts. Select all and the "Add to Group" action.
### Expected Result
Contacts are added to a group.
### Actual result
414 error ("URL too ...To replicate, do a SK search on a database with several thousand contacts that returns 1000+ contacts. Select all and the "Add to Group" action.
### Expected Result
Contacts are added to a group.
### Actual result
414 error ("URL too long").https://lab.civicrm.org/dev/core/-/issues/3221SearchKit: In-place edit for custom dropdown field - can't blank it out2022-04-22T18:15:33ZDaveDSearchKit: In-place edit for custom dropdown field - can't blank it outIf you have a search display with a dropdown custom field with in-place edit enabled and the field is defined as not required, you should be able to blank it out. But there is no "X" icon or "-none-" choice.If you have a search display with a dropdown custom field with in-place edit enabled and the field is defined as not required, you should be able to blank it out. But there is no "X" icon or "-none-" choice.https://lab.civicrm.org/dev/core/-/issues/3220SearchKit: Unable to take any actions on results after searching2022-04-27T09:07:58Zben_fairlessSearchKit: Unable to take any actions on results after searchingOverview
----------------------------------------
I can create searches and run them (and see the results) however context buttons don't work (such as the 3 lines next to each contact, or the 3 lines next to the edit button on the search...Overview
----------------------------------------
I can create searches and run them (and see the results) however context buttons don't work (such as the 3 lines next to each contact, or the 3 lines next to the edit button on the search, or the "Actions" button after ticking a number of contacts).
There are no errors present in the Browser console (was asked to check there in chat). I'm not sure where else I could check for errors.
https://chat.civicrm.org/civicrm/pl/wis4messf7rdtbo91mpabozw6w
Reproduction steps
----------------------------------------
1. Navigate to Search > Search Kit
2. Click New Search
3. Search for "Contacts"
4. Set 1st Criteria to "Postcode is one of [number of postcodes]
5. Set 2nd Criteria to "With (required) Contact Groups, if Group Contact Status = Added and Group Title is one of [Group Name]
6. Run Search
7. Attempt to click 3 lines in the right most column OR attempt to tick a box and select "Actions"
Current behaviour
----------------------------------------
Nothing happens. There is nothing recorded in the Developer Console in the Browser. There are no 500 errors or 403 errors.
Expected behaviour
----------------------------------------
Contextual options should appear to perform actions on the relevant contact.
Environment information
----------------------------------------
* __Browser:__ _Chrome Version 100.0.4896.127_
* __CiviCRM:__ _5.48.1_
* __PHP:__ _7.4.28 (Supports 64bit values)_
* __CMS:__ _WordPress 5.9.3_
* __Database:__ _10.2.43-MariaDB_
* __Web Server:__ _Apache_
Comments
----------------------------------------
No Contextual options work at all, including options not related to search (EG, attempting to add Tags after Step 1 on the Custom Search view).https://lab.civicrm.org/dev/core/-/issues/3219Error when trying to generate thank-you letters for contributions2023-12-26T05:03:26ZswebervnaError when trying to generate thank-you letters for contributionsI'm getting an error "Invalid activity id" when I go to generate thank-you letters based on the search results from my Advanced Search.
I got to Advanced Search, displaying results as Contributions, set all my filters, and then search f...I'm getting an error "Invalid activity id" when I go to generate thank-you letters based on the search results from my Advanced Search.
I got to Advanced Search, displaying results as Contributions, set all my filters, and then search for results. I then select all the results and select the option to make thank-you letters:
![image](/uploads/7871b2abf7e72c092eb1f8eb53e8c681/image.png)
At the next screen, I then choose my message template and click Make Thank-you letters at the bottom, to which I get this error after:
![image](/uploads/be66a1af0e52028de2ccb4b12f63eb93/image.png)
This issue seems to happen regardless of the filters I set for the contribution results, or what's in my message template. It's failing altogether, no matter what, to generate the thank-you letters.
Here's the fatal error description from Civi that my hosting provider gave me:
> $Fatal Error Details = array(3) { ["message"]=> string(19) "Invalid Activity Id" ["code"]=> NULL ["exception"]=> object(CiviCRM_API3_Exception)#2113 (8) { ["extraParams":"CiviCRM_API3_Exception":private]=> array(5) { ["error_code"]=> int(0) ["entity"]=> string(8) "Activity" ["action"]=> string(6) "create" ["is_error"]=> int(1) ["error_message"]=> string(19) "Invalid Activity Id" } ["message":protected]=> string(19) "Invalid Activity Id" ["string":"Exception":private]=> string(0) "" ["code":protected]=> int(0) ["file":protected]=> string(51) "/var/www/html/sites/all/modules/civicrm/api/api.php" ["line":protected]=> int(133) ["trace":"Exception":private]=> array(15) { [0]=> array(4) { ["file"]=> string(81)
**Things I've tried:**
1. Performing the process on only Individuals, and not all 3 - issue persists.
2. Performing the process on a smaller number of contributions (i.e. 60), issue persists regardless of size.
3. Performing the process without a template - issue persists.
**Similiar Issues:**
1. https://civicrm.stackexchange.com/questions/38540/invalid-currency-error-when-using-custom-template?noredirect=1#comment44099_38540
2. https://lab.civicrm.org/dev/core/-/issues/2344
3. https://github.com/civicrm/civicrm-core/pull/19481https://lab.civicrm.org/dev/core/-/issues/3217[Feature] Please give us the option to disable subtotals for Soft Credit Cont...2023-12-26T05:03:25Zswebervna[Feature] Please give us the option to disable subtotals for Soft Credit Contribution ReportsCurrently, Soft Credit Contribution Reports always output subtotal: ![image](https://lab.civicrm.org/dev/mail/uploads/39254fd8a1be8b42d9889da4230d91d0/image.png)
I think it would be nice to disable this as an option, so we can remove th...Currently, Soft Credit Contribution Reports always output subtotal: ![image](https://lab.civicrm.org/dev/mail/uploads/39254fd8a1be8b42d9889da4230d91d0/image.png)
I think it would be nice to disable this as an option, so we can remove the subtotal if we don't need them.