Question

Infosys
IN
Last activity: 2 Apr 2025 14:21 EDT
Parameterized Data Page not working as intended
We have a requirement to get data from CDH if it is not present in the datatype already. For this requirement, we're using a datapage in a datatransform. Configured the data page(scope: thread) to use a report definition, where we've enabled the checkbox to 'use null if empty' for the filter conditions.
When: @Utilities.LengthOfPageList(D_page[Param:Primary.param...].pxResults)<1, will call an activity Otherwise When: @Utilities.LengthOfPageList(D_page[Param:Primary.param...].pxResults)>=1, will fetch the data and map it to a pagelist. Initially we do not have any data, so, When condition returns true, we make a CDH call, and map the data to datatype. After this, we need to fetch a particular value from the first record in datatype if it is empty in clipboard, which it is initially. For this requirement, I used the same D_page again, but I need to check if the data is present first, so I used @Utilities.LengthOfPageList(D_page[Param:Primary:param...].pxResults)>=1. But, this time this returns false, even though the records are there, and the parameters matching as well, at least that's what I thought. What am I doing wrong?