Development issueshttps://lab.civicrm.org/groups/dev/-/issues2022-04-07T15:07:59Zhttps://lab.civicrm.org/dev/core/-/issues/2980Automated Messages (mostly) don't respect is_active, default2022-04-07T15:07:59ZJonGoldAutomated Messages (mostly) don't respect is_active, defaultMany automated messages (unsubscribe, resubscribe, etc.) ignore the "is_default" and "is_active" flags on `civicrm_mailing_component`.
### Steps to Replicate
* Go to **Mailings » Headers, Footers, Automated Messages**.
* Disable the Uns...Many automated messages (unsubscribe, resubscribe, etc.) ignore the "is_default" and "is_active" flags on `civicrm_mailing_component`.
### Steps to Replicate
* Go to **Mailings » Headers, Footers, Automated Messages**.
* Disable the Unsubscribe message.
* Unsubscribe from a mailing.
### Expected Behavior
No email.
### Actual Behavior
Email.
Once I dug in, I saw that *some* code was filtering for is_active/is_default, but the copy/paste nature meant most weren't. I refactored the automated messages to take advantage of a common retrieval function.JonGoldJonGoldhttps://lab.civicrm.org/dev/core/-/issues/2979Proposal to remove the limit of 15 max values for multiple values can also be...2021-12-09T16:28:04ZyashodhaProposal to remove the limit of 15 max values for multiple values can also be retrieved from url in reportsWe send the parameters as string so that multiple values can also be retrieved from url in reports
for e.g url like - "memtype_in=in&memtype_value=1,2,3
However, there is a restriction for 15 values esp when you search for activity type...We send the parameters as string so that multiple values can also be retrieved from url in reports
for e.g url like - "memtype_in=in&memtype_value=1,2,3
However, there is a restriction for 15 values esp when you search for activity types which can be numerous. In this this case, if the values exceeds 15 the criteria are not respected.
Proposal to remove the limit of 15 max values.
https://github.com/civicrm/civicrm-core/blob/master/CRM/Report/Utils/Get.php#L1735.46.0yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/2978usability: checkboxes weren't visible until I added a valid URL in formbuilder2023-10-28T05:03:26ZMichael McAndrewusability: checkboxes weren't visible until I added a valid URL in formbuilder![image](/uploads/160c8b7d3d79a06624b36be8754b2a38/image.png)
I was trying to work out how to make a form accessible from the front end of a site.
The checkbox I was looking for was hidden until I added a valid URL which is bad for dis...![image](/uploads/160c8b7d3d79a06624b36be8754b2a38/image.png)
I was trying to work out how to make a form accessible from the front end of a site.
The checkbox I was looking for was hidden until I added a valid URL which is bad for discoverability of functionality.
It might be better handled in validation.
See https://chat.civicrm.org/civicrm/pl/zswjsq6hgfftfda1o5asg8wxyh for more.https://lab.civicrm.org/dev/core/-/issues/2977When adding custom data set change default selected option2021-12-14T22:43:19ZBarijohnWhen adding custom data set change default selected optionOverview
----------------------------------------
Currently when adding a custom data set I always swap the default settings for showing the set. So I untick the Collapse this set on initial display and tick Collapse this set in Advanced...Overview
----------------------------------------
Currently when adding a custom data set I always swap the default settings for showing the set. So I untick the Collapse this set on initial display and tick Collapse this set in Advanced Search.
In my experience if I kept the default settings my Advanced Search can get out of control quite quickly but when looking at a summary page I have to keep clicking to open up the data set.
Current behaviour
----------------------------------------
![Screenshot_2021-12-02_at_13.32.34](/uploads/0ddb75a1bfa2571771c69fdd1a923e17/Screenshot_2021-12-02_at_13.32.34.png)
Proposed behaviour
----------------------------------------
![Screenshot_2021-12-02_at_13.32.57](/uploads/3de94103ee8053082d5da96bac3f092c/Screenshot_2021-12-02_at_13.32.57.png)
Comments
----------------------------------------
This might be something unique to how I like to set custom data sets up. So would be good to find the community consensus.5.46.0https://lab.civicrm.org/dev/core/-/issues/2976Feature Request: Form Builder and Permissions - Provide ability to restrict a...2023-11-02T12:39:11Zjustinfreeman (Agileware)Feature Request: Form Builder and Permissions - Provide ability to restrict access to selected Roles rather than just specific Permission GrantsWould be great if the Form Builder, Permissions had the ability to restrict access to selected Roles rather than just specific Permission Grants.
Roles being far more flexible, can be automatically granted and removed for user accounts ...Would be great if the Form Builder, Permissions had the ability to restrict access to selected Roles rather than just specific Permission Grants.
Roles being far more flexible, can be automatically granted and removed for user accounts and this is a common pattern on Member websites. Whereas Permission Grants are not used in this way.
For example: When a user with the Member role views a Form Builder page, they are granted access to use the Form and view the Search Results because they have the Member role.
![Screenshot_20211202_130808](/uploads/25c2fbadece5eea59beb05d7b269e937/Screenshot_20211202_130808.png)
Agileware Ref: CIVICRM-1899https://lab.civicrm.org/dev/core/-/issues/2975Drupal8/composer: upgrading do not move vendor files to the library folder2024-03-25T05:03:19ZcalbasiDrupal8/composer: upgrading do not move vendor files to the library folderOverview
----------------------------------------
I've upgraded from civicrm 5.36 to 5.43 using composer. I have no composer nor database errors but website menu, panels, etc. are not shown.
It seems some library files are missing on l...Overview
----------------------------------------
I've upgraded from civicrm 5.36 to 5.43 using composer. I have no composer nor database errors but website menu, panels, etc. are not shown.
It seems some library files are missing on libraries folder (but not at vendor folder). Copying some of them from vendor to library folder solves inspector errors...
Reproduction steps
----------------------------------------
1. Upgrade the code:
- composer update civicrm/civicrm-{core,packages,drupal-8} --with-dependencies
- update database
Current behaviour
----------------------------------------
Website don't load menu, panels, floating panels. Just the most basic info (html).
The inspector show errors (a couple of library files are missing)
```
The resource from “https://my_domain/libraries/civicrm/core/ang/resetLocationProviderHashPrefix.js?r=ZdPSJ” was blocked due to MIME type (“text/html”) mismatch (X-Content-Type-Options: nosniff).
The resource from “https://my_domain/libraries/civicrm/core/js/crm-angularjs-loader.js?r=ZdPSJ” was blocked due to MIME type (“text/html”) mismatch (X-Content-Type-Options: nosniff).
The resource from “https://my_domain/libraries/civicrm/core/ang/resetLocationProviderHashPrefix.js?r=ZdPSJ” was blocked due to MIME type (“text/html”) mismatch (X-Content-Type-Options: nosniff).
Loading failed for the <script> with source “https://my_domain/libraries/civicrm/core/ang/resetLocationProviderHashPrefix.js?r=ZdPSJ”.
The resource from “https://my_domain/libraries/civicrm/core/js/crm-angularjs-loader.js?r=ZdPSJ” was blocked due to MIME type (“text/html”) mismatch (X-Content-Type-Options: nosniff).
```
After copy the missing errors:
```
cp js/crm-angularjs-loader.js /var/www/my_website/web/web/libraries/civicrm/core/js/
cp resetLocationProviderHashPrefix.js /var/www/my_website/web/web/libraries/civicrm/core/ang/
```
I think the composer info is OK:
```
"extra": {
"installer-paths": {
"web/core": ["type:drupal-core"],
"web/libraries/{$name}": ["type:drupal-library"],
```
In fact, vendor/civicrm/civicrm-core has updated files, but not /libraries/civicrm/core
Environment information
----------------------------------------
* __CiviCRM:__ _5.43.2_ <!-- If this problem relates to an upgrade, then specify both old and new versions -->
* __OS:__ _Debian 10__
* __PHP:__ _7.3__
* __CMS:__ _Drupal 8 (updated version)..._
* __Database:__ _MariaDB_
* __Web Server:__ _Apache 2_https://lab.civicrm.org/dev/core/-/issues/2974Membership status update breaks if override is removed2021-12-02T05:48:05ZJonGoldMembership status update breaks if override is removed### Steps to replicate
* Open a membership whose status should be "New" or "Current".
* Override the membership so the status is "Expired".
* Remove the override status and save.
### Expected Behavior
Membership returns to its normal st...### Steps to replicate
* Open a membership whose status should be "New" or "Current".
* Override the membership so the status is "Expired".
* Remove the override status and save.
### Expected Behavior
Membership returns to its normal status.
### Actual Behavior
Membership retains its override status, with no way to fix except with another override.
Additionally, the "Update Memberships" scheduled job doesn't work
This is a regression in 5.42, which I've tracked down to https://github.com/civicrm/civicrm-core/pull/20976.
I'm thinking the solution would be to clear the `status_id` when removing an override (likely with JS at the form level) but I'm not clear on the reason for the change so I'll let wiser heads prevail.5.44.0https://lab.civicrm.org/dev/core/-/issues/2973Custom fields all broken2021-12-01T03:19:28ZDaveDCustom fields all brokenMust be pretty recent. Noticed it locally and confirmed on dmaster.demo.
The fields are unusable on any entity edit form and all say NULL.
![Untitled](/uploads/3ec5d44c1d954956076f9e9a5f208892/Untitled.png)Must be pretty recent. Noticed it locally and confirmed on dmaster.demo.
The fields are unusable on any entity edit form and all say NULL.
![Untitled](/uploads/3ec5d44c1d954956076f9e9a5f208892/Untitled.png)5.45.0https://lab.civicrm.org/dev/core/-/issues/2972track CiviMail metrics by mailing group2023-10-24T05:03:27Zhescotrack CiviMail metrics by mailing groupOverview
----------------------------------------
_Please describe your improvement in detail._
As a user of CiviMail, when examining the delivery and performance metrics on a mailing which was sent to multiple mailing groups, I should ...Overview
----------------------------------------
_Please describe your improvement in detail._
As a user of CiviMail, when examining the delivery and performance metrics on a mailing which was sent to multiple mailing groups, I should be able to exclude mailing groups from the metrics for that mailing to observe how each mailing group a recipient of a mailing is performing. In the recipients section of the report, each group should be associated with a checkbox which will control whether an included (or excluded ???) group is accounted for in the metrics displayed in a view of the report.
Example use-case
----------------------------------------
At this url, and those which I can drill down to from here:
/civicrm/mailing/report?mid=${mailing_id}&reset=1
by toggling on or off checkboxes and hitting a refresh button, I should be able to update a the metrics on the report view; and any view accessible by drilling down through the available links and buttons, should clearly indicate which mailing groups are accounted for by the metrics displayed on that drilled-down-to view.
Current behaviour
----------------------------------------
_What is currently possible? What limit ?_
Currently to achieve this level of granularity in the reporting views I have to create multiple mailings, being careful in how I set them up to exclude mailing groups which were included on previous mailings. This works, but is unnecessarily cumbersome to set up; and to track the results, cluttering my browser with multiple open tabs to monitor results on the multiple mailings.
Proposed behaviour
----------------------------------------
_What should happen? How is this better? If appropriate/available, include any wireframes or mockups._
I would rather have a single mailing defined by its content, and the ability to parse the metrics on that mailing by recipient mailing group by toggling checkboxes.
Comments
----------------------------------------
_Anything else you would like the reviewer to note._
Thanks again.https://lab.civicrm.org/dev/core/-/issues/2971file attachments and descriptions should persist across a copy from source t...2023-10-25T05:03:22Zhescofile attachments and descriptions should persist across a copy from source to new bulk emailOverview
----------------------------------------
_Please describe your improvement in detail._
As a user configuring a CiviMail 'bulk email', when I copy a previous email to create a new email, I want the attachments associated with th...Overview
----------------------------------------
_Please describe your improvement in detail._
As a user configuring a CiviMail 'bulk email', when I copy a previous email to create a new email, I want the attachments associated with the previous email to be attached by default to the new email; perhaps with a modal asking me for confirmation that that remains my intention.
Example use-case
----------------------------------------
when I use the copy action for a
previously delivered bulk email, at this url:
/civicrm/mailing/browse/scheduled?reset=1&scheduled=true
or a previously configured bulk email
pending delivery at this url:
/civicrm/mailing/browse/unscheduled?reset=1&scheduled=false
It takes an email configured at this url:
/civicrm/mailing/send?mid=${delivered_or_configured_email_id}&reset=1
using it to create a copy at this url:
/civicrm/mailing/send?mid=${new_email_id}&reset=1
but fails to copy the attachments which may have been
configured as a part of the previously delivered or configured email.
Current behaviour
----------------------------------------
_What is currently possible? What limit ?_
Currently I have to re-upload and re-describe each attachment on the copies.
Proposed behaviour
----------------------------------------
_What should happen? How is this better? If appropriate/available, include any wireframes or mockups._
The file and its description should be copied from the source onto the new bulk email without further human intervention, save possibly confirmation of my intent to persist the attachment by answering a modal prompt.
I often create multiple mailings from the same content so that I get to watch the metrics on each mailing recipient group, isolated from the rest of the mailing.
Comments
----------------------------------------
_Anything else you would like the reviewer to note._https://lab.civicrm.org/dev/core/-/issues/2970A CiviMail template should accept an attachment which persists between uses2023-10-25T05:03:23ZhescoA CiviMail template should accept an attachment which persists between usesOverview
----------------------------------------
_Please describe your improvement in detail._
As a site administrator, when creating a mailing template, I should be able to associate an attachment with a template to avoid the overhead...Overview
----------------------------------------
_Please describe your improvement in detail._
As a site administrator, when creating a mailing template, I should be able to associate an attachment with a template to avoid the overhead of re-uploading and attaching the file to an outbound email every time I use that template.
Example use-case
----------------------------------------
When I am at one of these url's:
/civicrm/admin/messageTemplates/add?action=add&reset=1
/civicrm/admin/messageTemplates/add?action=update&id=${template_id}&reset=1
I should be able to upload and attach a file to the template, and have that file persist on the server to be attached to each and every outbound email I create with that template.
Current behaviour
----------------------------------------
_What is currently possible? What limit ?_
Currently I have to remember to re-upload and re-attach my file EVERY time I re-use a template.
Proposed behaviour
----------------------------------------
_What should happen? How is this better? If appropriate/available, include any wireframes or mockups._
This will avoid redundant work for the person using the template.
Comments
----------------------------------------
_Anything else you would like the reviewer to note._
Thanks again!https://lab.civicrm.org/dev/core/-/issues/2969Resending a CiviMailing to an individual, without creating new mailing2023-10-29T05:03:28ZhescoResending a CiviMailing to an individual, without creating new mailingOverview
----------------------------------------
_Please describe your improvement in detail._
As a user, examining a CiviMailing Report, or an activity related to a contact's record, I would like to resend a previously sent CiviMailin...Overview
----------------------------------------
_Please describe your improvement in detail._
As a user, examining a CiviMailing Report, or an activity related to a contact's record, I would like to resend a previously sent CiviMailing without having to copy it and clutter my archives with multiple versions; and without having to first convert an old mailing into a template.
Example use-case
----------------------------------------
If I am at one of these urls:
/civicrm/mailing/report/event?reset=1&mid=${mailing_id}&event=opened
/civicrm/mailing/report/event?reset=1&mid=${mailing_id}&event=delivered
/civicrm/contact/view?reset=1&cid=5&key=......&context=smog
I would appreciate an action option or some similar means to trigger resending a previously sent 'Bulk Email'. I should have the opportunity to edit the email before it is resent, including the opportunity to add an attachment if necessary. Sending the duplicate should be recorded on the contact record as an activity, perhaps identified as a 'Resent Bulk Email'.
Current behaviour
----------------------------------------
_What is currently possible? What limit ?_
My current work-arounds are to clutter my user generated templates for this purpose; or to forward a copy of the email in question which I may have sent myself, or to copy the previous 'bulk email' from the delivered queue and resend it to only a single recipient, or to send them a test email from a copy of the previously sent CiviMail, and then abandon the copy without saving it to clutter the queue.
Proposed behaviour
----------------------------------------
_What should happen? How is this better? If appropriate/available, include any wireframes or mockups._
Often when I am doing phone follow-up on a contact to an email I had previously sent, it is convenient to resend the email so my contact can find it at the top of their inbox while we are still on the phone. The folks I work with get lots of email and frequently lose track of messages sent even a few days ago.
Comments
----------------------------------------
_Anything else you would like the reviewer to note._
My appreciation for an excellent product you folks have created!https://lab.civicrm.org/dev/core/-/issues/2968Dashoard not loading - invalid assets path generated when using symlinks2023-11-09T05:03:25ZfpalewackiDashoard not loading - invalid assets path generated when using symlinksOverview
----------------------------------------
I've just installed 5.43.2 on my local machine and it appears CiviCRM is not resolving SOME assets paths correctly.
At first I thought that it's related to the project placement as my D...Overview
----------------------------------------
I've just installed 5.43.2 on my local machine and it appears CiviCRM is not resolving SOME assets paths correctly.
At first I thought that it's related to the project placement as my Drupal was available at the `dev.test/drupal` path (it needs to be there for one of my projects) - but even after I've moved the project to the domain's root (`dev.test`) it's still **spilling server paths** in the urls generating invalid assets urls in result.
The project files are located at `/vagrant/drupal` on the server
All of this results in empty dashboard page as some of the js/css files are not loaded.
Other CiviCRM pages load semi-correctly but are missing some assets (css/js files) and in result look incomplete/broken
edit:
What I found out is that **this is only happening if the project is symlinked**
I've got the project located at `/vagrant/drupal` and this dir is symlinked as `/var/www/public` and later that symlink is served by apache.
Serve the project directly from the `/vagrant/drupal` then the issue is not occurring.
Not using the symlink is not a solution here.
The issue is not existing on CiviCRM 5.12
Reproduction steps
----------------------------------------
1. Install CiviCRM 5.42/5.43.2
1. Site symlink must be served by the server instead of the real directory
1. Visit the admin dashboard
1. (Optionally) Check the browser's console for errors
1. (Optionally) Check the HTML source for invalid path's
Current behaviour
----------------------------------------
![obraz](/uploads/4cfc90c10f452995cfe09fc7ad1985a0/obraz.png)
![obraz](/uploads/1d8edfa135966ca97ffc71e7f1eff35d/obraz.png)
![obraz](/uploads/3a405a60a8b5d3834507bef46c831bee/obraz.png)
![obraz](/uploads/64b63d1355b3d6dd69de2802593cc0e2/obraz.png)
Expected behaviour
----------------------------------------
- CiviCRM assets paths are resolved correctly,
- No server paths are visible in the HTML source code
- Assets are loaded correctly
- Dashboard page is working correctly
Environment information
----------------------------------------
* __Browser:__ ANY
* __CiviCRM:__ 5.43.2/5.42
* __PHP:__ 7.2/7.3
* __CMS:__ Drupal 7.67
* __Database:__ MySQL 5.7.7
* __Web Server:__ Apache 2.4
Comments
----------------------------------------
This is a fresh install of both Drupal 7 and CiviCRM but I got this issue after upgrading the CiviCRM to 5.42 on my client's server so I started to investigate.
Page was working fine before the upgrade from CiviCRM 5.12 - It was an long overdue upgrade.
Installed 5.12 again locally, it's working just fine, no errors or anything so this must be something with the newer versions
![obraz](/uploads/dbcf99ca4437a6c3a72812086f897943/obraz.png)https://lab.civicrm.org/dev/core/-/issues/2967Multiple elements with same id are generate when honoree section is enabled o...2021-11-24T17:47:49ZKurund JalmiMultiple elements with same id are generate when honoree section is enabled on the contribution pageSteps to replicate
* Enable honoree section for the contribution page
* Add a pre profile to include first name and last name
Visit contribution page and we get 2 div elements with same id. For eg: 'editrow-first_name' and 'editrow-las...Steps to replicate
* Enable honoree section for the contribution page
* Add a pre profile to include first name and last name
Visit contribution page and we get 2 div elements with same id. For eg: 'editrow-first_name' and 'editrow-last_name'
We already have prefix for honoree and can be used to differentiate.5.45.0https://lab.civicrm.org/dev/financial/-/issues/190Proposal: Add `created_id` to `civicrm_contribution`2021-11-23T17:28:24ZJonGoldProposal: Add `created_id` to `civicrm_contribution`This is fairly straightforward as a proposal. I think it's a good idea generally (for those who lack advanced logging) but could also solve financial#49 - it's impossible to know what individual gave on behalf of an organization based o...This is fairly straightforward as a proposal. I think it's a good idea generally (for those who lack advanced logging) but could also solve financial#49 - it's impossible to know what individual gave on behalf of an organization based on the existing data.JonGoldJonGoldhttps://lab.civicrm.org/dev/core/-/issues/2966Duplicate contacts when custom field value is 'email', 'phone', etc.2023-03-18T04:08:01Zrita_compucorpDuplicate contacts when custom field value is 'email', 'phone', etc.**Issue**:
when existing contacts are donating (without being logged in) with the same details (email, first name, last name) that are registered in the system, most of the times there is a new contact created instead of merging it to t...**Issue**:
when existing contacts are donating (without being logged in) with the same details (email, first name, last name) that are registered in the system, most of the times there is a new contact created instead of merging it to the existing contact automatically.
**Investigation**:
When a custom field with a checkbox had its title and value set to ‘email’ or 'phone' and the unsupervised dedupe rule was prepared to check for email or phone as well causing the problem. So the problem occurs when:
- the unsupervised dedupe rule has email in it AND
- the custom field’s value is set to ‘email’
However not only the email option can cause duplications, but if you prepare an:
- unsupervised dedupe rule with phone ![screenshot-dmaster.demo.civicrm.org-2021.11.22-08_34_24](/uploads/758592a6d5330c1133dcd1206e714daa/screenshot-dmaster.demo.civicrm.org-2021.11.22-08_34_24.png) AND
- the custom field’s value is set to ‘phone’ ![screenshot-dmaster.demo.civicrm.org-2021.11.22-08_35_12](/uploads/df40ee69692fda55f51e946b2c841b9d/screenshot-dmaster.demo.civicrm.org-2021.11.22-08_35_12.png)
And even though the clients enter the same email/phone numbers on the donation form, the dedupe rule will be skipped and a new contact with the same information will be created. Probably this can be reproduced with many fields in the system, but only tried these two.
I checked on a few **different civi versions:**
- 4.7.26 - couldn’t reproduce
- 5.35.2 - issue reproducible
- 5.45.alpha1 (core demo civi) - issue reproducible
**Reproduction steps:**
1. create an unsupervised individual rule with the following details: ![screenshot-dmaster.demo.civicrm.org-2021.11.22-08_34_24](/uploads/758592a6d5330c1133dcd1206e714daa/screenshot-dmaster.demo.civicrm.org-2021.11.22-08_34_24.png)
2. create a custom field set for Contacts with checkboxes like this: ![screenshot-dmaster.demo.civicrm.org-2021.11.22-08_35_12](/uploads/df40ee69692fda55f51e946b2c841b9d/screenshot-dmaster.demo.civicrm.org-2021.11.22-08_35_12.png)
3. add the custom field set that you created in previous step to a profile that can be added to a contribution page
4. create a new (or use an old) contribution page and add the profile that you created in previous step to it in the Profiles tab
5. create a new contact, and make sure it has a First name, Last name and Phone number
6. open the contribution page as anonymous and donate to it, using the exact same First name, Last name and Phone number that you entered in previous step AND select the ‘phone’ option at the custom field you created → _after you submit the donation, a new contact will be created instead of merging it to the existing one, which is wrong behaviour_
7. donate again on the same form, with the same details as before, but instead of selecting ‘phone’ select either the ‘email’ or ‘post’ options → _the contribution will be merged to the original contact, which is the correct behaviour. It is because email and post are not added to the unsupervised dedupe rule in this case._
I think most of the time civi admins create custom fields with values set as numbers, but in some cases they might configure it to be the same as the label name and in that case duplications might occur. I think it might be happening when the value of the custom field is the same as the name of the field in the database (just a thought, can't say for sure).https://lab.civicrm.org/dev/core/-/issues/2965APIv4 Explorer, displays the Field Name as the selectable option. However, th...2023-10-23T05:03:22Zjustinfreeman (Agileware)APIv4 Explorer, displays the Field Name as the selectable option. However, the Field Label only is visible in the Custom Fields UI and may be different to the Field NameAPIv4 Explorer, displays the Field Name as the selectable option. However, the Field Label only is visible in the Custom Fields UI and may be different to the Field Name.
SearchKit on the other hand does use the Field Label to list the ...APIv4 Explorer, displays the Field Name as the selectable option. However, the Field Label only is visible in the Custom Fields UI and may be different to the Field Name.
SearchKit on the other hand does use the Field Label to list the available fields.
This can make it very difficult to use the APIv4 Explorer to select the correct fields if:
1. There are a large number of fields, and
2. The Field Name differs from the Field Label
This is a very common occurrence on older CiviCRM sites which tend to have fields that have been renamed over time and have a lot of old fields still active on the site.
My preference would be to always list the Field Label when displaying fields in the APIv4 Explorer.
![Screenshot_20211123_084139](/uploads/b71225e09f100a8e78d2c321a05704d1/Screenshot_20211123_084139.png)
Agileware Ref: CIVICRM-1890https://lab.civicrm.org/dev/core/-/issues/2964"DB Error: no such field" in civicrm-core/Civi/ActionSchedule/RecipientBuilde...2023-10-26T05:03:27Zmagnolia61"DB Error: no such field" in civicrm-core/Civi/ActionSchedule/RecipientBuilder.phpI my log files i notice an error when running the scheduled reminder cron for activities.
```
[db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="INSERT INTO civi...I my log files i notice an error when running the scheduled reminder cron for activities.
```
[db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="INSERT INTO civicrm_action_log (contact_id, entity_id, entity_table, action_schedule_id)
SELECT r.contact_id as contact_id, e.id as entity_id, "civicrm_activity" as entity_table, 131 as action_schedule_id
FROM civicrm_activity e
INNER JOIN civicrm_contact c ON c.id = r.contact_id AND c.is_deleted = 0 AND c.is_deceased = 0
LEFT JOIN civicrm_action_log reminder ON reminder.contact_id = r.contact_id AND
reminder.entity_id = e.id AND
reminder.entity_table = 'civicrm_activity' AND
reminder.action_schedule_id = 131
WHERE (e.activity_type_id IN (119)) AND (e.status_id IN (4)) AND (e.is_current_revision = 1 AND e.is_deleted = 0) AND (reminder.id IS NULL) AND ('20211121085238' >= DATE_SUB(e.activity_date_time, INTERVAL 16 day)) AND (DATE_SUB(20211121085238, INTERVAL 1 DAY ) <= DATE_SUB(e.activity_date_time, INTERVAL 16 day)) AND ('2020-12-31 23:00:00' <= DATE_SUB(e.activity_date_time, INTERVAL 16 day)) AND ('2022-12-30 23:00:00' > DATE_SUB(e.activity_date_time, INTERVAL 16 day))
[nativecode=1054 ** Unknown column 'r.contact_id' in 'field list']"]
```
I tried to debug a little and think I found that in civicrm-core/CRM/Activity/ActionMapping.php
casContactIdField is defined as r.contact_id
`$query['casContactIdField'] = 'r.contact_id';`
But in the above other query r.contact_id fails because civicrm_action_log has the alias of reminder and not 'r'
Not sure what this breaks but it seems something that needs to be fixedhttps://lab.civicrm.org/dev/core/-/issues/2963Export file empty when utilizing "Display results as" and searching for custo...2023-01-10T16:46:00Zfabian_SYSTOPIAExport file empty when utilizing "Display results as" and searching for custom dataOverview
----------------------------------------
When exporting data after an advanced search the exported file is empty if:
* "Display results as" was set to "related contacts" AND
* one search criterium was a custom field
The expor...Overview
----------------------------------------
When exporting data after an advanced search the exported file is empty if:
* "Display results as" was set to "related contacts" AND
* one search criterium was a custom field
The export preview shows all information correctly but the exported file does not contain any data.
Reproduction steps
----------------------------------------
1. Create a contact custom field (if you do not have one already, ex: Favorite Color: A/B/C)
1. Perform an advanced search, set "Display results as" to "related contacts" and any relationship type (ex: 'Employee Of')
1. Choose at least one custom filed as a search criterium (the search result must contain at least one contact (you may have to create/edit a test contact so that the Custom Field has a value)
1. Export the contact(s) from the search result
Current behaviour
----------------------------------------
The export file is empty although the export's preview shows all information correctly (in case you choose data to export and not export primary fields). Note that the export will work as intended if you do not set "Display results as" to "related contacts" or do not have at least one search criterium was a custom field.
Expected behaviour
----------------------------------------
Export file should contain data of selected contacts
Environment information
----------------------------------------
<!-- Some of the items below may not be relevant for every bug - if in doubt please include more information than you think is neccessary. -->
* __Browser:__ all
* __CiviCRM:__ Master/5.35.x, probably also earlier versions
Comments
----------------------------------------
Possibly unrelated but referencing #2873 and assigning to @monish.deb as there is currently a fix for the export feature in progress.Monish DebMonish Debhttps://lab.civicrm.org/dev/core/-/issues/2962Expose contact id in getContactInfo method in CRM/Mailing/Event/BAO/Queue.php2021-12-11T04:47:08ZyashodhaExpose contact id in getContactInfo method in CRM/Mailing/Event/BAO/Queue.phpOne would expect contact id to be returned here as well in _getContactInfo_ method in _CRM/Mailing/Event/BAO/Queue.php_ along with display name and email.One would expect contact id to be returned here as well in _getContactInfo_ method in _CRM/Mailing/Event/BAO/Queue.php_ along with display name and email.5.46.0yashodhayashodha