What is the database solution behind this Cayenne

Community Help With My Project
1

Hello!

Would like to know what is the database behind this Cayenne Dashboard.
Is it NoSQL or SQL and do you have an example how to use custom sql-like query…

What is the correct syntax for this?

WHERE created_at >= 1593723955000 ORDER BY “created_at”
AND Unit == “P” desc

Thanks

2

I also need to know as I want to create a custom query that can fetch past 72 hrs data and I dont see any help in Cayenne on how to achieve it.