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(
      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.