Comments (2)
my2iu
commented on August 30, 2024
Do you have more extensive exception information? Usually, the exception will have additional information a few levels deeper inside explaining why the code could not be translated. When I just glance over the queries though, grouping queries are not allowed in subqueries (they're special in SQL and JPQL, so they are only supported at the top-level of a query).
from jinq.
my2iu
commented on August 30, 2024
It also looks like, maybe you don't need any subqueries here. One left outer join between CommonEvent and User using CreatorId, then just use a normal join of that to CommonEvent based on SourceId. And then perform your grouping operation on everything afterwards. The subquery doesn't seem to be necessary.
from jinq.
Related Issues (20)
- toList() commit transaction ignoring JPA-Transactional HOT 3
- Question... How does Jinq guesses the operators in Lambdas HOT 1
- Anonymous class as a custom tuple HOT 6
- Could not translate code to a query HOT 6
- A Stream that returns a list of UUIDs is not serializable HOT 10
- fail with registerCustomSqlFunction HOT 5
- How to get the total count after group by? HOT 2
- How to get the number of groups HOT 1
- How to get the number of groups by issuing a separate query after group by? HOT 3
- Support java v21 HOT 5
- [BUG]: The concatenation of strings was not as expected HOT 4
- [Feature] join supports on condition HOT 1
- [Feature] Add support for additional collection libraries HOT 3
- Where filtering after select with projection gives error HOT 2
- Move from javax.persistence to jakarta.persistence. HOT 6
- Java 13 supported? HOT 2
- Compare int, datetime, bool to String HOT 1
- Could not analyze lambda code HOT 1
- jdk11 support HOT 11
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from jinq.