Does JBoss Tools 3.x have a tool that will allow you to do this: see a view with all of your entity classes
select multiple entity classes in this diagram/view to form the basis of a HQL select statement automatically create the HQL and dump it in the HQL editor (assuming Hibernate console is setup). And you go from there. For example, I have this native query I'm trying to "reverse engineer" to HQL. It would be nice to have the above tool: select er.equipmentRepairId, | e.serialNumber, | ddv.description, | sum(erc.cost) as Cost | from Equipment as e | inner join EquipmentRepair as er on er.equipmentId = e.equipmentId | left outer join EquipmentRepairCost as erc on er.equipmentRepairId = erc.equipmentRepairId | left outer join DropDownValue as ddv on er.equipmentRepairTypeCode = ddv.code | left outer join DropDown as dd on dd.listId = ddv.listId | where e.serialNumber = :serialNumber and | dd.listName = :repairTypeDropDown | group by er.equipmentRepairId, | e.serialNumber, | ddv.description View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4217661#4217661 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4217661 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
