CF8 Action > Read Data - Group By is not present

Add Group By functionality in ChronoForms 8.

Overview

The Group By feature available in CF7 was missing from the CF8 Read Data action.
Update to the latest version of CF8 where Group By has been restored, or use the SQL Code behavior to write a custom query.

ie ieraora 19 Sep, 2023

Hi, in CF7, read data, we have Group By, Relations and Php Conditions in settings. In CF8 are not present. Can you add these ASAP?
Thank You.

Max_admin 13 Apr, 2024

Answer

You can use the SQL Code behavior to write a full query of your choice

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

To Tony25 03 Jan, 2025

I too would like much to have the "By Group" returned to version 8 like in version 7!

Or could you give example of sql code how to do By Group ?

Much thanks

Max_admin 04 Jan, 2025

1 Likes

I added Group by to the next update, or you could use a full SQL SELECT query statement in the SQL code behavior

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

Ad Admiral 12 Jan, 2025

Max,

Just added the new Group By and it works as expected so thanks for that. There may be a bug however as when Group By is added, the pagination does not work. By Changing Limit the number of rows appears correct however the pagination is not showing.

CF8 Action > Read Data - Group By is not present image 1

Admiral

Max_admin 02 Feb, 2025

that has been fixed in the previous update!

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

This topic is locked and no more replies can be posted.