Rukovoditel Support Forum

is it possible to group records using "Condition" in the mySQL Query Type? I need to count all records per month or is it possible to count all the records for the previous month? Still using the mySQL Query type.

its working now. Thank you! A question, in the Condition for the mySQL Query, is it possible to put a group by in it? Like for example, I will need to group the data in the Inspections Entity by month or any workaround for this?

i tried using "FROM_UNIXTIME([423], “%m/%d/%Y”) = ‘10/23/2023’" and im getting this error also, is it possible to make a group based on months?

Can someone please help me why my mySQL query is not working.

I basically need to show the total number of entries with a specific date. But the query is not showing any result. I maybe missing or entering the queries wrong. Here is a screenshot. Please help!