Here I have a simple example showing how to implement MySQL's order by field in Criteria API for MySQL DBMS.
Example on how to write JPQL or Criteria API queries for DB functions with 'unusual' signatures, like MySQL's FTS function - match against.
I would like to share some of SQL queries for Alfresco database which could be useful.
For better understanding of Alfresco sometimes it's needed to see Alfresco tables. Here I'm showing how to connect to Alfresco Postgre database on a server and to h2 database during development.
Here I'm showing how to wipe alfresco database.