I have a Repositiory query in my SpringBoot/JPA appliction:
@Query("SELECT w.userId, firstname, lastname "+
" FROM WorkflowStep w, User "+
" WHERE User.userId = WorkflowStep.userId and workflowId = 145 "+
" GROUP BY w.userId, firstname, lastname ")
public List<Activity> getRecentActivity(@Param("workflowId") Integer workflowId)
Which throws an Exception:
“java.lang.IllegalArgumentException: org.hibernate.query.SemanticException: Could not interpret path expression ‘User.userId’ntat org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:138)ntat org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:162)ntat org.hibernate.internal.ExceptionConverterImpl
I feel like the issue is in the Join syntax? Or a problem with my Entity classes?