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...
Need Help
  • lbendlin's avatar
    lbendlin
    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".

Sofim86's avatar
Sofim86
Frequent Visitor
3 years ago

Hi all! Could anyone share with me how to set incremental refresh upon Jira API? because as far as I know, you can't set it on nonfoldable queries. I really appreciate your help!

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago
    as far as I know, you can't set it on nonfoldable queries.

    That is inaccurate.  Folding is desired but not mandatory.  All you need is a DateTime or Date Integer value that can be compared against RangeStart and RangeEnd.