SOLVED - mySQL query is not showing results

[amamyoj]

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!

[enishemed]

Check “perform dynamically” option and use condition like that

Code: Select all

FROM_UNIXTIME([423], “%m/%d/%Y”) = ‘10/23/2023’

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!

[amamyoj]

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?

[enishemed]

For months use like this

Code: Select all

FROM_UNIXTIME([423], “%m/%Y”) = ‘10/2023’

[amamyoj]

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?

[Didou12]

can you provide more information about what you want to perform ?

do you want to have a list : https://docs.rukovoditel.net/index.php?p=101 ?

Or just have the number of item based on a date ?

[amamyoj]

Thanks for your help. I was able to find a workaround to group the records by date!