We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Fetch only new or updated data from Last run

Received Response
24
Views
1
Comments
edited Mar 12, 2021 2:05PM in Reporting and Analytics for SCM 1 comment

Content

Hi All,

I am very new to Reporting hence need help to devlop report to fetch only incremental data.

Report Logic:

1) Report will be called by Webservice by passing parameters.

2) Report will fetch data from tabel inv_material_txns and pass Work Order number to wie_work_orders_b to fetch Work order & Work order type.

I have created basic SQL to fetch data. But I am not able to figure out how to fetch only incremental data from last RUN. i.e report should fetch only data that is new;y created or updated since last run of this report.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!