Forums

Hi Bob.
​
There is some way in chronoforms 6 to set read_data group by days?
​
eg in mysql: GROUP BY
DAY(Access.created)
​
thanks in advance for your help.

Hi peppelaria ,
​
Does the Group Fields box in the Read Data action do what you need?
​
Bob

no, it doesn’t.
​
the string “DAY(Access.created)“ is treated like a table field and the query returns an error because that field doesn’t exists

Hi Bob. coffee coming soon. Have a nice day

Anyone have a working solution for this?

Put

DAY(Access.created):model.name

in the "Fields to retrieve", and "model.name" in the group by

thanks helyhatman, it works like a charm,
but wath if i need to get something lyke this: "SELECT DATE_FORMAT(`Sale.created`, "%Y-%m-%d") AS `Sale.created`"?

great. it works.
thank you very mutch