4 Replies Latest reply on May 25, 2012 12:14 AM by Tamilselvi Dhandapani

    How to apply date functions or TO_CHAR funstions for an audited timestamp column?

    Tamilselvi Dhandapani Newbie

      Hi,

      Am new to envers and i am struck with an issue related to date funtions.

      In this case the insertdate column is stored as timestamp in the DB.

      But i want to apply the condition till seconds only so i need to put some date function to format the datecolumn.

       

      AuditReader reader = AuditReaderFactory.get(

      entityManager);

       

      AuditQuery query = reader.createQuery().forRevisionsOfEntity(getPersistentClass(),true,true);

       

      query.add(AuditEntity.id().eq(id));

      query.add(AuditEntity.revisionProperty("updatedDate").eq(date));

      in this case how can i apply the function to the revision property (updateddate)?

      Thanks in Advance.