public List<? extends ProjectMember> getActiveProjectMembers(long id) { return create() .selectFrom(PROJECT_MEMBER) .where(PROJECT_MEMBER.PROJECT_ID.eq(id)) .and(PROJECT_MEMBER.STATE.eq(CommonStatesConstants.ACTIVE)) .and(PROJECT_MEMBER.REMOVED.isNull()) .orderBy(PROJECT_MEMBER.ID.asc()) .fetch(); }
@Override public ProjectMember getProjectMember(long id) { return create().selectFrom(PROJECT_MEMBER).where(PROJECT_MEMBER.ID.eq(id)).fetchOne(); }