Rukovoditel Support Forum

The date filter is not working on the reports. I have found out that the date_added column is saved as datatype bigint in the database. Is there a way to have the date filter work even if the data is in bigint? Attaching a screenshot for your reference.

Regards,

Cant I group them using the mySQL Query? Coz I need to show the count of the data in the Inspections Entity per month. In the screenshot below: I need to show the total count for the month of October from the Inspection Entity, it should show in the "Area Inspections Completed" column. Ass...

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!