Observed bug in 21.10 version of Studio and Robot
We have previously used the Filter Datatable activity in combination with inbuilt methods to help in comparing the values of the column.
In the earlier version upto 21.4 Studio and Robot, we could use this following syntax in the Filter Datatable activity but from 21.10 versions this feature does not return the correct results.
Here for example the Column Field allows use of methods
"Column1".ToLower.Trim and use this value to compare, if met, remove the row. Essentiall, for every row in “Column1” perform
.ToLower.Trim operations and then compare.
After filtering (incorrect result)
The output should only result in the last two rows
Text Again,4 Text Whitespaces ,5
This feature was very handy, now we have to look into other forms of filtering, which increases developer overhead. Some of our processes which are run on older version of robot have run without any failures for the last 1.5 years.
We have tested this both in Debug mode and robot execution mode, both do not respect the added methods (in this case “Column1”.ToLower.Trim in the Column field )
Could this feature be reinstated in the upcoming stable version of Studio/Robot?
Here is the sample file for your tests :
FilterDatatableMissingFeature.xaml (10.0 KB)
Thank you for your efforts and consideration.