Development issueshttps://lab.civicrm.org/groups/dev/-/issues2022-04-22T15:51:27Zhttps://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/3218CSV exports does not respect localization configuration2023-10-19T14:38:19ZmarcusmCSV exports does not respect localization configurationWhen creating CSV exports from searches the e. g. money or date fields are not exported with the configured localization formats.
Configure language: German, decimal separator: ",", thousands sep.: "."
The export looks like this:
```...When creating CSV exports from searches the e. g. money or date fields are not exported with the configured localization formats.
Configure language: German, decimal separator: ",", thousands sep.: "."
The export looks like this:
```
| Nettobetrag |
|-------------|
| 135.00 |
| 20.00 |
| 50.00 |
| 1,130.00 |
should be
| Nettobetrag |
|-------------|
| 135,00 |
| 20,00 |
| 50,00 |
| 1.130,00 |
```
and an example for a date field:
```
| Geburtsdatum |
|--------------|
| 1942-05-02 |
| 1983-06-01 |
should be
| Geburtsdatum |
|--------------|
| 02.05.1942 |
| 01.06.1983 |
```
The export was created with a contribution search.https://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.https://lab.civicrm.org/dev/core/-/issues/3216dev/report#53: search on relationship and case (2)2023-12-25T05:03:31Zeileendev/report#53: search on relationship and case (2)Unfortunately we had to revert https://github.com/civicrm/civicrm-core/pull/20002 since it was too complicated to fix the regression it causes in time for the release otherwise
Overview
When doing an advanced search with case parameters...Unfortunately we had to revert https://github.com/civicrm/civicrm-core/pull/20002 since it was too complicated to fix the regression it causes in time for the release otherwise
Overview
When doing an advanced search with case parameters set and displaying related contacts. Gives all clients of all the found cases which have this relationship. What we would expect is that related contact is linked to the found cases.
Steps to reproduce
Preparation:
Create a contact Contact A
Create another contact Contact B
Create a third contact Contact C
Create a case of type Housing Support for Contact A
On the case assign the role Benefit specialist is to Contact B
Create a second case of type Adult day care referral
On the case assign the role Benefit specialist is to Contact C
Searching:
Go to advanced search
Click on View contact as related contact
Select Benefit Specialist as relationship type
Go to tab cases and select Housing Support as case type
Expected results
I expected to see only Contact B as that one has a relationship on the case Housing Support.
Actual results
I see both Contact B and Contact C.
Comments
See also the discussion of a similar related topic: https://lab.civicrm.org/dev/report/-/issues/53jaapjansmajaapjansmahttps://lab.civicrm.org/dev/core/-/issues/3215On changing 'Limit Dashboard Results' count adds duplicate dashlet2023-12-25T05:03:30ZMonish 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/ff1256639e635a2887033f42b150d2d9/after.gif)Monish DebMonish Debhttps://lab.civicrm.org/dev/core/-/issues/3214Query scheduling & delivered results2022-04-30T09:08:20Zjoshjosh@civicrm.orgQuery scheduling & delivered resultsThis project will allow APIv4 queries to run in the background and notify or deliver results when complete. It supplements the Search-Builder UI project, making complex searches more manageable.
Tasks:
- Add background options to Search...This project will allow APIv4 queries to run in the background and notify or deliver results when complete. It supplements the Search-Builder UI project, making complex searches more manageable.
Tasks:
- Add background options to Search-Builder UI
- Implement queue runner service
- Implement delivery servicecolemanwcolemanwhttps://lab.civicrm.org/dev/core/-/issues/3213When using Form Builder and "Accessible on front-end of website", how do I di...2023-12-24T05:03:21Zjustinfreeman (Agileware)When using Form Builder and "Accessible on front-end of website", how do I disable the CiviCRM styling for this front-end page?When using Form Builder and "Accessible on front-end of website", how do I disable the CiviCRM styling for this front-end page?
I understand that the CiviCRM CSS can be disabled entirely on the website. But I just want to **disable the ...When using Form Builder and "Accessible on front-end of website", how do I disable the CiviCRM styling for this front-end page?
I understand that the CiviCRM CSS can be disabled entirely on the website. But I just want to **disable the CiviCRM styling specifically for one or more Form Builder front-end pages**.https://lab.civicrm.org/dev/core/-/issues/3212Participant Listing report filters incorrectly on role ID2023-12-24T05:03:20ZJonGoldParticipant 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.JonGoldJonGold