CiviCRM Core issueshttps://lab.civicrm.org/dev/core/-/issues2023-11-10T00:08:12Zhttps://lab.civicrm.org/dev/core/-/issues/3202In membership detail report the join date field has a different output date f...2023-11-10T00:08:12ZDaveDIn membership detail report the join date field has a different output date format than the other date fieldsCan reproduce on dmaster.demo.
On the membership details report in the columns tab select join date as a field. When you run the report the join date column has a different date format than the start/end date. It seems to always be yyyy...Can reproduce on dmaster.demo.
On the membership details report in the columns tab select join date as a field. When you run the report the join date column has a different date format than the start/end date. It seems to always be yyyy-mm-dd.
Doesn't seem to be a recent issue.5.69.0https://lab.civicrm.org/dev/core/-/issues/2944Make report column groups hookable2023-10-13T05:03:24ZyashodhaMake report column groups hookableProvide a way to manipulate column groups in report to change the order of the column checkboxes in the _Columns_ tab.Provide a way to manipulate column groups in report to change the order of the column checkboxes in the _Columns_ tab.yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/4536Report improvements2023-09-23T05:02:21ZyashodhaReport improvements_Primary Membership_ filter option in _Membership Details_ report has options that don't make sense.
![dddsdsd](/uploads/0e74060c879cbaf416c85e8eb1067134/dddsdsd.png)
Remove options that don't make sense and add option to choose _All_..._Primary Membership_ filter option in _Membership Details_ report has options that don't make sense.
![dddsdsd](/uploads/0e74060c879cbaf416c85e8eb1067134/dddsdsd.png)
Remove options that don't make sense and add option to choose _All_ as well.yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/2723Event participant role filter not working in Participant list report2023-09-08T05:03:14ZvitiusEvent participant role filter not working in Participant list reportParticipant list report with Event participant role filter could show more rows.
Reproduction steps
----------------------------------------
1. Create new participant role with id 11 (or 10, 21,...).
2. Register new participant to event...Participant list report with Event participant role filter could show more rows.
Reproduction steps
----------------------------------------
1. Create new participant role with id 11 (or 10, 21,...).
2. Register new participant to event with this new role
3. Show Participant list report on this event
4. Use Participant Role filter to show only Attendees (id of attendee role is 1)
5. In report will you see also participant with new role with id 11
Current behaviour
----------------------------------------
If you use Participant Role filter in Participant list report, that will be work like that: `role.id LIKE '%1%'` and not like `role.id = '1'`.
Expected behaviour
----------------------------------------
Report should show only exact role.
Environment information
----------------------------------------
* __CiviCRM:__ _Master/5.37.0/5.33.2https://lab.civicrm.org/dev/core/-/issues/2670Emails shown in mailing reports are primary accounts and not the recipient email2023-08-28T05:03:24Zphil.mooreEmails shown in mailing reports are primary accounts and not the recipient emailThe email address listed in mailing reports is the 'primary' email address for the contacts mailed. This is regardless of whether the mailing was sent to the 'primary' email address or if an alternative email had been selected.
Eg. cont...The email address listed in mailing reports is the 'primary' email address for the contacts mailed. This is regardless of whether the mailing was sent to the 'primary' email address or if an alternative email had been selected.
Eg. contacts have work addresses listed as 'primary' and personal addresses listed as 'home'. The mailing is sent to 'home' email addresses, but the emails listed in the report are the 'primary' emails. This gives a false representation to the user of which email address the mailing has gone to.https://lab.civicrm.org/dev/core/-/issues/4532Add sort for country/state fields in reports2023-08-24T15:17:42ZyashodhaAdd sort for country/state fields in reportsAdd sort for country/state fields in reportsAdd sort for country/state fields in reports5.66.0yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/4522Membership Detail improvements2023-08-24T14:02:52ZyashodhaMembership Detail improvementsIn the _Membership Details_ report,
add in _Columns_ tab:
- Auto-renew (Yes/no)
- Auto-renew Status
add in _Sorting_ tab:
- Start Date (of membership)
- End Date (of membership)
- State
- Auto-renew
- Auto-renew StatusIn the _Membership Details_ report,
add in _Columns_ tab:
- Auto-renew (Yes/no)
- Auto-renew Status
add in _Sorting_ tab:
- Start Date (of membership)
- End Date (of membership)
- State
- Auto-renew
- Auto-renew Statusyashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/4510Report results for custom date fields does NOT respect the date format2023-08-24T13:44:13ZyashodhaReport results for custom date fields does NOT respect the date formatSteps to replicate :
--------------------
- Create a custom date field of type _Date_ and date format _yy_
![Screenshot_from_2023-08-18_18-44-03](/uploads/8033862dfeb99ff818d5fb0a58797e7b/Screenshot_from_2023-08-18_18-44-03.png)
- ...Steps to replicate :
--------------------
- Create a custom date field of type _Date_ and date format _yy_
![Screenshot_from_2023-08-18_18-44-03](/uploads/8033862dfeb99ff818d5fb0a58797e7b/Screenshot_from_2023-08-18_18-44-03.png)
- Data shows as correctly on summary screen
![Screenshot_from_2023-08-18_18-45-53](/uploads/8a835e7bf893609014a12e55e977950f/Screenshot_from_2023-08-18_18-45-53.png)
- Report results do NOT respect the format
![Screenshot_from_2023-08-18_18-46-54](/uploads/b4bf0be27d8fc889e3efb93a24206c33/Screenshot_from_2023-08-18_18-46-54.png)
All custom data of type date should have respective Date format respected like on the other screens.yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/4505Localisation: Report contribution_details doesn't respect date format settings2023-08-17T14:24:07ZDetlev SieberLocalisation: Report contribution_details doesn't respect date format settings## Overview
_see_ #4503 for similar issue
## Reproduction steps
1. Set localization settings **date format** to "%d.%m.%Y %H:%M" / "%d.%m.%Y"
2. Click on **Reports -\> Contribution Detail**
3. Click on "Refresh results" and/or downloa...## Overview
_see_ #4503 for similar issue
## Reproduction steps
1. Set localization settings **date format** to "%d.%m.%Y %H:%M" / "%d.%m.%Y"
2. Click on **Reports -\> Contribution Detail**
3. Click on "Refresh results" and/or download pdf
## Current behaviour
For the header, the localisation settings are interpreted correctly.
For the report lines, the date format don't respect the localisation settings.
See screenshot:
![contribution details date format.png](/uploads/453ea5f2249edac6e89ff322862c7a8d/contribution_details_date_format.png)
## Expected behaviour
All dates should be displayed in the selected localisation format.
##https://lab.civicrm.org/dev/core/-/issues/4503Localization: Report contribution_details doesn't respect money settings for ...2023-08-17T14:22:38ZDetlev SieberLocalization: Report contribution_details doesn't respect money settings for additional fields## Reproduction steps
1. Set localization settings: **decimal separator** to `,` and **thousand separator** to `.`
2. Click on **Reports -\> Contribution Detail**
3. Select Non-deductible Amount, Fee Amount, Net Amount, Soft Credit Amou...## Reproduction steps
1. Set localization settings: **decimal separator** to `,` and **thousand separator** to `.`
2. Click on **Reports -\> Contribution Detail**
3. Select Non-deductible Amount, Fee Amount, Net Amount, Soft Credit Amount
4. Click on "Refresh results"
## Current behaviour
For the contribution amount, the localisation settings are interpreted correctly.
The other amounts don't respect the localisation settings.
See screenshot:
![2023-08-16_21-13.png](/uploads/ea63065ddba5bb00ce85c2cd77074cae/2023-08-16_21-13.png)
## Expected behaviour
All amounts should be displayed in the selected localisation format.https://lab.civicrm.org/dev/core/-/issues/2628Contribution Detail Report Select County2023-08-15T05:03:14ZandyburnsContribution Detail Report Select CountyThis report `CRM_Report_Form_Contribute_Detail`, and any reports based on it, have the order of Country, State, County wrong. It allows you to select the County first, then State, then Country. e.g. There are 12 entries for Douglas Count...This report `CRM_Report_Form_Contribute_Detail`, and any reports based on it, have the order of Country, State, County wrong. It allows you to select the County first, then State, then Country. e.g. There are 12 entries for Douglas County in Colorado, USA, and choosing the wrong one returns no donations. The order of these fields needs to be reversed, so that only the counties in the selected state are shown and this would match how Advanced Search works.
![image](/uploads/c3a5ae49d598a698df9d6423298decba/image.png)
Revised order:
1. Country
1. State/Province
1. Countyhttps://lab.civicrm.org/dev/core/-/issues/2595Change Log Tab Excrutiatingly Slow - Poorly Performing Query and Fix (from 8 ...2023-08-14T13:09:44ZgordanChange Log Tab Excrutiatingly Slow - Poorly Performing Query and Fix (from 8 minutes down to 4 seconds)The page takes about 8 minutes to return which is absurdly slow for anything expected to be remotely interactive. It is so slow that my client is referring to it as the "Triangle of Doom".
I tracked it down to this query:
```
INSERT IG...The page takes about 8 minutes to return which is absurdly slow for anything expected to be remotely interactive. It is so slow that my client is referring to it as the "Triangle of Doom".
I tracked it down to this query:
```
INSERT IGNORE INTO civicrm_tmp_e_logsummary_ffa3ac146126d178ade367f2a5d17bf5
SELECT activity_id, IF (entity_log_civireport.log_action = 'Insert' AND extra_table.activity_type_id = 51 , GROUP_CONCAT(entity_log_civireport.contact_id), 1) , entity_log_civireport.log_action as log_civicrm_entity_log_action, 'log_civicrm_activity_contact' as log_civicrm_entity_log_type, entity_log_civireport.log_user_id as log_civicrm_entity_log_user_id, entity_log_civireport.log_date as log_civicrm_entity_log_date, modified_contact_civireport.display_name as log_civicrm_entity_altered_contact, modified_contact_civireport.id as log_civicrm_entity_altered_contact_id, entity_log_civireport.log_conn_id as log_civicrm_entity_log_conn_id, modified_contact_civireport.is_deleted as log_civicrm_entity_is_deleted, altered_by_contact_civireport.display_name as altered_by_contact_display_name
FROM staging_civicrm.log_civicrm_activity_contact entity_log_civireport
JOIN civicrm_contact modified_contact_civireport ON (entity_log_civireport.contact_id = modified_contact_civireport.id )
JOIN staging_civicrm.log_civicrm_activity extra_table ON extra_table.id = entity_log_civireport.activity_id
LEFT JOIN civicrm_contact altered_by_contact_civireport ON (entity_log_civireport.log_user_id = altered_by_contact_civireport.id)
WHERE modified_contact_civireport.id = 338520 AND
entity_log_civireport.log_action != 'Initialization'
GROUP BY entity_log_civireport.log_conn_id,
entity_log_civireport.log_user_id,
EXTRACT(DAY_MICROSECOND FROM entity_log_civireport.log_date),
entity_log_civireport.id
ORDER BY entity_log_civireport.log_date DESC;
EXPLAIN shows:
```
```
+------+-------------+-------------------------------+--------+---------------+---------+---------+---------------------------------------------------+---------+-------------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+-------------------------------+--------+---------------+---------+---------+---------------------------------------------------+---------+-------------------------------------------------+
| 1 | SIMPLE | modified_contact_civireport | const | PRIMARY | PRIMARY | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | extra_table | ALL | NULL | NULL | NULL | NULL | 3014020 | |
| 1 | SIMPLE | entity_log_civireport | ALL | NULL | NULL | NULL | NULL | 5518537 | Using where; Using join buffer (flat, BNL join) |
| 1 | SIMPLE | altered_by_contact_civireport | eq_ref | PRIMARY | PRIMARY | 4 | staging_civicrm.entity_log_civireport.log_user_id | 1 | Using where |
+------+-------------+-------------------------------+--------+---------------+---------+---------+---------------------------------------------------+---------+-------------------------------------------------+
```
The fix passes:
First pass:
```
ALTER TABLE log_civicrm_activity_contact ADD INDEX index_activity_id (activity_id);
```
With no further changes, this alone makes the above query go from 8 minutes to 1m45s.
Explain plain:
```
+------+-------------+-------------------------------+--------+-------------------+-------------------+---------+---------------------------------------------------+---------+---------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+-------------------------------+--------+-------------------+-------------------+---------+---------------------------------------------------+---------+---------------------------------+
| 1 | SIMPLE | modified_contact_civireport | const | PRIMARY | PRIMARY | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | extra_table | ALL | NULL | NULL | NULL | NULL | 3014020 | Using where |
| 1 | SIMPLE | entity_log_civireport | ref | index_activity_id | index_activity_id | 5 | staging_civicrm.extra_table.id | 1 | Using where |
| 1 | SIMPLE | altered_by_contact_civireport | eq_ref | PRIMARY | PRIMARY | 4 | staging_civicrm.entity_log_civireport.log_user_id | 1 | Using where |
+------+-------------+-------------------------------+--------+-------------------+-------------------+---------+---------------------------------------------------+---------+---------------------------------+
```
Second pass:
```
ALTER TABLE log_civicrm_activity ADD INDEX index_id (id);
```
Change the JOIN order explicitly and add a hint for the query optimizer to not re-order the JOINs:
```
SELECT STRAIGHT_JOIN activity_id, IF (entity_log_civireport.log_action = 'Insert' AND extra_table.activity_type_id = 51 , GROUP_CONCAT(entity_log_civireport.contact_id), 1) , entity_log_civireport.log_action as log_civicrm_entity_log_action, 'log_civicrm_activity_contact' as log_civicrm_entity_log_type, entity_log_civireport.log_user_id as log_civicrm_entity_log_user_id, entity_log_civireport.log_date as log_civicrm_entity_log_date, modified_contact_civireport.display_name as log_civicrm_entity_altered_contact, modified_contact_civireport.id as log_civicrm_entity_altered_contact_id, entity_log_civireport.log_conn_id as log_civicrm_entity_log_conn_id, modified_contact_civireport.is_deleted as log_civicrm_entity_is_deleted, altered_by_contact_civireport.display_name as altered_by_contact_display_name
FROM civicrm_contact modified_contact_civireport
JOIN staging_civicrm.log_civicrm_activity_contact entity_log_civireport ON entity_log_civireport.contact_id = modified_contact_civireport.id
JOIN staging_civicrm.log_civicrm_activity extra_table ON extra_table.id = entity_log_civireport.activity_id
LEFT JOIN civicrm_contact altered_by_contact_civireport ON entity_log_civireport.log_user_id = altered_by_contact_civireport.id
WHERE modified_contact_civireport.id = 338520 AND
entity_log_civireport.log_action != 'Initialization'
GROUP BY entity_log_civireport.log_conn_id,
entity_log_civireport.log_user_id,
EXTRACT(DAY_MICROSECOND FROM entity_log_civireport.log_date),
entity_log_civireport.id
ORDER BY entity_log_civireport.log_date DESC;
```
New EXPLAIN:
```
+------+-------------+-------------------------------+--------+-------------------+----------+---------+---------------------------------------------------+---------+---------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+-------------------------------+--------+-------------------+----------+---------+---------------------------------------------------+---------+---------------------------------+
| 1 | SIMPLE | modified_contact_civireport | const | PRIMARY | PRIMARY | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | entity_log_civireport | ALL | index_activity_id | NULL | NULL | NULL | 5518537 | Using where; Using filesort |
| 1 | SIMPLE | extra_table | ref | index_id | index_id | 5 | staging_civicrm.entity_log_civireport.activity_id | 1 | |
| 1 | SIMPLE | altered_by_contact_civireport | eq_ref | PRIMARY | PRIMARY | 4 | staging_civicrm.entity_log_civireport.log_user_id | 1 | Using where |
+------+-------------+-------------------------------+--------+-------------------+----------+---------+---------------------------------------------------+---------+---------------------------------+
```
This gets it down to 4 seconds!
Since the first index we started with is no longer getting used in the final variant, we can just not add it.
Summary:
To fix "Change Log" tab taking forever to load, the following fix is needed:
Add index:
```
ALTER TABLE log_civicrm_activity ADD INDEX index_id (id);
```
Make the code emit the query modified as follows:
```
INSERT IGNORE INTO civicrm_tmp_e_logsummary_ffa3ac146126d178ade367f2a5d17bf5
SELECT STRAIGHT_JOIN activity_id, IF (entity_log_civireport.log_action = 'Insert' AND extra_table.activity_type_id = 51 , GROUP_CONCAT(entity_log_civireport.contact_id), 1) , entity_log_civireport.log_action as log_civicrm_entity_log_action, 'log_civicrm_activity_contact' as log_civicrm_entity_log_type, entity_log_civireport.log_user_id as log_civicrm_entity_log_user_id, entity_log_civireport.log_date as log_civicrm_entity_log_date, modified_contact_civireport.display_name as log_civicrm_entity_altered_contact, modified_contact_civireport.id as log_civicrm_entity_altered_contact_id, entity_log_civireport.log_conn_id as log_civicrm_entity_log_conn_id, modified_contact_civireport.is_deleted as log_civicrm_entity_is_deleted, altered_by_contact_civireport.display_name as altered_by_contact_display_name
FROM civicrm_contact modified_contact_civireport
JOIN staging_civicrm.log_civicrm_activity_contact entity_log_civireport ON entity_log_civireport.contact_id = modified_contact_civireport.id
JOIN staging_civicrm.log_civicrm_activity extra_table ON extra_table.id = entity_log_civireport.activity_id
LEFT JOIN civicrm_contact altered_by_contact_civireport ON entity_log_civireport.log_user_id = altered_by_contact_civireport.id
WHERE modified_contact_civireport.id = 338520 AND
entity_log_civireport.log_action != 'Initialization'
GROUP BY entity_log_civireport.log_conn_id,
entity_log_civireport.log_user_id,
EXTRACT(DAY_MICROSECOND FROM entity_log_civireport.log_date),
entity_log_civireport.id
ORDER BY entity_log_civireport.log_date DESC;
```
Not only does this speed it up from 8 minutes down to 4 seconds, it also doesn't wreak havoc with row locking where every row scanned gets locked by the transaction engine, potentially resulting in a massive query pile-up in the database.https://lab.civicrm.org/dev/core/-/issues/2557Add hook support for Report tabs.2023-08-06T05:03:24ZyashodhaAdd hook support for Report tabs.Add hook support for Report tabs.Add hook support for Report tabs.yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/2526Misleading error message about permissions when CiviReport disabled2023-07-27T05:03:20ZphilmckMisleading error message about permissions when CiviReport disabledOverview
----------------------------------------
If the CiviReport component is disabled (System Settings > Components) and you try to view the result of a completed mailing (Mailings > Scheduled and Sent Mailings > [Choose mailing] > R...Overview
----------------------------------------
If the CiviReport component is disabled (System Settings > Components) and you try to view the result of a completed mailing (Mailings > Scheduled and Sent Mailings > [Choose mailing] > Report > [Various "Report" links]) a misleading error message "You do not have permission to access this page" is displayed. The error log in /wp-content/uploads/civicrm/ConfigAndLog/ shows a fatal error with a CRM_Core_Error::handleUnhandledException but no clue as to the origin.
Reproduction steps
----------------------------------------
1. Disable the CiviReport component at System Settings > Components
2. Choose a completed mailing in Mailings > Scheduled and Sent Mailings and click "Report"
3. Select any of the "Report" links (e.g. for Click-throughs)
4. Error "You do not have permission to access this page" is displayed.
Current behaviour
----------------------------------------
Error "You do not have permission to access this page" is displayed. Log shows CRM_Core_Error::handleUnhandledException.
Expected behaviour
----------------------------------------
This exception is nothing to do with permissions - I wasted an hour or so checking all the permissions settings and googling for previous reports and I'm sure I'm not the only one. I was logged in as an Administrator and so permissions shouldn't have been an issue and I wouldn't expect an Administrator or Super User to ever see that message.
I would expect a more informative error message about the disabled ~~CviRules~~ CiviReport component. Even better, the "Report" links could be disabled and replaced with help information if the required component is not enabled. In addition, it should be impossible to disable the component if core functionality depends on it.
Environment information
----------------------------------------
* __Browser:__ Chrome 89
* __CiviCRM:__ 5.36.0
* __PHP:__ 7.4
* __CMS:__ WordPress 5.7
* __Database:__ MariaDB 10.4.18
* __Web Server:__ Apache 2.4.46https://lab.civicrm.org/dev/core/-/issues/2472DB error on Contribution Details2023-07-11T05:03:29ZyashodhaDB error on Contribution DetailsSteps to replicate :
- Go to _Contribution Details_
- In sorting tab, set _Contribution Status_ asc/dsc and in filter _Contribution OR Soft Credit?_ to _Both_
![Screenshot_from_2021-03-23_10_26_02](/uploads/2f0ba79c0657555c06f73db79acf8...Steps to replicate :
- Go to _Contribution Details_
- In sorting tab, set _Contribution Status_ asc/dsc and in filter _Contribution OR Soft Credit?_ to _Both_
![Screenshot_from_2021-03-23_10_26_02](/uploads/2f0ba79c0657555c06f73db79acf8397/Screenshot_from_2021-03-23_10_26_02.png)
![Screenshot_from_2021-03-23_10_26_17](/uploads/09810cb980275a522883f17fe43297f2/Screenshot_from_2021-03-23_10_26_17.png)
- Run the report, and DB error appears!
![error](/uploads/3ab78a1a830f1076bd8aca48c21f76e4/error.png)https://lab.civicrm.org/dev/core/-/issues/4401SearchKit - Report replacement - as a standard user without edit searchkit pe...2023-07-06T06:37:04ZsamuelsovSearchKit - Report replacement - as a standard user without edit searchkit permission, add a way to show/hide columns in table displayThere is already an [extension](https://lab.civicrm.org/extensions/search_kit_reports) that recreate the queries of core reports into SearchKit so admin/super user can customize and use them instead of report.
However, as a standard use...There is already an [extension](https://lab.civicrm.org/extensions/search_kit_reports) that recreate the queries of core reports into SearchKit so admin/super user can customize and use them instead of report.
However, as a standard user, edit a Searchkit is too complicated and reports is still the better option if we need to provide a lot of flexibility to users.
Currently, in Reports, standard user have access to customize :
- Columns - no way to do this in SK without editing the SK - hence the proposal
- Sorting - already there by clicking on the columns of the SK table
- Filters - already there by configuring them with FormBuilder
- Title and Format - don't think it is required
- Email delivery - missing, already documented in https://lab.civicrm.org/dev/core/-/issues/3478
So I think the main undocumented missing feature if we want to replace the reports is to have a way for a standard user to choose which columns to show/hide in a table display. It needs to apply to the screen and to the Download action.
As an example, I like the way new reports in Quickbooks works with the ability to switch each column on/off and as a bonus allow to change columns order :
![Rapport](/uploads/550ef9e7d7ffd1f19849b4034faa7765/Rapport.png)
As a first step, I don't think we need to save the user preferences but we will probably want to be able to do that / reset to default eventually.https://lab.civicrm.org/dev/core/-/issues/2441Print Report from Manage Case for closed cases doesn't show roles properly2023-07-06T05:03:18ZDaveDPrint Report from Manage Case for closed cases doesn't show roles properlyIt's not identical to https://lab.civicrm.org/dev/core/-/issues/1948 but might be the same underlying reason.
1. Create a case.
2. Add some roles.
3. Close the Case.
4. Choose Print Report on Manage Case.
5. Look at the roles near the t...It's not identical to https://lab.civicrm.org/dev/core/-/issues/1948 but might be the same underlying reason.
1. Create a case.
2. Add some roles.
3. Close the Case.
4. Choose Print Report on Manage Case.
5. Look at the roles near the top - they should be there.
Ditto for the Activity Audit which is the same codebase as Print Report.https://lab.civicrm.org/dev/core/-/issues/2445Soft Credit Type does not display in Contribution Detail report2023-07-05T05:03:18ZyashodhaSoft Credit Type does not display in Contribution Detail reportThe value for _Soft Credit Type_ is missing in _Contribution Detail_ report.
![missing_soft_credit_type](/uploads/3b85264817fa79fe1c993ec4a0de80eb/missing_soft_credit_type.png)The value for _Soft Credit Type_ is missing in _Contribution Detail_ report.
![missing_soft_credit_type](/uploads/3b85264817fa79fe1c993ec4a0de80eb/missing_soft_credit_type.png)yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/1948Print Report from Manage Case shows relationships from client's other cases2023-07-03T18:38:08ZDaveDPrint Report from Manage Case shows relationships from client's other casesNot sure yet when it started.
1. Create two cases for a client with different case managers assigned.
2. Click on Print Report on Manage Case for either case.
3. It lists the case manager from the other case in the Client Relationships ...Not sure yet when it started.
1. Create two cases for a client with different case managers assigned.
2. Click on Print Report on Manage Case for either case.
3. It lists the case manager from the other case in the Client Relationships section.https://lab.civicrm.org/dev/core/-/issues/2376Related Contributions for recurring contributions not sorted on date2023-06-26T05:03:16ZyashodhaRelated Contributions for recurring contributions not sorted on dateSteps to replicate :
- Go to Recurring Contributions tab for a contact with recurring contributions in place.
- Click _View_ for Recurring Contribution
- Go to _Related Contributions_ section and click the _Received_ column header.
- I...Steps to replicate :
- Go to Recurring Contributions tab for a contact with recurring contributions in place.
- Click _View_ for Recurring Contribution
- Go to _Related Contributions_ section and click the _Received_ column header.
- It is sorted on alphabetic order not date
![related_recurring](/uploads/6e6e03467a8aa3417f9d3c372d6adf63/related_recurring.png)