This content has been marked as final.
Show 4 replies
-
1. Re: How to apply date functions or TO_CHAR funstions for an audited timestamp column?
adamw Feb 27, 2012 4:53 PM (in response to swetha.dts)In the generated SQL? I don't think that's possible yet. Please file a JIRA feature request.
Adam
-
2. Re: How to apply date functions or TO_CHAR funstions for an audited timestamp column?
swetha.dts Feb 28, 2012 5:04 AM (in response to adamw)Thanks Adam.
I have accomplished the same by adding two times the date proerty as ge and also le of the date.
Again one more issue in my case is, can i somehow pass in my query builder to take the maximum value of the revision along with my where clause?
Is there a way to get the result based on the maximum of the revision number?
Please help.
-
3. Re: How to apply date functions or TO_CHAR funstions for an audited timestamp column?
adamw Feb 29, 2012 11:47 AM (in response to swetha.dts)You want to find the maximum revision number? Try adding a projection: AuditEntity.revisionNumber().max()
Adam
-
4. Re: How to apply date functions or TO_CHAR funstions for an audited timestamp column?
swetha.dts May 25, 2012 12:14 AM (in response to adamw)Thanks Adam , the same worked.