0 Replies Latest reply on Jun 26, 2014 3:10 AM by Kamil Kłys

    [SOLVED] Order by @DiscriminatorColumn using AuditQuery

    Kamil Kłys Newbie

      Hi,

      Recentrly I needed to retrieve data from DB sorted by Discriminator Column and I'm stuck.

      Problem is, I haven't found any solution how to to this using AuditQuery.

      In simple HQL I could use (...) order by Entity.class, but how to do such thing in AQ?

       

      Here is the sample code of my entity class

      @Audited

      @Entity

      @Table(name = "something")

      @Inheritance(strategy=InheritanceType.SINGLE_TABLE)

      @DiscriminatorColumn(

          name="something_type",

          discriminatorType=DiscriminatorType.STRING

      )

      @DiscriminatorValue(Something.ENTITY_TYPE)

      public class Entity extends Something {

      (......)

      }

       

      I would be grateful for help

       

      SOLUTION

       

      Finally I found the solution. Looks like all you need to do is add order by "class", example


      query.addOrder(AuditEntity.property("class").asc())