StringBuilder queryStringBuilder = new StringBuilder();
    queryStringBuilder.append("SELECT          public.sys_guid() as id, a.hm_oem001_karyawan_id, b.employee_id as hm_oem001_karyawan_nik, b.name as hm_oem001_karyawan_name, \n");
    queryStringBuilder.append("                a.hm_mem006_lokasi_kerja_id, c.code as hm_mem006_lokasi_kerja_code, c.name as hm_mem006_lokasi_kerja_name, \n");
    queryStringBuilder.append("                COUNT(CASE WHEN a.jadwal = 'Masuk' THEN 1 ELSE null END) as jumlah_hari_kerja, \n");
    queryStringBuilder.append("                COUNT(CASE WHEN a.jadwal <> 'Masuk' THEN 1 ELSE null END) as jumlah_hari_libur, \n");
    queryStringBuilder.append("                null as version, null as user_create, null as creation_time, null as user_modify, null as modification_time \n");
    queryStringBuilder.append("FROM            hat_get_jadwal_kerja_o001 a \n");
    queryStringBuilder.append("INNER JOIN      hm_oem001 b ON b.id = a.hm_oem001_karyawan_id \n");
    queryStringBuilder.append("INNER JOIN      hm_mem006 c ON c.id = a.hm_mem006_lokasi_kerja_id \n");
    queryStringBuilder.append("WHERE           a.process_id IN :processId \n");
    queryStringBuilder.append("GROUP BY        a.hm_oem001_karyawan_id, b.employee_id, b.name, a.hm_mem006_lokasi_kerja_id, c.code, c.name \n");

    NativeSearchBuilder<OverrideJadwalKerjaSummary> search = new NativeSearchBuilder<>(OverrideJadwalKerjaSummary.class, em);

    StringBuilder processId = new StringBuilder();
    processId.append("(");
    for (String rndIdProses: processIdList) {
        processId.append("'" + rndIdProses + "', ");
    }
    processId.delete(processId.length() - 2, processId.length());
    processId.append(")");

    search.addParameter("processId", processId.toString());
    search.setQueryString(queryStringBuilder);
    search.setPagination(searchParameter.getPagination());
    search.setSort(searchParameter.getSort());
    SearchResult<OverrideJadwalKerjaSummary> result = search.getSearchResult();