Question

1
Replies
16
Views
Close popover
Nikolaos Alexiou (NikolaosA)
BAH

BAH
US
NikolaosA Member since 2020 3 posts
BAH
Posted: 4 weeks 1 day ago
Last activity: 4 weeks 1 day ago

TableView and LIKE Filter issue

I have a LookupTable with Field1 and Field2 columns.

I am trying to filter only the values that include characters B or C

This is the WHERE clause I tried to apply:

Field2 LIKE '[BC]'

However, when automation executes ApplyFilter I get the following Error:

Error executing link in Automation: Automation1 - From: Windows_Form1.btnGetCurrentValue.Click To: Windows_Form1.tableView1.ApplyFilter()

Error in Like operator: the string pattern '[BC]' is invalid.

I also tried using an input parameter for passing BC and I am still getting same message.

I have attached a screenshot of the setup. Is the above syntax for the filter not supported In Robotics? Per discussion here: https://collaborate.pega.com/question/filter-data-coming-excel-sheet-pega-robotics-studio, I reviewed https://www.csharp-examples.net/dataview-rowfilter/ but did not see any special exceptions to my expression.

I am using Pega Robot Studio 19.1.50.0.

Thank you,

Nikolaos

 

Pega Robotic Desktop Automation 19.1 Robotic Process Automation Technology Services Solutions Engineer