CiviCRM Core issueshttps://lab.civicrm.org/dev/core/-/issues2022-04-22T15:53:11Zhttps://lab.civicrm.org/dev/core/-/issues/3265APIv4-Based Reports2022-04-22T15:53:11Zjoshjosh@civicrm.orgAPIv4-Based ReportsThis project will allow report templates to be built with the Search-Builder UI. Presently, report templates must be implemented via PHP code. Prerequisite is the Search-Builder UI report#32
Tasks:
- Integrate report schema with Form B...This project will allow report templates to be built with the Search-Builder UI. Presently, report templates must be implemented via PHP code. Prerequisite is the Search-Builder UI report#32
Tasks:
- Integrate report schema with Form Builder UI
- Re-implement report system with APIv4 backend
- Implement API for creating report templates
- Bridge legacy report templates with the new systemcolemanwcolemanwhttps://lab.civicrm.org/dev/core/-/issues/3264Transaction Date filter in Bookkeeping Transactions report2022-04-22T15:53:09ZMWestergaardTransaction Date filter in Bookkeeping Transactions reportIn the Bookkeeping Transactions report, the filter for Transaction Date does not include time values and leads to missing data. For example, if today is February 10 and I filter Transaction Date on "Yesterday", the WHERE clause looks li...In the Bookkeeping Transactions report, the filter for Transaction Date does not include time values and leads to missing data. For example, if today is February 10 and I filter Transaction Date on "Yesterday", the WHERE clause looks like:
> ( financial_trxn.trxn_date >= '20190209') AND ( financial_trxn.trxn_date <= '20190209' )
Only transactions that occurred exactly at midnight are included. Contrast that with the filter for Date Received:
> ( contribution.receive_date >= '20190209000000') AND ( contribution.receive_date <= '20190209235959' )
I verified on dmaster and wpmaster.5.12.0https://lab.civicrm.org/dev/core/-/issues/3263Only in WORDPRESS: REST.php ---> Unable to decode supplied JSON2022-04-22T15:53:06ZRTaglientoOnly in WORDPRESS: REST.php ---> Unable to decode supplied JSONThis is my first post for CiviCRM.
Hi to all.
I have seen others post related and nowadays the problem remain.
Different from this post:
https://civicrm.stackexchange.com/questions/6585/rest-api-unable-to-decode-supplied-json
- with...This is my first post for CiviCRM.
Hi to all.
I have seen others post related and nowadays the problem remain.
Different from this post:
https://civicrm.stackexchange.com/questions/6585/rest-api-unable-to-decode-supplied-json
- with wordpress I got always the same response "**Unable to decode supplied JSON**".
I tried clear installation with Joomla and also Backdrop, and both works correctly.
I am not a good programmer but I tried to do some stuff myself, here you what I prepared on my little server:
WordPress+CiviCRM with the problem: [link clear installation](http://144.91.105.68/cms/wordpress/wp-content/plugins/civicrm/civicrm/extern/rest.php?entity=Contact&action=get&api_key=a42bfc2b33cf13184711bff14fe1fb19&key=a42bfc2b33cf13184711bff14fe1fb19&json={%22sequential%22:1})
WordPress+CiviCRM fixed myself: [custom](http://144.91.105.68/cms/cust/wordpress/wp-content/plugins/civicrm/civicrm/extern/rest.php?entity=Contact&action=get&api_key=a42bfc2b33cf13184711bff14fe1fb19&key=a42bfc2b33cf13184711bff14fe1fb19&json={%22sequential%22:1})
Here you what I modified to the file REST.php...
after line 326
```php
if (array_key_exists('json', $requestParams) && $requestParams['json'][0] == "{") {
$params = json_decode($requestParams['json'], TRUE);
```
my modification start here
```php
$new_requestParams = $requestParams['json'];
$new_requestParams = str_replace("\\", "", $new_requestParams);
$new_requestParams = str_replace("\\", "", $new_requestParams);
$params = json_decode($new_requestParams, TRUE);
```
I practically saw a lot of "\\" before the JSON DECODE.
So removing this "\\" now works regularly.
If you wish can check directly on both sites:
Clear ----> http://144.91.105.68/cms/wordpress
Custom ---> http://144.91.105.68/cms/cust/wordpress
The user and password are both same: **admin** / **admin**
And also siteKey and api_key are always: **a42bfc2b33cf13184711bff14fe1fb19**
Regards Roberto T.
https://lab.civicrm.org/dev/core/-/issues/3262Search Kit and Form Builder, add ability to use the afform component in WordP...2022-04-22T15:53:04Zjustinfreeman (Agileware)Search Kit and Form Builder, add ability to use the afform component in WordPress with the CiviCRM shortcodeWhen using the Search Kit and Form Builder to implement a front-end Search Listing on WordPress, would be really useful to be able to embed the afform in a WordPress page using a short-code. This would be really beneficial:
1. Have the a...When using the Search Kit and Form Builder to implement a front-end Search Listing on WordPress, would be really useful to be able to embed the afform in a WordPress page using a short-code. This would be really beneficial:
1. Have the ability to use any URL to display the form, instead of just /civicrm/afform-name
2. Better design control
3. Control of the content before / after the form
I did try to inserting the CiviCRM shortcode, just in case it works: `[civicrm component="afsearchMemberDirectory"]`
And get this error: **Do not know how to handle this shortcode.**
Which is a bummer.
Agileware Ref: CIVICRM-1895https://lab.civicrm.org/dev/core/-/issues/3261Membership Detail Report fails when ACLs are enabled2022-04-22T15:53:02ZJonGoldMembership Detail Report fails when ACLs are enabledDuring a tidy-up on the Membership Detail Report, the `from()` method was modified to use `CRM_Report_Form::setFromBase()`, which concatenates `$this->aclFrom`. However, concatenating `$this->aclFrom` was never removed from the child cl...During a tidy-up on the Membership Detail Report, the `from()` method was modified to use `CRM_Report_Form::setFromBase()`, which concatenates `$this->aclFrom`. However, concatenating `$this->aclFrom` was never removed from the child class, so it's added to the SQL statement twice.5.3.0JonGoldJonGoldhttps://lab.civicrm.org/dev/core/-/issues/3260Icon in status message after saving a civireport is misleading2022-04-22T15:53:01ZDaveDIcon in status message after saving a civireport is misleadingIt's the 'alert' icon instead of success.
1. Go to any CiviReport.
1. From the Actions dropdown choose Save.
1. Icon indicates a warning but it's all good.
Also for "save a copy".It's the 'alert' icon instead of success.
1. Go to any CiviReport.
1. From the Actions dropdown choose Save.
1. Icon indicates a warning but it's all good.
Also for "save a copy".5.29.0https://lab.civicrm.org/dev/core/-/issues/3259Add the possibility to use the hook_civicrm_alterReportVar('sql') in all reports2022-04-22T15:53:00ZrubofvilAdd the possibility to use the hook_civicrm_alterReportVar('sql') in all reportsSome reports have rewrited the method "buildQuery" from class CRM_Report_Form. Not in all reports is included the line to launch the hook `hook_civicrm_alterReportVar` -> `CRM_Utils_Hook::alterReportVar('sql', $this, $this);`
Example
h...Some reports have rewrited the method "buildQuery" from class CRM_Report_Form. Not in all reports is included the line to launch the hook `hook_civicrm_alterReportVar` -> `CRM_Utils_Hook::alterReportVar('sql', $this, $this);`
Example
https://github.com/civicrm/civicrm-core/blob/abc4afe890add20796585a2a997bc3d832815abe/CRM/Report/Form/Member/ContributionDetail.php#L552https://lab.civicrm.org/dev/core/-/issues/3258CiviReports issue with boolean fields2022-04-22T15:52:59ZMWestergaardCiviReports issue with boolean fieldsI recently noticed that boolean fields (Deceased, Do Not Email, Do Not SMS, etc) are all displayed as "Yes" on contact and membership reports, regardless of their actual values. The data itself is correct and is fine elsewhere, such as i...I recently noticed that boolean fields (Deceased, Do Not Email, Do Not SMS, etc) are all displayed as "Yes" on contact and membership reports, regardless of their actual values. The data itself is correct and is fine elsewhere, such as in search results and contact displays. The issue seems to be only on report display. The report filters work correctly on those fields, only the display is wrong. I checked my production system (CiviHosting), my dev system (personal Linux box), and the public WordPress demo system at wpmaster.demo.civicrm.org and I see the same thing. I tried the Drupal demo system at CiviHosting and did not see this issue. Perhaps it's an issue under WordPress. I was advised on StackExchange to submit as an issue.
My system is CiviCRM 5.2.2, WordPress 4.9.6, PHP 7.1.16, MySQL 5.7.21.5.3.0https://lab.civicrm.org/dev/core/-/issues/3257REST api error after upgrade to 5.28.32022-04-22T15:52:57ZRTaglientoREST api error after upgrade to 5.28.3Hi,
I updated wordpress to 5.5 and CiviCRM to 5.28.3 and I am getting a new strange error on rest api.
It work correctly with XML format
[OK](https://www.yogapause.it/civicenter/wp-json/civicrm/v3/rest?entity=Contact&action=get&api_...Hi,
I updated wordpress to 5.5 and CiviCRM to 5.28.3 and I am getting a new strange error on rest api.
It work correctly with XML format
[OK](https://www.yogapause.it/civicenter/wp-json/civicrm/v3/rest?entity=Contact&action=get&api_key=YWpYNlhWYUR4bWhsaTl1OVJ0cGVL&key=6d8984d9bc0f9c2c7121db065e094e51)
[same URL with only "&json={"sequential":1}"](https://www.yogapause.it/civicenter/wp-json/civicrm/v3/rest?entity=Contact&action=get&api_key=YWpYNlhWYUR4bWhsaTl1OVJ0cGVL&key=6d8984d9bc0f9c2c7121db065e094e51&json={%22sequential%22:1})
I got this error:
**{"code":"rest_invalid_param","message":"Parametro(i) non valido(i): json","data":{"status":400,"params":{"json":"json non \u00e8 del tipo integer."}}}**
in english must be somthing like
**{"code":"rest_invalid_param","message":"Parameter(i) not valid(i): json","data":{"status":400,"params":{"json":"json is not an integer type."}}}**
Using the parameter json=1 works, but I use the chain query mode :/
[adding "&json=1&id=2&return=email" works](https://www.yogapause.it/civicenter/wp-json/civicrm/v3/rest?entity=Contact&action=get&api_key=dDA4VjROSkpLWm9EU0hIbFFyaHBj&key=6d8984d9bc0f9c2c7121db065e094e51&json=1&id=2&return=email)
May you check what's going on?https://lab.civicrm.org/dev/core/-/issues/3256Search Kit: "Combine text" field transformation seems to break output2022-04-22T15:52:55ZherbdoolSearch Kit: "Combine text" field transformation seems to break outputWhen changing a field transformation to Combine text, such as for doing something simple of Last Name, First name, it breaks the output. That is, I get a flash and then nothing appears in the results. When I switch it back to no transfor...When changing a field transformation to Combine text, such as for doing something simple of Last Name, First name, it breaks the output. That is, I get a flash and then nothing appears in the results. When I switch it back to no transformation it works.
I made sure to test it again with a fresh install of 5.46.x and replicated it.
I didn't see anything meaningful in the console.log (not sure if there's a debugging option). The only thing I saw was a persistent 500 error when attempting to reach https://XXXX.XX/civicrm/ajax/api4. Which I don't get without the field transformation.
Actually, I just replicated it on a dev site on a different server (wasn't sure if it was related to Lando). This site was running 5.43.x. This one gave a bit more information:
```
Uncaught Error: Syntax error, unrecognized expression: #/create/Contact?params=%7B%22version%22:4,%22select%22:%5B%22id%22,%22CONCAT_WS(display_name)%20AS%20CONCAT_WS_display_name%22%5D,%22orderBy%22:%7B%7D,%22where%22:%5B%5D,%22groupBy%22:%5B%5D,%22join%22:%5B%5D,%22having%22:%5B%5D%7D
at Function.se.error (jquery.min.js?v=3.6.0:2)
at se.tokenize (jquery.min.js?v=3.6.0:2)
at se.select (jquery.min.js?v=3.6.0:2)
at Function.se [as find] (jquery.min.js?v=3.6.0:2)
at S.fn.init.find (jquery.min.js?v=3.6.0:2)
at new S.fn.init (jquery.min.js?v=3.6.0:2)
at S (jquery.min.js?v=3.6.0:2)
at handleFragmentLinkClickOrHashChange (form.js?v=9.2.10:144)
at debounce.js?v=9.2.10:31
at dispatch (jquery.min.js?v=3.6.0:2)
```https://lab.civicrm.org/dev/core/-/issues/3255Book keeping Report : Add Time field for Transaction Date and Receive Date field2022-04-22T15:52:54ZsunilBook keeping Report : Add Time field for Transaction Date and Receive Date fieldSame issue : https://lab.civicrm.org/dev/report/-/issues/7 ,with some solution : https://github.com/civicrm/civicrm-core/pull/13571
But not its not working ..., Reason Parent Class `CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME` Time ...Same issue : https://lab.civicrm.org/dev/report/-/issues/7 ,with some solution : https://github.com/civicrm/civicrm-core/pull/13571
But not its not working ..., Reason Parent Class `CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME` Time handling changed.
Add Time Time and Add Sort on Contribution Receive Date and Transaction Date.
![Screenshot_2020-08-27_at_10.31.17_PM](/uploads/5b3ab509542d99720f8d40cd67796187/Screenshot_2020-08-27_at_10.31.17_PM.png)5.30.0https://lab.civicrm.org/dev/core/-/issues/3254Membership detail report uses deprecated method causing fatal error2022-04-22T15:52:53ZMichael McAndrewMembership detail report uses deprecated method causing fatal error## Before
Generated SQL for Membership Detail report contained errors. More specifically, it was joining twice on the `civicrm_acl_contact_cache` table *AS WELL AS* doing some ACL filtering in a where clause. See the example below
```s...## Before
Generated SQL for Membership Detail report contained errors. More specifically, it was joining twice on the `civicrm_acl_contact_cache` table *AS WELL AS* doing some ACL filtering in a where clause. See the example below
```sql
SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name AS civicrm_contact_sort_name,
contact_civireport.id AS civicrm_contact_id,
membership_civireport.membership_type_id AS civicrm_membership_membership_type_id,
membership_civireport.start_date AS civicrm_membership_membership_start_date,
membership_civireport.end_date AS civicrm_membership_membership_end_date,
membership_civireport.join_date AS civicrm_membership_join_date,
mem_status_civireport.name AS civicrm_membership_status_name,
contribution_civireport.id AS civicrm_contribution_contribution_id,
contribution_civireport.currency AS civicrm_contribution_currency
FROM civicrm_contact contact_civireport
INNER JOIN civicrm_acl_contact_cache aclContactCache ON contact_civireport.id = aclContactCache.contact_id
INNER JOIN civicrm_acl_contact_cache aclContactCache ON contact_civireport.id = aclContactCache.contact_id
INNER JOIN civicrm_membership membership_civireport ON contact_civireport.id = membership_civireport.contact_id
AND membership_civireport.is_test = 0
LEFT JOIN civicrm_membership_status mem_status_civireport ON mem_status_civireport.id = membership_civireport.status_id
LEFT JOIN civicrm_membership_payment cmp ON membership_civireport.id = cmp.membership_id
LEFT JOIN civicrm_contribution contribution_civireport ON cmp.contribution_id=contribution_civireport.id
WHERE (1)
AND (`contact_civireport`.`id` IS NULL
OR (`contact_civireport`.`id` IN
(SELECT contact_id
FROM civicrm_acl_contact_cache
WHERE user_id = 636)))
AND (`contact_civireport`.`is_deleted` IS NULL
OR (`contact_civireport`.`is_deleted` != 1))
GROUP BY membership_civireport.id
ORDER BY contact_civireport.sort_name ASC,
membership_civireport.membership_type_id ASC,
contribution_civireport.receive_date DESC
LIMIT 0,
50
```
This appears to be because it is calling the deprecated method `CRM_Report_Form::buildACLClause()` and then later calling `CRM_Report_Form::buildQuery` which then calls `CRM_Report_Form::buildPermissionClause();` (the function that buildACLClause was deprecated in favour of.
## After
When one removes the call to `::buildACLClause` from `CRM_Report_Form_Member_Detail::postProcess`, the generated SQL is as follows:
```sql
SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name AS civicrm_contact_sort_name,
contact_civireport.id AS civicrm_contact_id,
membership_civireport.membership_type_id AS civicrm_membership_membership_type_id,
membership_civireport.start_date AS civicrm_membership_membership_start_date,
membership_civireport.end_date AS civicrm_membership_membership_end_date,
membership_civireport.join_date AS civicrm_membership_join_date,
mem_status_civireport.name AS civicrm_membership_status_name,
contribution_civireport.id AS civicrm_contribution_contribution_id,
contribution_civireport.currency AS civicrm_contribution_currency
FROM civicrm_contact contact_civireport
INNER JOIN civicrm_membership membership_civireport ON contact_civireport.id = membership_civireport.contact_id
AND membership_civireport.is_test = 0
LEFT JOIN civicrm_membership_status mem_status_civireport ON mem_status_civireport.id = membership_civireport.status_id
LEFT JOIN civicrm_membership_payment cmp ON membership_civireport.id = cmp.membership_id
LEFT JOIN civicrm_contribution contribution_civireport ON cmp.contribution_id=contribution_civireport.id
WHERE (1)
AND (`contact_civireport`.`id` IS NULL
OR (`contact_civireport`.`id` IN
(SELECT contact_id
FROM civicrm_acl_contact_cache
WHERE user_id = 636)))
AND (`contact_civireport`.`is_deleted` IS NULL
OR (`contact_civireport`.`is_deleted` != 1))
GROUP BY membership_civireport.id
ORDER BY contact_civireport.sort_name ASC,
membership_civireport.membership_type_id ASC,
contribution_civireport.receive_date DESC
LIMIT 0,
50
```
This SQL works nicely and the report respects the ACL.
In turns out that once you have removed the call to the deprecated function, the postProcess method is identical to its parent, so it can be removed completely.https://lab.civicrm.org/dev/core/-/issues/3253Contribution Detail: selecting the "soft credits" colum results in fatal error2022-04-22T15:52:45ZbgmContribution Detail: selecting the "soft credits" colum results in fatal errorTo reproduce:
* Go to the Reports > Contribution Reports > Contribution Details
* In the "columns", select the "soft credit" column
* Click "preview"
Results in a fatal error.
![Capture_d_écran_de_2018-03-07_16-58-43](/uploads/b3f0480...To reproduce:
* Go to the Reports > Contribution Reports > Contribution Details
* In the "columns", select the "soft credit" column
* Click "preview"
Results in a fatal error.
![Capture_d_écran_de_2018-03-07_16-58-43](/uploads/b3f048038f56aef323c6b101838b5b89/Capture_d_écran_de_2018-03-07_16-58-43.png)https://lab.civicrm.org/dev/core/-/issues/3252View Payment owned by Different contact on Membership and Participant View.2022-04-22T15:52:43ZsunilView Payment owned by Different contact on Membership and Participant View.Overview
----------------------------------------
Using Webform, we can set that, contribution assigned to contact A and Membership record will be assigned to Contact B and C (based on number Contact selected in webform). IF we visit the...Overview
----------------------------------------
Using Webform, we can set that, contribution assigned to contact A and Membership record will be assigned to Contact B and C (based on number Contact selected in webform). IF we visit the Membership Record of B and C, we can not see the linked Payment, because its owned by another contact. and there is NO way to check who own the payment record.
Current behaviour
----------------------------------------
Currently it does not show linked payment record if payment is not present on same contact.
Expected behaviour
----------------------------------------
Linked Payment record should show, irrespective of who own the payment record as long as payment is belong the respective Membership.
In this case, webform create membership payment link between each contact membership and contribution id in `civicrm_membership_payment` table.
As long as we have linking between membership and contribution id, then it shows linked payment on Membership View. Same apply to participant.
----------------------------------------
https://github.com/civicrm/civicrm-core/pull/182815.31.0https://lab.civicrm.org/dev/core/-/issues/3251Searchkit: OptionValue search with a WHERE clause for option group returns 0 ...2022-04-22T15:52:42ZDaveDSearchkit: OptionValue search with a WHERE clause for option group returns 0 resultsThis worked the first time I tested https://github.com/civicrm/civicrm-core/pull/22081 two weeks ago, so has broken some time in between.
It looks like the query does this, mixing up `name` and `value`:
```
"where": [
[
"opti...This worked the first time I tested https://github.com/civicrm/civicrm-core/pull/22081 two weeks ago, so has broken some time in between.
It looks like the query does this, mixing up `name` and `value`:
```
"where": [
[
"option_group_id:name",
"=",
"2"
]
],
```5.44.0https://lab.civicrm.org/dev/core/-/issues/3250Add custom field groups to Membership Contribution Detail report2022-04-22T15:52:41ZJonGoldAdd custom field groups to Membership Contribution Detail reportEvery other report template that has `Contact` in the `$_customGroupExtends` array also includes individual contact types - "Individual" almost always, "Organization" and "Household" where relevant.
This PR adds the contact types to the...Every other report template that has `Contact` in the `$_customGroupExtends` array also includes individual contact types - "Individual" almost always, "Organization" and "Household" where relevant.
This PR adds the contact types to the `$_customGroupExtends` array.5.31.0JonGoldJonGoldhttps://lab.civicrm.org/dev/core/-/issues/3249Activity Type + Activity Status + Case Type not being Combined Correctly in S...2022-04-22T15:52:40ZalistairjamesActivity Type + Activity Status + Case Type not being Combined Correctly in Search BuilderThis issue has the same outcome in the Search builder as noted for the Advanced Search in https://lab.civicrm.org/dev/report/-/issues/53 which is the main focus of my attention.
A search for contacts with scheduled meetings in one case ...This issue has the same outcome in the Search builder as noted for the Advanced Search in https://lab.civicrm.org/dev/report/-/issues/53 which is the main focus of my attention.
A search for contacts with scheduled meetings in one case type incorrectly includes contacts who have completed meetings in the case type of interest but also have scheduled meetings in the other case type.
Steps to create (in 5.31)
- Create CaseType1 containing a Meeting
- Create CaseType2 containing a Meeting
- Create a Case of CaseType1 for Alice and mark the Meeting as Completed
- Create a Case of CaseType1 for Bob and leave the Meeting as Scheduled
- Create a Case of CaseType2 for Alice and leave the Meeting as Scheduled
- Create a Case of CaseType2 for Bob and mark the Meeting as Completed
A table of the Meeting status for Alice and Bob in the different Cases
| Contact | CaseType1 | CaseType2 |
| ------ | ------ | ------ |
| Alice | Completed | Scheduled |
| Bob | Scheduled | Completed |
Use the Search Builder to search for Contacts with Meetings Scheduled in CaseType1.
Activity, Activity Type = Meeting
Activity, Activity Status = Scheduled
Case, Case Type = CaseType1
Result: Alice and Bob are both returned when only Bob satisfies the given search criteria.
The SQL query ($sql) displayed by CiviCRM in civicrm/CRM/Contact/Selector.php
public function fillupPrevNextCache($sort, $cacheKey, $start = 0, $end = self::CACHE_SIZE)
(Line 1019 in 5.31)
is as follows:
SELECT contact_a.id as id FROM civicrm_contact contact_a
LEFT JOIN civicrm_case_contact
   ON civicrm_case_contact.contact_id = contact_a.id
INNER JOIN civicrm_case
   ON civicrm_case_contact.case_id = civicrm_case.id
LEFT JOIN civicrm_activity_contact
   ON ( civicrm_activity_contact.contact_id = contact_a.id )
LEFT JOIN civicrm_activity
   ON ( civicrm_activity.id = civicrm_activity_contact.activity_id
   AND civicrm_activity.is_deleted = 0
   AND civicrm_activity.is_current_revision = 1 )
INNER JOIN civicrm_contact
   ON ( civicrm_activity_contact.contact_id = civicrm_contact.id and civicrm_contact.is_deleted != 1 )
LEFT JOIN civicrm_case_type
   ON civicrm_case.case_type_id = civicrm_case_type.id
   WHERE ( ( civicrm_activity.activity_type_id = 1
      AND civicrm_activity.status_id = 1
      AND civicrm_case.case_type_id = 3 ) )
   AND (contact_a.is_deleted = 0)
   AND (civicrm_activity.activity_type_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 58, 60, 62, 64, 66, 67, 68))
GROUP BY contact_a.id
ORDER BY \`contact_a\`.\`sort_name\` asc, \`contact_a\`.\`id\`
LIMIT 0, 500https://lab.civicrm.org/dev/core/-/issues/3248Add "created_date" to report filters2022-04-22T15:52:38ZphilipkasoAdd "created_date" to report filters**Use Case**: Report on all contacts created <period>.
**Background/Ask**: "created_date" can only be used via Change Log in Advance Search. We would like to be able to use the "Change Log" created date as a filter in standard reporting...**Use Case**: Report on all contacts created <period>.
**Background/Ask**: "created_date" can only be used via Change Log in Advance Search. We would like to be able to use the "Change Log" created date as a filter in standard reporting to satisfy the stated use case.https://lab.civicrm.org/dev/core/-/issues/3247OR term in WHERE clause crashes Search Kit2022-04-22T15:52:37ZBobSOR term in WHERE clause crashes Search KitSearch Kit can no longer save or load a search which contains an "OR" term in the WHERE clause.
Upon loading such a saved search, the WHERE clause is displayed as empty, and the following console error is observed:
```
angular.js:15697 ...Search Kit can no longer save or load a search which contains an "OR" term in the WHERE clause.
Upon loading such a saved search, the WHERE clause is displayed as empty, and the following console error is observed:
```
angular.js:15697 TypeError: Cannot read property 'indexOf' of undefined
at controller.operatorTakesInput (angular-modules.c4138be7c73c1c03a09face30217fa38.js?qw2iyi:2135)
at fn (eval at compile (angular.js:16548), <anonymous>:4:337)
at m.$digest (angular.js:19262)
at angular.js:19562
at Yg.completeTask (angular.js:21403)
at angular.js:6879
```
To reproduce:
1. Search | Search Kit | New Search
1. Where | OR
1. Add any term into the OR clause, e.g.: Contact ID = 1
1. Save
1. Observe that:
* The term previously specified in the OR clause has been deleted.
* Numerous errors are displayed in the console.
Observed on CiviCRM 5.39.0 and 5.41 alpha1.<br>
Problem did not occur in 5.38.0.https://lab.civicrm.org/dev/core/-/issues/3246Error when installing extensions2022-04-22T15:52:36ZElin.WaringError when installing extensionsEvery time I install an extension I get this message:
> An error has occurred.
> 0 Argument 1 passed to CRM_Admin_Page_Extensions::createExtendedInfo() must be an instance of CRM_Extension_Info, null given, called in /mnt/data/vhosts/xxx...Every time I install an extension I get this message:
> An error has occurred.
> 0 Argument 1 passed to CRM_Admin_Page_Extensions::createExtendedInfo() must be an instance of CRM_Extension_Info, null given, called in /mnt/data/vhosts/xxxxxxxx/administrator/components/com_civicrm/civicrm/CRM/Admin/Form/Extensions.php on line 63
And the page is redirected to
administrator/?option=com_civicrm&task=civicrm/admin/extensions
The extension is actually correctly installed but it's still strange to get this message.
This is on Joomla and I just did it again updating to CiviCRM 5.33.2.