Forums - read data group by conditions

peppelaria , May 18 at 16:05

peppelaria

77

May 18 at 16:05 #377778

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.

GreyHead

6 18 85

May 18 at 17:27 #377781

Hi peppelaria ,

Does the Group Fields box in the Read Data action do what you need?

Bob

ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much

peppelaria

77

May 18 at 18:17 #377782

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

peppelaria

77

May 23 at 09:47 #377915

Hi Bob. coffee coming soon. Have a nice day

2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for
goods and services provided by ChronoEngine.com