Skip to Content
0
Jul 26, 2016 at 03:39 PM

Sender JDBC Query Dynamically

597 Views

Hi Friends,

i have a requirement like, in SQL database we have 4 lakhs of records that consists last 30 days info.

from PI at first poll interval we need to fetch the current date - (minus) 30th day records

at second interval we need to fetch the current date - (minus)29th day records

current date - (minus) 28th day records

like wise i need to fetch up to current date - (minus) one day records.

NOTE: there is no flag field to update.

please provide any suggestions to achieve the same.

Regards,

Janardhan