Joanna2
October 25, 2023, 1:03am
1
Hi,
Can anyone please help! Attached is the data table that i extracted to UiPath as a datatable.
I will be using for each row in datatable, to search for if parameter set is “AsOf_1MthAgo” and start time is the latest, and click on the “View Result” and continue to the next activity.
Please help thankyou!
Anil_G
October 25, 2023, 2:31am
2
@Joanna2
Did you happen to try this
@Joanna2
Use the following and get the latest job ID
Dt.AsEnumerable.Where(function(x) x("Parameter set").ToString.Equals("AsOf11monthsAgo")).OrderByDescending(function(x) DateTime.Parse(x("Starttime").ToString,"MMM dd, yyyy hh:mm:ss tt",System.Globalization.CultureInfo.InvariantCulture))(0)("JobID").ToString
Now use the above job id as variable in the innertext property of the column
Selector looks like this
<webctrl tag='TD' tablecol='7' innertext='{{jobidvariable}}' />
Cheers
Cheers
Joanna2
October 25, 2023, 6:14am
3
Hi, the jobid is not extracted into the datatable. Only 2 columns, which is the start time and parameter set.
Anil_G
October 25, 2023, 2:53pm
4
@Joanna2
Can I see what you tried?
Why not extract job id as well…if not you can use start time also instead of job ID in above query and it would still work
Cheers
