Search and Reporting - archived issueshttps://lab.civicrm.org/dev/report/-/issues2022-04-22T15:47:19Zhttps://lab.civicrm.org/dev/report/-/issues/97SearchKit not functional on Joomla 42022-04-22T15:47:19Zjoshjosh@civicrm.orgSearchKit not functional on Joomla 4The past two release of CiviCRM have resulted in SearchKit not functioning on Joomla 4. When browsing to SearchKit, the user is presented with what appears to be unrendered code:
![Screenshot_2022-02-21_12.13.32](/uploads/5899ba97078e89...The past two release of CiviCRM have resulted in SearchKit not functioning on Joomla 4. When browsing to SearchKit, the user is presented with what appears to be unrendered code:
![Screenshot_2022-02-21_12.13.32](/uploads/5899ba97078e894cb86ba703c06eb300/Screenshot_2022-02-21_12.13.32.jpg)
Console presents the following error:
```
Error: [$injector:unpr] http://errors.angularjs.org/1.8.2/$injector/unpr?p0=savedSearchesProvider%20%3C-%20savedSearches%20%3C-%20searchList
at angular.min.js:7:168
at angular.min.js:46:468
at Object.d [as get] (angular.min.js:44:197)
at angular.min.js:47:29
at d (angular.min.js:44:197)
at e (angular.min.js:44:438)
at Object.instantiate (angular.min.js:45:333)
at angular.min.js:99:267
at Object.link (angular-modules.d0a616a75686afef23d3772fcee92a7f.js:5648:217)
at angular.min.js:17:134 '<div ng-view="" class="ng-scope">'
(anonymous) @ angular.js:15697
```
All other aspects of CiviCRM appear to be functional. The issue can be reproduced at https://cividemo.com and on fresh installs of just Joomla and CiviCRM (no extensions installed on either systems).Monish DebMonish Debhttps://lab.civicrm.org/dev/report/-/issues/76Search Kit: Dropdown for the related contacts entity says "name" but for disp...2022-04-22T15:47:20ZDaveDSearch Kit: Dropdown for the related contacts entity says "name" but for display it shows "label"The field that's in the relationship_cache table is the `name` of the relationship type, so it does make sense that any dropdowns related to it would say `name`. However when you are selecting columns to include in the output, what it ac...The field that's in the relationship_cache table is the `name` of the relationship type, so it does make sense that any dropdowns related to it would say `name`. However when you are selecting columns to include in the output, what it actually displays in the table (correctly I would say) is `label`. So there's a minor disconnect.
![Untitled](/uploads/cb49a36f417ece8211c0da15e5f50c51/Untitled.png)https://lab.civicrm.org/dev/report/-/issues/94SearchKit: fieldset legend display in Drupal 9 Seven admin theme2022-04-22T15:47:24ZherbdoolSearchKit: fieldset legend display in Drupal 9 Seven admin themeDrupal 9's default admin theme, Seven, sets an `position: absolute` for fieldset legends (`core/themes/seven/css/components/form.css`) if the fieldset is not in a `.fieldgroup` (`fieldset:not(.fieldgroup) > legend`). It looks like:
![Sc...Drupal 9's default admin theme, Seven, sets an `position: absolute` for fieldset legends (`core/themes/seven/css/components/form.css`) if the fieldset is not in a `.fieldgroup` (`fieldset:not(.fieldgroup) > legend`). It looks like:
![Screenshot_from_2022-01-11_11-10-20](/uploads/9381f41cacc03748bd1b90b7756b8ef6/Screenshot_from_2022-01-11_11-10-20.png)
I guess the easiest is to set a `position: relative` in `civicrm/core/ext/search_kit/css/crmSearchAdmin.css`https://lab.civicrm.org/dev/report/-/issues/39Exporting "Spouse of" or other relationship with matching labels only exports...2022-04-22T15:47:25ZtommyboboExporting "Spouse of" or other relationship with matching labels only exports the A>B relationshipWhen exporting a contact and their related contacts, the relationship type dropdown truncates all the "duplicate" relationship labels. So when you a user selects "Spouse Of" it only exports the A>B relationship.
If you were to export Jo...When exporting a contact and their related contacts, the relationship type dropdown truncates all the "duplicate" relationship labels. So when you a user selects "Spouse Of" it only exports the A>B relationship.
If you were to export John Doe(A) and James Doe(B), who are spouses, the export would be rendered as
| First | Last | Spouse of First | Spouse of Last |
| ------ | ------ | ------ | ------ |
| John | Doe | James | Doe |
| James | Doe | | |
This is an issue if you are trying to export a list of donors and spouses. If the primary donor is the B spouse you will end up with no spouse exported.
This appears to be an old issue.
https://civicrm.stackexchange.com/questions/27001/exporting-spouses-only-exports-one-side-of-relationshiphttps://lab.civicrm.org/dev/report/-/issues/100SearchKit: Rewrite and Group By don't mix2022-04-22T15:47:57ZJonGoldSearchKit: Rewrite and Group By don't mixWhen using "Rewrite" in a search display, the rendered token for fields we've grouped by only show the first value.
### Steps to Replicate
* Install Search Kit, import the Search/Display below.
* Preview the Display.
* Turn off "Rewrite...When using "Rewrite" in a search display, the rendered token for fields we've grouped by only show the first value.
### Steps to Replicate
* Install Search Kit, import the Search/Display below.
* Preview the Display.
* Turn off "Rewrite" on the "Total Amount" field and preview again.
### Expected Result
Rendered token has the same output as the non-rewritten field.
### Actual Result
Token only renders the first value in a list.
```
[
[
"SavedSearch",
"save",
{
"records": [
{
"name": "group_and_rewrite",
"label": "group and rewrite",
"form_values": null,
"search_custom_id": null,
"api_entity": "Contact",
"api_params": {
"version": 4,
"select": [
"id",
"display_name",
"GROUP_CONCAT(Contact_Contribution_contact_id_01.total_amount) AS GROUP_CONCAT_Contact_Contribution_contact_id_01_total_amount"
],
"orderBy": [],
"where": [],
"groupBy": [
"id"
],
"join": [
[
"Contribution AS Contact_Contribution_contact_id_01",
"LEFT",
[
"id",
"=",
"Contact_Contribution_contact_id_01.contact_id"
]
]
],
"having": []
},
"expires_date": null,
"description": null,
"mapping_id": null
}
],
"match": [
"name"
]
}
],
[
"SearchDisplay",
"save",
{
"records": [
{
"name": "Contacts_Table_1",
"label": "Contacts Table 1",
"saved_search_id.name": "group_and_rewrite",
"type": "table",
"settings": {
"actions": true,
"limit": 50,
"classes": [
"table",
"table-striped"
],
"pager": {
"show_count": true,
"expose_limit": true
},
"sort": [
[
"sort_name",
"ASC"
]
],
"columns": [
{
"type": "field",
"key": "id",
"dataType": "Integer",
"label": "Contact ID",
"sortable": true
},
{
"type": "field",
"key": "display_name",
"dataType": "String",
"label": "Display Name",
"sortable": true
},
{
"type": "field",
"key": "GROUP_CONCAT_Contact_Contribution_contact_id_01_total_amount",
"dataType": "Money",
"label": "(List) Contact Contributions: Total Amount",
"sortable": true,
"rewrite": "[GROUP_CONCAT_Contact_Contribution_contact_id_01_total_amount]"
}
]
},
"acl_bypass": false
}
],
"match": [
"name",
"saved_search_id"
]
}
]
]
```https://lab.civicrm.org/dev/report/-/issues/52Can't see Soft Credit fields on a Contribution Detail Report?2022-04-22T15:47:59ZswebervnaCan't see Soft Credit fields on a Contribution Detail Report?When I add Soft Credit columns to a Contribution Detail Report, the data doesn't show - they're just empty cells:
![image](/uploads/226d25462b7b82772e627914989d7475/image.png)
(That first row/entry you see is in fact a contribution with...When I add Soft Credit columns to a Contribution Detail Report, the data doesn't show - they're just empty cells:
![image](/uploads/226d25462b7b82772e627914989d7475/image.png)
(That first row/entry you see is in fact a contribution with a soft credit, I checked.)https://lab.civicrm.org/dev/report/-/issues/50Searching on address custom field for shared address2022-04-22T15:48:02ZMartinSearching on address custom field for shared addressFound this on Drupal 7 / Civi 5.28.3. We have a custom group on the Address entity with one custom field, and we often use shared addresses for our contacts (for example, an individual uses the address configured on a household contact)....Found this on Drupal 7 / Civi 5.28.3. We have a custom group on the Address entity with one custom field, and we often use shared addresses for our contacts (for example, an individual uses the address configured on a household contact).
For the contact using the shared address (i.e. the individual in the example above):
- The custom field does appear for them, for example on their contact summary page.
- The custom field does not get associated with them when doing any sort of searching (tested in advanced search and search builder).
I tested and confirmed this in dmaster (5.31.alpha1) with the following steps:
1. Created custom group for Address, with custom alphanumeric field as a select input with 3 options.
1. Created individuals test1 and test2, with relationship between them (I think actually the relationship is not needed, but anyways..).
1. Created address on test1 with "opt2" selected on custom field. On test2 selected this address to use as a shared address.
1. At this point both contact summary pages display the correct complete address with opt2 showing.
1. Do advanced search for address custom field opt2. Only contact test1 shows up.
1. Do search builder search for parameter Contacts -> Addr customgroup:customfield -> Primary -> equals -> opt2. Only contact test1 shows up.https://lab.civicrm.org/dev/report/-/issues/41Contributions search result summary not correct2022-04-22T15:48:06ZhfarooqContributions search result summary not correctCMS: Drupal 7.69
CiviCRM: 5.21.3
If contributions with status complete and for "Contributions OR Soft Credits?" field, select "Both" (both contributions and soft credits), in result summary there is a discrepancy seen; Number of total r...CMS: Drupal 7.69
CiviCRM: 5.21.3
If contributions with status complete and for "Contributions OR Soft Credits?" field, select "Both" (both contributions and soft credits), in result summary there is a discrepancy seen; Number of total results does not match with the sum of total contributions and soft credits, please see attached screenshot. I was able to replicate it on [dmaster demo](https://dmaster.demo.civicrm.org/) site at some point back few days but not anymore.
![image](/uploads/ad23a1a46871a5cf9aae541424fc4463/image.png)https://lab.civicrm.org/dev/report/-/issues/26Participant Listing report Unknown column 'contact_civireport.age_at_event2022-04-22T15:48:16ZEmerykZielinskiParticipant Listing report Unknown column 'contact_civireport.age_at_eventHey all,
when I try to sort Participant Listing report by age of the Participant (in the time of the event) i get the following error:
`[debug] $backTrace = #0 /var/www/html/sites/all/modules/civicrm/CRM/Core/Error.php(208): CRM_Core_E...Hey all,
when I try to sort Participant Listing report by age of the Participant (in the time of the event) i get the following error:
`[debug] $backTrace = #0 /var/www/html/sites/all/modules/civicrm/CRM/Core/Error.php(208): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /var/www/html/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::handle(Object(DB_Error))
#2 /var/www/html/sites/all/modules/civicrm/packages/DB.php(987): PEAR_Error->__construct("DB Error: no such field", -19, 16, (Array:2), "SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...")
#3 /var/www/html/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-19, 16, (Array:2), "SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...")
#4 /var/www/html/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -19, 16, (Array:2), "SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...", "DB_Error", TRUE)
#5 /var/www/html/sites/all/modules/civicrm/packages/DB/common.php(1920): PEAR->__call("raiseError", (Array:7))
#6 /var/www/html/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-19, NULL, NULL, "SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...", "1054 ** Unknown column 'contact_civireport.age_at_event' in 'field list'")
#7 /var/www/html/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
#8 /var/www/html/sites/all/modules/civicrm/packages/DB/common.php(1229): DB_mysqli->simpleQuery("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...")
#9 /var/www/html/sites/all/modules/civicrm/packages/DB/DataObject.php(2416): DB_common->query("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...")
#10 /var/www/html/sites/all/modules/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...")
#11 /var/www/html/sites/all/modules/civicrm/CRM/Core/DAO.php(435): DB_DataObject->query("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...")
#12 /var/www/html/sites/all/modules/civicrm/CRM/Core/DAO.php(1428): CRM_Core_DAO->query("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...", TRUE)
#13 /var/www/html/sites/all/modules/civicrm/CRM/Report/Form.php(3076): CRM_Core_DAO::executeQuery("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...")
#14 /var/www/html/sites/all/modules/civicrm/CRM/Report/Form.php(3561): CRM_Report_Form->buildRows("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_so...", (Array:0))
#15 /var/www/html/sites/all/modules/civicrm/CRM/Report/Form/Event/ParticipantListing.php(616): CRM_Report_Form->postProcess()
#16 /var/www/html/sites/all/modules/civicrm/CRM/Core/Form.php(495): CRM_Report_Form_Event_ParticipantListing->postProcess()
#17 /var/www/html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Submit.php(74): CRM_Core_Form->mainProcess()
#18 /var/www/html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Submit->perform(Object(CRM_Report_Form_Event_ParticipantListing), "submit")
#19 /var/www/html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Report_Form_Event_ParticipantListing), "submit")
#20 /var/www/html/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("submit")
#21 /var/www/html/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(114): CRM_Core_Controller->run()
#22 /var/www/html/sites/all/modules/civicrm/CRM/Report/Page/Instance.php(90): CRM_Utils_Wrapper->run("CRM_Report_Form_Event_ParticipantListing", NULL, (Array:0))
#23 /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php(284): CRM_Report_Page_Instance->run((Array:4), NULL)
#24 /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:14))
#25 /var/www/html/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#26 /var/www/html/sites/all/modules/civicrm/drupal/civicrm.module(444): CRM_Core_Invoke::invoke((Array:4))
#27 /var/www/html/includes/menu.inc(527): civicrm_invoke("report", "instance", "26")
#28 /var/www/html/index.php(21): menu_execute_active_handler()
#29 {main}`
is there a way to set up the column `contact_civireport.age_at_event` by myself?https://lab.civicrm.org/dev/report/-/issues/66Reports need validation on Email Delivery fields2022-04-22T15:48:26ZandrewcormickdockeryReports need validation on Email Delivery fieldsSee attached image. When trying to send reports via the Email Delivery tab, the emails do not get sent if invalid characters are included in either the To or the CC fields. In our case, the user included extraneous spaces and commas, a...See attached image. When trying to send reports via the Email Delivery tab, the emails do not get sent if invalid characters are included in either the To or the CC fields. In our case, the user included extraneous spaces and commas, as shown in the diagram. No warning is given to the user in this instance, which leads to confusion when the emails don't get sent, and a system administrator needs to examine errors on the back end to determine the problem and correct it. It would be much preferable for appropriate validation to occur on these fields to prevent invalid values from being entered in the first place, with messages being displayed towards the user entering the invalid values.
URL for this screen: https://example.com/civicrm/report/instance/####?reset=1&output=criteria where #### is the report instance ID.
CiviCRM version: 5.35.2
![image](/uploads/d1fb446ce1c82f0d10b7a57a64f6753b/image.png)https://lab.civicrm.org/dev/report/-/issues/13Contribution Detail Report: cannot sort by Contribution Status, when filter "...2022-04-22T15:48:27ZbgmContribution Detail Report: cannot sort by Contribution Status, when filter "Contribution OR Soft Credit = Both"I found that this odd combination of criteria will crash the Contribution Detail report:
* Sort: Contribution Status
* Filters: Contribution OR Soft Credit? = Both
This will result in a fatal error: "The used SELECT statements have a d...I found that this odd combination of criteria will crash the Contribution Detail report:
* Sort: Contribution Status
* Filters: Contribution OR Soft Credit? = Both
This will result in a fatal error: "The used SELECT statements have a different number of columns".
More specifically:
```
CREATE TEMPORARY TABLE civireport_contribution_detail_temp3 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci
(SELECT * FROM civicrm_tmp_e_dflt_2be28f58f1295cc154076c2ded818b52)
UNION ALL
(SELECT * FROM civireport_contribution_detail_temp2)
```
where `temp1` has `civicrm_contribution_contribution_status_id`, but `temp2` does not.
I don't think it's a recent regression. I tested in CiviCRM 5.12 (master) and 5.8.https://lab.civicrm.org/dev/report/-/issues/21Contribution Details Statistics are multiplied under many circumstances2022-04-22T15:48:29ZJonGoldContribution Details Statistics are multiplied under many circumstancesThis bug was previously identified and fixed as core#655, but the fix only addresses the rows and not the statistics.
In addition to contribution detail rows getting multiplied by soft credits, they can be multipled by any one-to-many `...This bug was previously identified and fixed as core#655, but the fix only addresses the rows and not the statistics.
In addition to contribution detail rows getting multiplied by soft credits, they can be multipled by any one-to-many `JOIN` to the contribution table. Soft credits are one example, but it can also be to a contact's multi-record contact field group, or if you pick a field (like "Credit Card Type") that lives in the financial transaction tables ([first reported on SE](https://civicrm.stackexchange.com/a/28791/12) by @KarinG).
Given that the statistics don't concern itself with any data that's not in `civicrm_contribution`, we can replace the flawed (and potentially CPU-intensive) original query with a list of contribution IDs and only use `FROM civicrm_contribution`.JonGoldJonGoldhttps://lab.civicrm.org/dev/report/-/issues/38Country and State criteria disappear when editing smart group2022-04-22T15:48:32Zm robimorgan@palantetech.coopCountry and State criteria disappear when editing smart groupSteps to replicate:
* Run advanced search with Country + State (I used United States + Texas)
* Create smart group with the results
* View contacts in smart group, select "Edit Smart Group Criteria"
* United States + Texas are not popula...Steps to replicate:
* Run advanced search with Country + State (I used United States + Texas)
* Create smart group with the results
* View contacts in smart group, select "Edit Smart Group Criteria"
* United States + Texas are not populated on the search form.
Notes
* Replicated on wpmaster and dmaster
* Noticed the issue in a Wordpress site on 5.19.4
* The issue is also affecting existing smart groups.
* The groups themselves remain functional.
* Other address and other search criteria are saved. Just the country, and fields that depend on the country to be populated, are cleared.https://lab.civicrm.org/dev/report/-/issues/18Participant Listing report filters incorrectly on role ID2022-04-22T15:48:33ZJonGoldParticipant Listing report filters incorrectly on role IDThis issue is identical to [CRM-18803](https://issues.civicrm.org/jira/browse/CRM-18803) except that CRM-18803 affected all other CiviReports with fields that stored values separated by `CRM_Core_DAO::VALUE_SEPARATOR`. Those were fixed ...This issue is identical to [CRM-18803](https://issues.civicrm.org/jira/browse/CRM-18803) except that CRM-18803 affected all other CiviReports with fields that stored values separated by `CRM_Core_DAO::VALUE_SEPARATOR`. Those were fixed everywhere else by [this PR](https://github.com/civicrm/civicrm-core/pull/8650). However, since the `where()` in this report is overridden, it has its own copy of the regex which wasn't fixed.
I grepped and confirmed this is the only place where this needs to be fixed, and applied the same regex as the commit above.
To replicate this bug, you need at least ten participant roles. The first one's value should be `1`. Searching on this value will return any participant whose role BEGINS with a `1` (i.e. `10`, `11`, `100`, etc.) rather than just records whose participant role value IS 1.JonGoldJonGoldhttps://lab.civicrm.org/dev/report/-/issues/65On changing 'Limit Dashboard Results' count adds duplicate dashlet2022-04-22T15:48:38ZMonish DebOn changing 'Limit Dashboard Results' count adds duplicate dashletSteps to replicate:
1. Go to any existing report instance (say 'Activity Details') >> enable for 'Available for Dashboard' >> Save
2. Then change the 'Limit Dashboard Results' count and save again.
3. Go to homepage, and click on 'A...Steps to replicate:
1. Go to any existing report instance (say 'Activity Details') >> enable for 'Available for Dashboard' >> Save
2. Then change the 'Limit Dashboard Results' count and save again.
3. Go to homepage, and click on 'Available Dashlets'
Result:
You will find two duplicate dashlets has been created with same title. Here's a screencast in dmaster:
![after](/uploads/25b339add1a8bba8aa9c1738da7a4e8c/after.gif)Monish DebMonish Debhttps://lab.civicrm.org/dev/report/-/issues/56Error when trying to generate thank-you letters for contributions2022-04-22T15:48:46ZswebervnaError 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/35856a56d4f5b0f803478ceff4f487ff/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/fe3a13ef1c45e2fae4ad1da41ce542f7/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/report/-/issues/92SearchKit: In-place edit for custom dropdown field - can't blank it out2022-04-22T15:48:48ZDaveDSearchKit: 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/report/-/issues/95Search > Merge: Not merging correctly with a DOCX file2022-04-22T15:48:54ZswebervnaSearch > Merge: Not merging correctly with a DOCX fileIf I perform an Advanced Search, select "Thank-you letters - print or email":
![image](/uploads/3a392ad57ea180d0cced90d3db053b32/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/3a392ad57ea180d0cced90d3db053b32/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/d8f367d2ab4add367262d5f4def87155/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/report/-/issues/73Search 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/2784f2b7cb49e719f7d635ad9944d17b/Selection_1184.png)
![Selection_1185](/uploads/6daea0fb4b9d2e5db34913e9efff23c8/Selection_1185.png)
![Selection_1186](/uploads/a80892c685eca80550e1dfd09002b548/Selection_1186.png)5.42.0https://lab.civicrm.org/dev/report/-/issues/84SearchKit/Form: exposing a Date custom field has invalid year range2022-04-22T15:51:15ZbgmSearchKit/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/bf2abb0ce3a8dd80ebe644506700a380/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/bf2abb0ce3a8dd80ebe644506700a380/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/491b27b752a57122cde45e1d8f70ccf0/image.png)
Then go view the form, and notice how the date filter only lets you select dates in 2021:
![image](/uploads/8148eeb65edf2de3ee68eb7ec3888da3/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.0