SELECT
config.dwid,
config.dwname,
config.displaycode,
config.displayname,
gather.origclass
FROM
`eqm_equipdisplayconfig` config
LEFT JOIN eqm_equipgather_item gather ON gather.dwid = config.dwid
WHERE
config.tenantid = 9
AND config.displaycode LIKE 'RP_%'
SELECT
gather.dwid,
gather.dwname,
config.displaycode,
config.displayname,
gather.origclass
FROM
`eqm_equipdisplayconfig` config
LEFT JOIN
eqm_equiprecord_item recorditem ON recorditem.equiprecordid = config.equirecordid
LEFT JOIN
eqm_equipgather_item gather ON gather.equiprecorditemid =recorditem.id
WHERE
config.tenantid = 9
AND config.displaycode LIKE 'RP_%'
String sql = "SELECT config.dwid,config.dwname,config.displaycode,config.displayname,gather.origclass FROM `eqm_equipdisplayconfig` config LEFT JOIN eqm_equipgather_item gather ON gather.dwid = config.dwid WHERE config.tenantid = "
+ tenantid + " AND config.displaycode LIKE '" + sign + "%'";
Query query = em.createNativeQuery(sql);
query.unwrap(SQLQuery.class).addScalar("dwid", StandardBasicTypes.STRING)
.addScalar("dwname", StandardBasicTypes.STRING).addScalar("displaycode", StandardBasicTypes.STRING)
.addScalar("displayname", StandardBasicTypes.STRING)
.addScalar("origclass", StandardBasicTypes.STRING)
.setResultTransformer(Transformers.aliasToBean(EquipDisplayconfigVo.class));
@SuppressWarnings("unchecked")
List<EquipDisplayconfigVo> configvos = query.getResultList();