skillifier/src/main/java/rage/models/daos/UserExerciseDao.java
@Query("SELECT DISTINCT ue from UserExercise ue, Exercise e, Skill s, Theme t, Week w, Course c, ExerciseSkill es"
            + " WHERE ue.exercise = e.id AND s.theme = t.id AND t.week = w.id AND w.course = c.id"
            + " AND es.exerciseSkill = s.id AND es.skillExercise = e.id"
            + " AND c.name = :courseName AND ue.user = :user")
    public List<UserExercise> findByUserAndCourseName(@Param("user") User user, @Param("courseName") String courseName);
/**
     * Find and return a list of Exercises the User has tracked/is currently tracking
     * (See: JavaDoc for .findByUser()) from a specified Course for User specific information.
     * @param user The User whose Exercises you want to fetch
     * @param courseName The specified Course's name from where to get the Exercises
     * @return (List of type UserExercise) The list of Exercises in UserExercise @ManyToMany wrapper Class
     */
Find and return a list of Exercises the User has tracked/is currently tracking
(See: JavaDoc for .findByUser()) from a specified Course for User specific information.
@param user The User whose Exercises you want to fetch
@param courseName The specified Course's name from where to get the Exercises
@return (List of type UserExercise) The list of Exercises in UserExercise @ManyToMany wrapper Class
Find and return a list of Exercises the User has tracked / is currently tracking ( See : JavaDoc for . findByUser () ) from a specified Course for User specific information . @param user The User whose Exercises you want to fetch @param courseName The specified Course ' s name from where to get the Exercises @return ( List of type UserExercise ) The list of Exercises in UserExercise @ManyToMany wrapper Class
@Query("SELECT DISTINCT ue from UserExercise ue, Exercise e, Skill s, Theme t, Week w, Course c, ExerciseSkill es"
            + " WHERE ue.exercise = e.id AND s.theme = t.id AND t.week = w.id AND w.course = c.id"
            + " AND es.exerciseSkill = s.id AND es.skillExercise = e.id"
            + " AND c.name = :courseName AND ue.user = :user")
    public List<UserExercise> findByUserAndCourseName(@Param("user") User user, @Param("courseName") String courseName);
@ Query ( "SELECT DISTINCT ue from UserExercise ue, Exercise e, Skill s, Theme t, Week w, Course c, ExerciseSkill es" + " WHERE ue.exercise = e.id AND s.theme = t.id AND t.week = w.id AND w.course = c.id" + " AND es.exerciseSkill = s.id AND es.skillExercise = e.id" + " AND c.name = :courseName AND ue.user = :user" ) public List < UserExercise > findByUserAndCourseName ( @ Param ( "user" ) User user , @ Param ( "courseName" ) String courseName ) ;
Find and return a list of Exercises the User has tracked/is currently tracking
 (See: JavaDoc for .findByUser()) from a specified Course for User specific information.
Find and return a list of Exercises the User has tracked / is currently tracking ( See : JavaDoc for . findByUser () ) from a specified Course for User specific information .