Ajuda com consulta [RESOLVIDO]

s.setor.descricao as setor

select s.idSolicitante as idSolicitante,
       s.nome as nome,
       s.sobrenome as sobrenome,
       (select descricao from setor b where b.idsetor = s.idsetor) setor,
       count(idSolicitante) as totalChamdas
  from Solicitante s
 group by idSolicitante

package com.br.model;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name="VW_Parametros")
public class VW_Parametros{
	
	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	int COD_PARAMETRO;
	@Column
	String DSC_PATH;
	@Column
	String DSC_PATH_DOWN;
	@Column
	String DSC_PATH_NTC_LOADER;
	@Column
	String DSC_PATH_IMEI_LOADER;
	@Column
	String DSC_PATH_LOTE_PAGTO_LOADER;
	@Column
	String DSC_PATH_PROJETO;
	@Column
	String DSC_PATH_COMUNICADO;
	@Column
	String DSC_PATH_MANUAIS;
	@Column
	String DSC_PATH_CONTA_LOADER;
	@Column
	String DSC_PATH_REPORT;
	
	public int getCOD_PARAMETRO() {
		return COD_PARAMETRO;
	}
	
	public void setCOD_PARAMETRO(int cOD_PARAMETROS) {
		COD_PARAMETRO = cOD_PARAMETROS;
	}
	
	public String getDSC_PATH() {
		return DSC_PATH;
	}
	
	public void setDSC_PATH(String dSC_PATH) {
		DSC_PATH = dSC_PATH;
	}

	public String getDSC_PATH_DOWN() {
		return DSC_PATH_DOWN;
	}

	public void setDSC_PATH_DOWN(String dSC_PATH_DOWN) {
		DSC_PATH_DOWN = dSC_PATH_DOWN;
	}

	public String getDSC_PATH_NTC_LOADER() {
		return DSC_PATH_NTC_LOADER;
	}

	public void setDSC_PATH_NTC_LOADER(String dSC_PATH_NTC_LOADER) {
		DSC_PATH_NTC_LOADER = dSC_PATH_NTC_LOADER;
	}

	public String getDSC_PATH_IMEI_LOADER() {
		return DSC_PATH_IMEI_LOADER;
	}

	public void setDSC_PATH_IMEI_LOADER(String dSC_PATH_IMEI_LOADER) {
		DSC_PATH_IMEI_LOADER = dSC_PATH_IMEI_LOADER;
	}

	public String getDSC_PATH_LOTE_PAGTO_LOADER() {
		return DSC_PATH_LOTE_PAGTO_LOADER;
	}

	public void setDSC_PATH_LOTE_PAGTO_LOADER(String dSC_PATH_LOTE_PAGTO_LOADER) {
		DSC_PATH_LOTE_PAGTO_LOADER = dSC_PATH_LOTE_PAGTO_LOADER;
	}

	public String getDSC_PATH_PROJETO() {
		return DSC_PATH_PROJETO;
	}

	public void setDSC_PATH_PROJETO(String dSC_PATH_PROJETO) {
		DSC_PATH_PROJETO = dSC_PATH_PROJETO;
	}

	public String getDSC_PATH_COMUNICADO() {
		return DSC_PATH_COMUNICADO;
	}

	public void setDSC_PATH_COMUNICADO(String dSC_PATH_COMUNICADO) {
		DSC_PATH_COMUNICADO = dSC_PATH_COMUNICADO;
	}

	public String getDSC_PATH_MANUAIS() {
		return DSC_PATH_MANUAIS;
	}

	public void setDSC_PATH_MANUAIS(String dSC_PATH_MANUAIS) {
		DSC_PATH_MANUAIS = dSC_PATH_MANUAIS;
	}

	public String getDSC_PATH_CONTA_LOADER() {
		return DSC_PATH_CONTA_LOADER;
	}

	public void setDSC_PATH_CONTA_LOADER(String dSC_PATH_CONTA_LOADER) {
		DSC_PATH_CONTA_LOADER = dSC_PATH_CONTA_LOADER;
	}

	public String getDSC_PATH_REPORT() {
		return DSC_PATH_REPORT;
	}

	public void setDSC_PATH_REPORT(String dSC_PATH_REPORT) {
		DSC_PATH_REPORT = dSC_PATH_REPORT;
	}		
}

package com.br.dao;

import java.util.List;
import java.util.logging.Logger;

import javax.persistence.EntityManager;
import javax.persistence.Query;

import com.br.model.VW_Parametros;

public class VW_ParametrosDao {
	
	private Logger        logger = Logger.getLogger("br.com.log"); 
	private StringBuilder vSQL   = new StringBuilder();

	private EntityManager getEntityManager(){
		
		ManagerEntityManager manager = new ManagerEntityManager();
		return manager.getEntityManager();
	}
	

	/* Metodo de consulta no banco de dados */
	private List<Parametros> consultar(List<String> pColunas, List<String> pValores){
		
		EntityManager entityManager = getEntityManager();
		vSQL.append("from VW_Parametros as vw_parametros");
		
		if (pColunas != null){
			vSQL.append(" WHERE ");
			
			for (int i = 0; i < pColunas.size(); i++){
				if (i==0){
					vSQL.append(" " + pColunas.get(i).toString() + " = '" + pValores.get(i).toString() + "'");
				}else{
					vSQL.append(" AND " + pColunas.get(i).toString() + " = '" + pValores.get(i).toString() + "'");
				}
			}
		}
		
		vSQL.append(" ORDER BY COD_PARAMETRO");
		logger.info("Consulta executada : " + vSQL);
		Query vQuery = entityManager.createQuery(vSQL.toString());		
		@SuppressWarnings("unchecked")
		List<Parametros> listaParametros = vQuery.getResultList();
		entityManager.close();
		return listaParametros;		
	}
	
	public List<Parametros> select(List<String> pColunas, List<String> pValores){
		return consultar(pColunas,pValores);
	}
	
}

<class>com.br.model.VW_Parametros</class>