@TanyaS58 Apologies, I misunderstood your question. Now, my understanding is you want to fetch some data using report definition and use it somewhere and don’t want to hit DB multiple times. I don’t think using only report definition, we can achieve such a requirement. If we really want to use only report definition in an activity and achieve it, While the activity is running for the first time copy the results of report definition into some temporary page. Whenever the activity runs for next time, check the condition to see if this temporary page is already populated and only run RD if this page is empty. This way it can reduce DB hits but only in that thread context as temporary pages are part of that thread. But this is highly not recommended, as there is a better option of data pages which are highly suitable is to serve these kind of requirements.
VVNagaSaiN
(V V Naga Sai Nuthalapati)
6
Related topics
| Conversation | Replies | Views | Activity | |
|---|---|---|---|---|
| Fetching data | 4 | 171 | December 1, 2023 | |
| How to map data after calling Report Definition from Activity | 6 | 1291 | June 5, 2023 | |
| Previous instance details are getting saved while using savable data page 25.1 constellation | 21 | 55 | May 25, 2026 | |
| RDB vs Report Defnition | 6 | 308 | October 1, 2022 | |
| When would you choose RDB-List over Report Definition in a high-performance system? | 5 | 43 | April 23, 2026 |