Buy Now
Sign in

read data group by conditions

peppelaria , May 18 at 16:05
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?
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
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