Untitled

public class PrehledZamestnancuBezIdpRepository extends SimpleRepository {

  @Autowired
  private UserContext userContext;

  @SuppressWarnings("unchecked")
  public List<Object[]> nactiData(final String domena) {
    StringBuilder buffer = new StringBuilder();
    buffer.append("select prac.osobniCislo, "
            + " osoba.jmeno, "
            + " osoba.prijmeni, "
 + " titulPred.textCs, "
            + " titulZa.textCs, "
            + " uziv.uzivJmeno "
            + " from HPracovnik prac, "
            + " SVUzivatelOsoba vuo "
            + " left join prac.hOsoba osoba "
            + " left join prac.hOsoba.hCTitulPred titulPred "
            + " left join prac.hOsoba.hCTitulZa titulZa "
            + " left join osoba.suzivatels uziv "
            + " left join uziv.sidpKartaVydanas kv "
            + " left join kv.sIdpKarta idp "
            + " where prac.id = vuo.id.osobaId "
            + " and prac.id in ( "
            + SVOpravneniUzivOsoba.NACTI_OSOBA_IDS_PODLE_UZIVATELE_DOMENY_CTENI
            + " ) "
            + " and vuo.id.uzivatelId = :userId "
            + " and idp.sIdpkartaPxid is null "
    );
    Query query = getSession().createQuery(buffer.toString());
    query.setParameter("userId", userContext.getUzivatelId());
    query.setParameter("domena", domena);

    return query.list();
  }

}