Question
Looping through DataPage D_pyWorkHistory using For Each Embedded Page
I need to log the pyMemo Property of a WO and for this I am looping through the DataPage D_pyWorkHistory and am trying to retrieve the pyMemo property for each of the pxResults. My clipboard is shown below.
.
For this, I am calling the 'For Each Embedded Page' in an activity as shown below and my step page is "D_pyWorkHistory.pxResults".
I am unable to access properties on the pxResults page and my tracer is showing the following for the above step.
Not sure why Tracer is showing the following
Note | RDB operation returned result set with 0 rows |
Q1.) As my results are already present on DataPage "D_pyWorkHistory" and I have "pxResults" page, why is my activity calling the SQL statement again?
Q2.) More importantly why is my result count zero, when I do have results on my D_pyWorkHistory Datapage for the WO.
Q3.) How do I access any property on the "D_pyWorkHistory.pxResults" page.
Any help in this regard would be appreciated.
The page in the clipboard has a parameter and so the datapage returns a finite set of results.
The page in the activity doesn't have a parameter which will be trying to pull the entire table and can timeout not returning any.
Try passing the parameter to the datapage in the step page of the activity. This should pull the data as shown in the clipboard.