asked on April 8, 2019
•
Show version history
I am looking for a way in a Workflow Script activity to retrieve and process query results without first doing a For Each Row activity to load another multi value token. What would be the token syntax to retrieve all values in a column token or value at an index of a column token?
Dim sQueryCount As String Dim iQueryCount As Integer Dim oCurrentValue As Object Try Dim QueryColumn as Object = GetTokenValue("QueryData_Column1") 'needs syntax to get all Dim ValueList As List(Of Object) = New List(Of Object) sQueryCount = GetTokenValue("QueryData_Result Count") If Integer.TryParse(sQueryCount, iQueryCount) Then For iIndex As Integer = 1 to iQueryCount oCurrentValue = GetTokenValue("QueryData_Column1") ' needs to be indexed to iIndex ValueList.Add(oCurrentValue) Next End If Catch ex as Exception WorkflowApi.TrackError(rx.Message) End Try
0
0