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 Proprietary information hidden.
Thank you,
Nikolaos
Pegasystems Inc.
JP
I think this needs 2 comparisons - using the csharp syntax to find B or C anywhere in the strings this would be:
Field2 LIKE '*B*' OR Field2 LIKE '*C*'
Note: some varients of SQL use * for the wildcard, others use %. This might depend upon your backend DB.