Subscribe Bookmark RSS Feed

where() clause with Contains() in Data Filter

vitali_pom

Community Trekker

Joined:

Jul 10, 2014

Hi,

When I try to do the following, I get an exception:


dt1 << Data Filter(


  add Filter(


  columns(:MyCol),


  Where( contains(:MyCol, "A12") > 0)


  ),


  mode(show(1))


) << invert row selection;



And I get the following exception:


The WHERE clause has not been correctly specified. in access or evaluation of 'Greater'



How to accomplish what the code tries to do properly?

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

Figured it out:

I guess the problem is that Data Filter Doesn't understand anything but explicit comparison (==) between columns and strings, just like it's GUI.

What I found as the solution is selecting the rows with Select Where().

1 REPLY
Solution

Figured it out:

I guess the problem is that Data Filter Doesn't understand anything but explicit comparison (==) between columns and strings, just like it's GUI.

What I found as the solution is selecting the rows with Select Where().