Dynamic Query [Help Required]

[sathya prakash A, modificado 9 Anos atrás.]

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, modificado 9 Anos atrás.]

Hi Sathya,

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

[Tanweer Ahmed ., modificado 1 Ano atrás.]

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