I have put the extract of the “MI5” Work Items (sequence “InitAllApplications”) in a DataTable using an Assign like this:
WIList_Filter = WIList.Select(“Type=‘WI5’ AND Status = ‘Open’”).CopyToDataTable()
So far so good.
But when it comes to proceed with the walk through of the records in the next sequence - “GetTransactionData” I have problems passing the DataTable as an argument.
Data Table arguments dont seem to have Default values?
I know that I can create the extract as Data Rows, but I’m trying to go ahead with the DataTable format.
Isn’t it possible to pass the argument as a DataTable?
If you will pass the value as a datatable you will have to change the type of the variable to datatable instead of row.
But to advice, if you do that the logic of using the framework will not be there as we process for each of the array rows that we have and pass datarow each time to be processed so that if it fails it will retry and do accordingly
Otherwise i dont really see why you will want to pass the whole table to the process and then loop and process it
You cannot set a default value however when you say send as argument you have to create an out dt type and then assign the argument the dt value.
Reason its not static and you will not be able to set the value(that is why you are getting null)
You will have to create dt data then send it across correct
Im now using a DataRow to store my filtered rows. Works fine in the InitAllApplications workflow and I get the filter ok
But Im still having problems PASSING these DataRows to the logic after invoking that flow
This is the “Edit argument” section from the Invoke:
This Write Line doesnt get any value for WIList_Filter_AsRows2
"3. This is the number of rows I get (in Init): " & WIList_Filter_AsRows2.Count.ToString
Inside the InitAllApplications have you assigned the value to ‘WIList_Filter_AsRows2’ out argument?
And in the workflow where you have write lines, what is WIList_Filter_AsRows2 as variable or argument?
My problem is that “WIList_Filter_AsRows2” doesnt get its value when its imported in the “Invoke activity”.
This is obviously because I do something wrong.
My first attempt was to pass “WIList_Filter_AsRows” but that didnt work - hence the use of “WIList_Filter_AsRows2”.
Yes, I do have a variable “WIList_Filter_AsRows” declared as DataRow in InitAllApplications.
Does this mean that the variable declaration takes precedence over the Assign activity in the same flow?