Search and Reporting - archived issueshttps://lab.civicrm.org/dev/report/-/issues2022-04-22T15:48:47Zhttps://lab.civicrm.org/dev/report/-/issues/103Unable to take any actions on results after searching2022-04-22T15:48:47Zben_fairlessUnable to take any actions on results after searchingWordPress Version: 5.9.2
PHP Version: 7.4.11
CiviCRM Version: 5.48.1
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 ...WordPress Version: 5.9.2
PHP Version: 7.4.11
CiviCRM Version: 5.48.1
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://lab.civicrm.org/dev/report/-/issues/102Search Kit: Can't add/remove more than ~500 contacts to a group2022-04-22T15:48: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/report/-/issues/101Search Kit: "Bypass Permissions" doesn't apply to in-place edit2022-04-22T15:51:45ZJonGoldSearch Kit: "Bypass Permissions" doesn't apply to in-place editAs the title says - "Bypass Permissions" doesn't allow for in-place editing.As the title says - "Bypass Permissions" doesn't allow for in-place editing.https://lab.civicrm.org/dev/report/-/issues/100SearchKit: Rewrite and Group By don't mix2022-04-22T15:47:57ZJonGoldSearchKit: Rewrite and Group By don't mixWhen using "Rewrite" in a search display, the rendered token for fields we've grouped by only show the first value.
### Steps to Replicate
* Install Search Kit, import the Search/Display below.
* Preview the Display.
* Turn off "Rewrite...When using "Rewrite" in a search display, the rendered token for fields we've grouped by only show the first value.
### Steps to Replicate
* Install Search Kit, import the Search/Display below.
* Preview the Display.
* Turn off "Rewrite" on the "Total Amount" field and preview again.
### Expected Result
Rendered token has the same output as the non-rewritten field.
### Actual Result
Token only renders the first value in a list.
```
[
[
"SavedSearch",
"save",
{
"records": [
{
"name": "group_and_rewrite",
"label": "group and rewrite",
"form_values": null,
"search_custom_id": null,
"api_entity": "Contact",
"api_params": {
"version": 4,
"select": [
"id",
"display_name",
"GROUP_CONCAT(Contact_Contribution_contact_id_01.total_amount) AS GROUP_CONCAT_Contact_Contribution_contact_id_01_total_amount"
],
"orderBy": [],
"where": [],
"groupBy": [
"id"
],
"join": [
[
"Contribution AS Contact_Contribution_contact_id_01",
"LEFT",
[
"id",
"=",
"Contact_Contribution_contact_id_01.contact_id"
]
]
],
"having": []
},
"expires_date": null,
"description": null,
"mapping_id": null
}
],
"match": [
"name"
]
}
],
[
"SearchDisplay",
"save",
{
"records": [
{
"name": "Contacts_Table_1",
"label": "Contacts Table 1",
"saved_search_id.name": "group_and_rewrite",
"type": "table",
"settings": {
"actions": true,
"limit": 50,
"classes": [
"table",
"table-striped"
],
"pager": {
"show_count": true,
"expose_limit": true
},
"sort": [
[
"sort_name",
"ASC"
]
],
"columns": [
{
"type": "field",
"key": "id",
"dataType": "Integer",
"label": "Contact ID",
"sortable": true
},
{
"type": "field",
"key": "display_name",
"dataType": "String",
"label": "Display Name",
"sortable": true
},
{
"type": "field",
"key": "GROUP_CONCAT_Contact_Contribution_contact_id_01_total_amount",
"dataType": "Money",
"label": "(List) Contact Contributions: Total Amount",
"sortable": true,
"rewrite": "[GROUP_CONCAT_Contact_Contribution_contact_id_01_total_amount]"
}
]
},
"acl_bypass": false
}
],
"match": [
"name",
"saved_search_id"
]
}
]
]
```https://lab.civicrm.org/dev/report/-/issues/99Advanced search: AND search operator not working for multiple groups or tags2022-04-22T15:53:38ZelianneAdvanced search: AND search operator not working for multiple groups or tagsThe AND search operator does not work when performing an advanced search on 2(+) groups or tags. It always performs an OR search. For instance, a search on contacts with tag X gives 5 results, a separate search on tag Y gives 5 results, ...The AND search operator does not work when performing an advanced search on 2(+) groups or tags. It always performs an OR search. For instance, a search on contacts with tag X gives 5 results, a separate search on tag Y gives 5 results, while the search on tag X AND Y gives 10 results. Similar issue for groups.https://lab.civicrm.org/dev/report/-/issues/98SearchKit: granularity of relative dates2022-04-22T15:47:22ZJonGoldSearchKit: granularity of relative datesConsider the following search:
![Selection_1424](/uploads/15243ef6bfd34c2c9e8689275d6e69da/Selection_1424.png)
I would expect this, when run on March 14 2022, to find any donations made on or after March 14, 2021.
However, it takes "1 ...Consider the following search:
![Selection_1424](/uploads/15243ef6bfd34c2c9e8689275d6e69da/Selection_1424.png)
I would expect this, when run on March 14 2022, to find any donations made on or after March 14, 2021.
However, it takes "1 year" rather literally - if I run it at 3pm, it will only catch donations made on March 14, 2021 at or after 3pm. This doesn't match the behavior elsewhere in Civi, where we automatically add a "00:00:00" to the search when setting the beginning date of a search, or "23:59:59" when setting the end date of a search.
**Proposal**: When the interval unit is "Day", "Week", "Month" or "Year" we append the timestamp, much as we do in `CRM_Contact_BAO_Query::dateQueryBuilder()` or `CRM_Report_Form::dateClause()`.https://lab.civicrm.org/dev/report/-/issues/97SearchKit not functional on Joomla 42022-04-22T15:47:19Zjoshjosh@civicrm.orgSearchKit not functional on Joomla 4The past two release of CiviCRM have resulted in SearchKit not functioning on Joomla 4. When browsing to SearchKit, the user is presented with what appears to be unrendered code:
![Screenshot_2022-02-21_12.13.32](/uploads/5899ba97078e89...The past two release of CiviCRM have resulted in SearchKit not functioning on Joomla 4. When browsing to SearchKit, the user is presented with what appears to be unrendered code:
![Screenshot_2022-02-21_12.13.32](/uploads/5899ba97078e894cb86ba703c06eb300/Screenshot_2022-02-21_12.13.32.jpg)
Console presents the following error:
```
Error: [$injector:unpr] http://errors.angularjs.org/1.8.2/$injector/unpr?p0=savedSearchesProvider%20%3C-%20savedSearches%20%3C-%20searchList
at angular.min.js:7:168
at angular.min.js:46:468
at Object.d [as get] (angular.min.js:44:197)
at angular.min.js:47:29
at d (angular.min.js:44:197)
at e (angular.min.js:44:438)
at Object.instantiate (angular.min.js:45:333)
at angular.min.js:99:267
at Object.link (angular-modules.d0a616a75686afef23d3772fcee92a7f.js:5648:217)
at angular.min.js:17:134 '<div ng-view="" class="ng-scope">'
(anonymous) @ angular.js:15697
```
All other aspects of CiviCRM appear to be functional. The issue can be reproduced at https://cividemo.com and on fresh installs of just Joomla and CiviCRM (no extensions installed on either systems).Monish DebMonish Debhttps://lab.civicrm.org/dev/report/-/issues/96SearchKit: In-place edit and Update Multiple action doesn't send full objectR...2022-04-22T15:53:55ZDaveDSearchKit: In-place edit and Update Multiple action doesn't send full objectRef object to the post hookThe objectRef is empty except for the id property. Not sure if this is expected from this action - in this particular situation it was a custom field being edited on an activity but I checked and it also happens with core activity fields...The objectRef is empty except for the id property. Not sure if this is expected from this action - in this particular situation it was a custom field being edited on an activity but I checked and it also happens with core activity fields. Normally objectRef is more populated during hook_post from elsewhere, e.g. it would normally have activity_type_id, subject, etc.https://lab.civicrm.org/dev/report/-/issues/95Search > Merge: Not merging correctly with a DOCX file2022-04-22T15:48:54ZswebervnaSearch > Merge: Not merging correctly with a DOCX fileIf I perform an Advanced Search, select "Thank-you letters - print or email":
![image](/uploads/3a392ad57ea180d0cced90d3db053b32/image.png)
..chose my options (group by Contact, separator Comma) and run the merge, it's not filling in any...If I perform an Advanced Search, select "Thank-you letters - print or email":
![image](/uploads/3a392ad57ea180d0cced90d3db053b32/image.png)
..chose my options (group by Contact, separator Comma) and run the merge, it's not filling in any of my merge codes in the DOCX:
![image](/uploads/d8f367d2ab4add367262d5f4def87155/image.png)
1. I triple-checked, all merge codes are typed in exactly as they are in Civi.
2. I even tried using my doc with only a few merge codes, same issue.
3. No difference if I output merge from Civi in DOCX vs PDF.
4. Interestingly, the first time I did the merge everything filled in correctly except for the table at the bottom which groups contributions by "Comma", then all future merges done with this search don't merge correctly at all.
I'm guessing this is a bug with Civi, I tried the same thing on the demo and ran into the same problem with DOCX files.
**Workaround:**
My workaround is to replicate my letter as a Message Template in Civi since the native template works with the fields 100% each time - the downside to this is the limitations of CKEditor4. It's a pain to insert page breaks, center paragraphs, etc, way too basic formatting options.https://lab.civicrm.org/dev/report/-/issues/94SearchKit: fieldset legend display in Drupal 9 Seven admin theme2022-04-22T15:47:24ZherbdoolSearchKit: fieldset legend display in Drupal 9 Seven admin themeDrupal 9's default admin theme, Seven, sets an `position: absolute` for fieldset legends (`core/themes/seven/css/components/form.css`) if the fieldset is not in a `.fieldgroup` (`fieldset:not(.fieldgroup) > legend`). It looks like:
![Sc...Drupal 9's default admin theme, Seven, sets an `position: absolute` for fieldset legends (`core/themes/seven/css/components/form.css`) if the fieldset is not in a `.fieldgroup` (`fieldset:not(.fieldgroup) > legend`). It looks like:
![Screenshot_from_2022-01-11_11-10-20](/uploads/9381f41cacc03748bd1b90b7756b8ef6/Screenshot_from_2022-01-11_11-10-20.png)
I guess the easiest is to set a `position: relative` in `civicrm/core/ext/search_kit/css/crmSearchAdmin.css`https://lab.civicrm.org/dev/report/-/issues/93SearchKit: URLs to external sites no longer render2022-04-22T15:53:50ZJonGoldSearchKit: URLs to external sites no longer renderSearchKit displays that used to link to an external site now link to an invalid internal URL. This is a 5.44 regression.
### (Simplest) Steps to Replicate
* Create a new SearchKit search on Website entities. (Screenshot 1347)
* Create ...SearchKit displays that used to link to an external site now link to an invalid internal URL. This is a 5.44 regression.
### (Simplest) Steps to Replicate
* Create a new SearchKit search on Website entities. (Screenshot 1347)
* Create a new display, linking the website to itself. (Screenshot 1348).
* Click Preview.
### Expected Result
Link of "https://www.example.org" links to "https://www.example.org".
### Actual Result
Link of "https://www.example.org" links to "http://dmaster.localhost/https://www.example.org".
`git bisect` points to [PR #21820](https://github.com/civicrm/civicrm-core/pull/21820), specifically commit ID `8fd58f5640`.JonGoldJonGoldhttps://lab.civicrm.org/dev/report/-/issues/92SearchKit: In-place edit for custom dropdown field - can't blank it out2022-04-22T15:48:48ZDaveDSearchKit: In-place edit for custom dropdown field - can't blank it outIf you have a search display with a dropdown custom field with in-place edit enabled and the field is defined as not required, you should be able to blank it out. But there is no "X" icon or "-none-" choice.If you have a search display with a dropdown custom field with in-place edit enabled and the field is defined as not required, you should be able to blank it out. But there is no "X" icon or "-none-" choice.https://lab.civicrm.org/dev/report/-/issues/91SearchKit: In-place edit for custom date field - can't select a date2022-04-22T15:53:43ZDaveDSearchKit: In-place edit for custom date field - can't select a dateIf you have a search display with a custom date field with in-place edit enabled and you try to use the datepicker the table just completely disappears and it says unknown path.If you have a search display with a custom date field with in-place edit enabled and you try to use the datepicker the table just completely disappears and it says unknown path.5.46.0https://lab.civicrm.org/dev/report/-/issues/90SearchKit: Chicken-and-egg problem upgrading from 5.35.2 to 5.44.02022-04-22T15:52:29ZDaveDSearchKit: Chicken-and-egg problem upgrading from 5.35.2 to 5.44.0## Steps:
1. Install 5.35.2 and enable search kit.
1. Create a search with a display and save it.
1. Upgrade to 5.44.0. The civi upgrade runs ok.
* The 5.44 part isn't too relevant I think - 5.40+ seems like it would also happen.
1. ...## Steps:
1. Install 5.35.2 and enable search kit.
1. Create a search with a display and save it.
1. Upgrade to 5.44.0. The civi upgrade runs ok.
* The 5.44 part isn't too relevant I think - 5.40+ seems like it would also happen.
1. Visit the system status page and run the extension upgrades.
1. Error as below because upgrade_1001 triggers something that doesn't exist until upgrade_1005.
If you look at http://stats.civicrm.org/?tab=sites you'll notice there's a lot of sites on `5.35` because it was a security release, so will be a problem when they upgrade.
Some workarounds are upgrade in smaller steps, or manually create the column first:
`alter table civicrm_search_display add column acl_bypass tinyint DEFAULT 0 COMMENT 'Skip permission checks and ACLs when running this display.';`
## Details
```
[info] Applying update 1001 - normalize search display columns.
[error] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => exceptionHandler
)
[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`saved_search_id` AS `saved_search_id`, `a`.`type` AS `type`, `a`.`settings` AS `settings`, `a`.`acl_bypass` AS `acl_bypass`
FROM civicrm_search_display a
WHERE (`a`.`saved_search_id` = "1")
[nativecode=1054 ** Unknown column 'a.acl_bypass' in 'field list']
[type] => DB_Error
[user_info] => SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`saved_search_id` AS `saved_search_id`, `a`.`type` AS `type`, `a`.`settings` AS `settings`, `a`.`acl_bypass` AS `acl_bypass`
FROM civicrm_search_display a
WHERE (`a`.`saved_search_id` = "1")
[nativecode=1054 ** Unknown column 'a.acl_bypass' in 'field list']
[to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`saved_search_id` AS `saved_search_id`, `a`.`type` AS `type`, `a`.`settings` AS `settings`, `a`.`acl_bypass` AS `acl_bypass`
FROM civicrm_search_display a
WHERE (`a`.`saved_search_id` = "1")
[nativecode=1054 ** Unknown column 'a.acl_bypass' in 'field list']"]
)
Dec 22 13:41:25 [debug] $backTrace = #0 ...\sites\all\modules\civicrm\CRM\Core\Error.php(942): CRM_Core_Error::backtrace("backTrace", TRUE)
1 ...\sites\all\modules\civicrm\vendor\pear\pear-core-minimal\src\PEAR.php(922): CRM_Core_Error::exceptionHandler(Object(DB_Error))
2 ...\sites\all\modules\civicrm\vendor\pear\db\DB.php(997): PEAR_Error->__construct("DB Error: no such field", -19, 16, (Array:2), "SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`s...")
3 ...\sites\all\modules\civicrm\vendor\pear\pear-core-minimal\src\PEAR.php(575): DB_Error->__construct(-19, 16, (Array:2), "SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`s...")
4 ...\sites\all\modules\civicrm\vendor\pear\pear-core-minimal\src\PEAR.php(223): PEAR::_raiseError(Object(DB_mysqli), NULL, -19, 16, (Array:2), "SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`s...", "DB_Error", TRUE)
5 ...\sites\all\modules\civicrm\vendor\pear\db\DB\common.php(1928): PEAR->__call("raiseError", (Array:7))
6 ...\sites\all\modules\civicrm\vendor\pear\db\DB\mysqli.php(936): DB_common->raiseError(-19, NULL, NULL, "SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`s...", "1054 ** Unknown column 'a.acl_bypass' in 'field list'")
7 ...\sites\all\modules\civicrm\vendor\pear\db\DB\mysqli.php(406): DB_mysqli->mysqliRaiseError()
8 ...\sites\all\modules\civicrm\vendor\pear\db\DB\common.php(1234): DB_mysqli->simpleQuery("SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`s...")
9 ...\sites\all\modules\civicrm\packages\DB\DataObject.php(2696): DB_common->query("SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`s...")
10 ...\sites\all\modules\civicrm\packages\DB\DataObject.php(1829): DB_DataObject->_query("SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`s...")
11 ...\sites\all\modules\civicrm\CRM\Core\DAO.php(468): DB_DataObject->query("SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`s...")
12 ...\sites\all\modules\civicrm\CRM\Core\DAO.php(1621): CRM_Core_DAO->query("SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`s...", TRUE)
13 ...\sites\all\modules\civicrm\Civi\Api4\Query\Api4SelectQuery.php(167): CRM_Core_DAO::executeQuery("SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`s...")
14 ...\sites\all\modules\civicrm\Civi\Api4\Generic\DAOGetAction.php(111): Civi\Api4\Query\Api4SelectQuery->run()
15 ...\sites\all\modules\civicrm\Civi\Api4\Generic\DAOGetAction.php(99): Civi\Api4\Generic\DAOGetAction->getObjects(Object(Civi\Api4\Generic\Result))
16 ...\sites\all\modules\civicrm\Civi\Api4\Provider\ActionObjectProvider.php(68): Civi\Api4\Generic\DAOGetAction->_run(Object(Civi\Api4\Generic\Result))
17 ...\sites\all\modules\civicrm\Civi\API\Kernel.php(149): Civi\Api4\Provider\ActionObjectProvider->invoke(Object(Civi\Api4\Generic\DAOGetAction))
18 ...\sites\all\modules\civicrm\Civi\Api4\Generic\AbstractAction.php(234): Civi\API\Kernel->runRequest(Object(Civi\Api4\Generic\DAOGetAction))
19 ...\sites\all\modules\civicrm\api\api.php(85): Civi\Api4\Generic\AbstractAction->execute()
20 ...\sites\all\modules\civicrm\Civi\Api4\Provider\ActionObjectProvider.php(103): civicrm_api4("SearchDisplay", "get", (Array:13), NULL)
21 ...\sites\all\modules\civicrm\Civi\Api4\Provider\ActionObjectProvider.php(84): Civi\Api4\Provider\ActionObjectProvider->runChain((Array:4), (Array:14))
22 ...\sites\all\modules\civicrm\Civi\Api4\Provider\ActionObjectProvider.php(69): Civi\Api4\Provider\ActionObjectProvider->handleChains(Object(Civi\Api4\Generic\DAOGetAction), Object(Civi\Api4\Generic\Result))
23 ...\sites\all\modules\civicrm\Civi\API\Kernel.php(149): Civi\Api4\Provider\ActionObjectProvider->invoke(Object(Civi\Api4\Generic\DAOGetAction))
24 ...\sites\all\modules\civicrm\Civi\Api4\Generic\AbstractAction.php(234): Civi\API\Kernel->runRequest(Object(Civi\Api4\Generic\DAOGetAction))
25 ...\sites\all\modules\civicrm\ext\search_kit\CRM\Search\Upgrader.php(58): Civi\Api4\Generic\AbstractAction->execute()
26 ...\sites\all\modules\civicrm\CRM\Extension\Upgrader\QueueTrait.php(49): CRM_Search_Upgrader->upgrade_1001()
27 ...\sites\all\modules\civicrm\CRM\Queue\Task.php(74): CRM_Extension_Upgrader_Base::_queueAdapter(Object(CRM_Queue_TaskContext), "org.civicrm.search_kit", "upgrade_1001")
28 ...\sites\all\modules\civicrm\CRM\Queue\Runner.php(201): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
29 ...\sites\all\modules\civicrm\CRM\Queue\Page\AJAX.php(36): CRM_Queue_Runner->runNext(TRUE)
30 ...\sites\all\modules\civicrm\CRM\Queue\ErrorPolicy.php(89): CRM_Queue_Page_AJAX::{closure}()
31 ...\sites\all\modules\civicrm\CRM\Queue\Page\AJAX.php(38): CRM_Queue_ErrorPolicy->call(Object(Closure))
32 ...\sites\all\modules\civicrm\CRM\Core\Invoke.php(279): CRM_Queue_Page_AJAX::runNext()
33 ...\sites\all\modules\civicrm\CRM\Core\Invoke.php(69): CRM_Core_Invoke::runItem((Array:13))
34 ...\sites\all\modules\civicrm\CRM\Core\Invoke.php(36): CRM_Core_Invoke::_invoke((Array:4))
35 ...\sites\all\modules\civicrm\drupal\civicrm.module(471): CRM_Core_Invoke::invoke((Array:4))
36 ...\includes\menu.inc(527): civicrm_invoke("queue", "ajax", "runNext")
37 ...\index.php(21): menu_execute_active_handler()
38 {main}
```5.46.0https://lab.civicrm.org/dev/report/-/issues/89SearchKit: Custom integer field in-place edit doesn't let you blank out the f...2022-04-22T15:53:54ZDaveDSearchKit: Custom integer field in-place edit doesn't let you blank out the field, and (sort of) validates incorrectlyFollowing on from https://github.com/civicrm/civicrm-core/pull/22293, if you have a custom integer field in your search display and it has in-place edit, when you blank out the field and click the checkmark it just keeps the original val...Following on from https://github.com/civicrm/civicrm-core/pull/22293, if you have a custom integer field in your search display and it has in-place edit, when you blank out the field and click the checkmark it just keeps the original value instead of blanking it out.
I could put in 0, but I have a use-case where 0 is different from blank. I'm sure I could work around it, but it's inconsistent with how e.g. the contact edit form works with an integer custom field.
The validation part is that if I type in "aaaa" into the integer field, it correctly doesn't change the value, but has a "Saved" success message. Minor thing.5.46.0https://lab.civicrm.org/dev/report/-/issues/88Search Kit: "Combine text" field transformation seems to break output2022-04-22T15:52:56ZherbdoolSearch 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/report/-/issues/87Searchkit: ability to have simple "exposed filters" on the Display so staff c...2022-04-22T15:52:27ZherbdoolSearchkit: ability to have simple "exposed filters" on the Display so staff can do simple filtering (for example, set a date range but nothing else)I quite like the power of SearchKit but I was thinking that we'd share the display of a search with a client. But it would be great if they had the ability to do a simple filter, such as restricting the date range. Rather than give them ...I quite like the power of SearchKit but I was thinking that we'd share the display of a search with a client. But it would be great if they had the ability to do a simple filter, such as restricting the date range. Rather than give them all the power and complexity of the full search. (I guess I'm just used to this in Views).https://lab.civicrm.org/dev/report/-/issues/86SearchKit: ability to export and import saved searches so they can be shared ...2022-04-22T15:53:53ZherbdoolSearchKit: ability to export and import saved searches so they can be shared between sitesThe clone functionality works well enough, but I was looking around to see if there was the ability to export and import the saved searches so I could, say, develop a search on a dev site and then deploy it once ready. Or share it betwee...The clone functionality works well enough, but I was looking around to see if there was the ability to export and import the saved searches so I could, say, develop a search on a dev site and then deploy it once ready. Or share it between clients.https://lab.civicrm.org/dev/report/-/issues/85Contact Logging Detail report crashes when a contribution and contact are upd...2022-04-22T15:53:56ZJonGoldContact Logging Detail report crashes when a contribution and contact are updated togetherThis is a regression, but it dates back to Civi 5.35, so I'm not going to target the RC.
### Steps to replicate
* Turn on advanced logging.
* Record a donation through a contribution page for either a) a new contact, b) an existing cont...This is a regression, but it dates back to Civi 5.35, so I'm not going to target the RC.
### Steps to replicate
* Turn on advanced logging.
* Record a donation through a contribution page for either a) a new contact, b) an existing contact, but adding/changing their name.
* Go to that contact's change log, and try to view the details of the most recent change (by clicking **Update** next to the change).
### Expected result
You see the changes.
### Actual result
`DB Error: Syntax Error`.
This regression comes from [PR 19504](https://github.com/civicrm/civicrm-core/pull/19504). Previously, not every DAO had a `_labelField` property - so `CRM_Logging_ReportDetail::convertForeignKeyValuesToLabels()` checking if the property existed was basically the same as checking if it was defined. Now it will always exist (in `CRM_Core_DAO`) but not always be defined. So we change the conditional to reflect that.5.48.0JonGoldJonGoldhttps://lab.civicrm.org/dev/report/-/issues/84SearchKit/Form: exposing a Date custom field has invalid year range2022-04-22T15:51:15ZbgmSearchKit/Form: exposing a Date custom field has invalid year rangeTo reproduce on dmaster:
1) Create a new Custom Field (ex: Lucky Day), type 'Date', searchable, by range.
![image](/uploads/bf2abb0ce3a8dd80ebe644506700a380/image.png)
Optionally you can update a contact, so that at least one has a Lu...To reproduce on dmaster:
1) Create a new Custom Field (ex: Lucky Day), type 'Date', searchable, by range.
![image](/uploads/bf2abb0ce3a8dd80ebe644506700a380/image.png)
Optionally you can update a contact, so that at least one has a Lucky Day, but it is not a requirement to reproduce the bug. For extra luck, I used 2021-08-13.
2) Create a SearchKit that lists Contacts, and display the field
3) Create a Form for that Search, and expose the Lucky Day field as a filter. Give the form an URL to view the page.
![image](/uploads/491b27b752a57122cde45e1d8f70ccf0/image.png)
Then go view the form, and notice how the date filter only lets you select dates in 2021:
![image](/uploads/8148eeb65edf2de3ee68eb7ec3888da3/image.png)
If you go back to the custom field configuration, and set a number of years in the "Dates may be up to" prior/after, then the filter works correctly. However, having these fields empty usually means that there are no restrictions (or they default to -20/+10 years).5.46.0