I’m not familiar enough with JPQL queries and syntax. Is there any way/tool to test JPQL queries against the datamodel ?
you can try it within cuba studio, for example, when setting a query to a datasource
You can also test JPQL queries in the running CUBA application. Open Administration > JMX Console, find the app-core.cuba:type=PersistenceManager MBean and open it. Find jpqlLoadList() operation and enter as a parameter:
select u from sec$User u
Then click Invoke.
Thanks to both of you !