Formbuilder: Error in date selection of grouped activities
Overview
The data range picker of the Formbuilder does not work for Activities grouped by acitivity_type. It should show the sum of activities per activity_type in a defined data range. Instead the result always shows the total sum of activities per activitiy_type - no matter what date range i select.
Reproduction steps
- create a new Packaged Search with Searchkit. saved-search.txt with the following API Query Info:
{
"version": 4,
"select": [
"COUNT(subject) AS COUNT_subject",
"activity_type_id:label"
],
"orderBy": [],
"where": [],
"groupBy": [
"activity_type_id"
],
"join": [],
"having": []
}
- Create an Table to view the Saved Search in a Table
- Create a new Search Form with Formbuilder using this Saved Search Table
<div af-fieldset="">
<af-field name="activity_date_time" defn="{input_type: 'Select', search_range: true, input_attrs: {}}" />
<crm-search-display-table search-name="debug_activity" display-name=""></crm-search-display-table>
</div>
- Add the date picker "date of the activity"
- Use the Formbuilder and search for grouped data in a certain time range
Current behaviour
COUNT_subject
does always show the same sum, no matter what date selection i choose
Expected behaviour
COUNT_subject
should show the number of activities of a certain actitity_type in the defined data range.
Environment information
- Browser: _Firefox 107.0
- CiviCRM: 5.50.4
- PHP: 7.4.33
- CMS: Drupal 9.4.8
- Database: MySQL 5.7.7/MariaDB 10.4/..._
- Web Server: Apache 2.4/Nginx 1.16/...
Comments
Anything else you would like the reviewer to note.