Dynamic Query [Help Required]

[sathya prakash A, geändert vor 9 Jahren.]

Hi ,

I want to fetch the last seven days record from database like From Current date to SYSDATE -7 ..

How to do it by using dynamic query API.

Regards,
Sathyaprakash A

[Andew Jardine, geändert vor 9 Jahren.]

Hi Sathya,

Last 7 days of which records? All of them? or something specific?

[Tanweer Ahmed ., geändert vor 1 Jahr.]

Hi Sathya,

Here is what I did to get the AuditEvent Records between two dates.

final DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(AuditEvent.class, classLoader);
dynamicQuery.add(RestrictionsFactoryUtil.between("createDate", lowerDate, higherDate));
List<auditevent> auditEventList = AuditEventLocalServiceUtil.dynamicQuery(dynamicQuery);</auditevent>

You can create and call your own Entity instead of AuditEvent.The lowerDate/higherDate should be of Date type.

-Tanweer