Question
Infosys
US
Last activity: 11 Mar 2021 11:13 EST
Passing parameters to Data Flow
Hi
I have a data flow collecting data from database. This serves as source for my other data flow, where i filter based on different conditions and create multiple data sets.
I want to be able to configure the filters in the dataflow - Can i pass any parameters to the data flow which i can use in the filter?
eg. Filter by customer id where i will be having an ability to pass the customer id from an activity which is invoking this dataflow.
Thanks in advance!
Pegasystems Inc.
IN
Capgemini
US
Our objective is to process around 30K customer feedback records from Interaction History and update pxAdaptiveAnalytics and pxInteractionHistory datasets. We are using an agent to do this processing. The agent activity would be calling a data flow. The data flows calls a report definition with different time intervals of pxOutcomeTime. The OutcomeTime needs to be a parameter calculated from the agent activity and then passed into the report definition. We have been trying to pass the parameter from the activity to the data flow so that the parameter can be passed to the report definition.
We tried creating a page of the class Data-Decision-DDF-RunOptions and then set .pyCallParams.ParamName on the page. We are running the data flow using the DataFlow-Execute method, using the "Run defined with" option set to RunID. Changed this option to use "Run Options" and supplied the page of the class Data-Decision-DDF-RunOptions. But we were not able to reference the value of the parameter inside the data flow.
Are we setting .pyCallParams.ParamName on the right step page? Please let us know what we are missing.
Thanks in advance!
Jaydeep Banerjee
Pegasystems Inc.
US
You are asking a pretty detailed technical question without much background on the real business objective. Rather than detail the technical objective of wanting parameters on DF, can you explain the overall business objective you are trying to accomplish. This hopefully will highlight why you are choosing data flow to accomplish this and if that is the right approach for the overall business problem.
Updated: 24 Jun 2020 6:01 EDT
Pegasystems Inc.
GB
Hi Praveen. Did you solve this problem? We are also working on a very similar issue - implementing a Data Flow to export IH records to a file for hand-off to a data warehouse.
We are currently basing the data source on a Report Definition, and have parameterised the RD with a 'date boundary' to only include new record since the last execution, but have not identified how to source or pass this parameter from the Data Flow. I am inclined to modify the RD filter criteria to reference a Data Page where we can maintain the execution history.
Unless you have any other suggestions?
EY
US
@healj Hello,
did you get any solution for your scenario? We ran into similar requirement where we need to filter data flow source report definition based on param values.
Thanks Soumyajit
Hi,
Can you try passing parameter to data flow in activity using property set to set .pyCallParams.ParamName = "abc" value.Then in data flow you can refer Param.paramName value.
Hope this works for your scenario.
Thanks,
Deepak Katari.