Forum Discussion

karimm's avatar
karimm
Helper III
5 years ago
Solved

Incremental refresh on api considering last modified date

Hi all,   I'm cretating reports based on JIRA data.  JIRA contains entities named "Issues" where each issue has fields of "Created" and "Updated" to identify when the issue was created and when it...
  • lbendlin's avatar
    5 years ago

    Incremental refresh expects immutable data. What you are looking for is differential refresh.

     

    One workaround is to make the refresh scope large enough so you can shoehorn your data into the incremental refresh partition paradigm.   Ask yourself what the average maximum period of time is that a issue change can still make a difference in your business process, and then set that as the change period for the incremental refresh (for example "last updated in the last three months".