Forums

ChronoForms v8 is now WordPress ready, ChronoMails is out

CF8 Action > Read Data - Group By is not present

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.

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.

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.

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.

You need to login to be able to post a reply.