2 Replies Latest reply on Jul 29, 2009 2:14 PM by Varun Mehta

    Envers + HQL

    Varun Mehta Newbie

      I want to reference the _aud tables in an HQL, cos I know the version and the column I need to fetch the info from, but since there are no POJOs for _aud tables how do I go about creating an HQL, any suggestions ?

      SELECT new OrderLineitemSummary(
       orderLineitem.orderLineitemId,
       orderLineitem.order.orderId,
       orderLineitem.order.name,
       orderLineitem.catalogObject.catalogObjectId,
       orderLineitem.catalogObjectAud.name)
      FROM OrderLineitem orderLineitem


      Here OrderLineitem has references to CatalogObject & OrderLineitem internally (which are hibernate enitites), but there is no entity "CatalogObjectAud" any suggestions on how can I use it in an HQL, or I'll have to resort to SQL.