setFilter Function
-
jchiu_(Guest)
- Posts: 3
- Joined: Tue Oct 10, 2017 12:44 pm
setFilter Function
Has anyone used the setFilter function to set a filter with wildcard? I can^t seem to get it to work.____setFilter(hRpt, (LPCSTR) "LineName is like ^xyz*^");__
=> RE: setFilter Function
>Has anyone used the setFilter function __>to set a filter with __>wildcard? I can^t seem __>to get it to work. __>__>__>setFilter(hRpt, (LPCSTR) "LineName is like ^xyz*^"); __>______Use the expression:__setFilter(hRpt, (LPCSTR) "LIKE(^xyz*^,LineName)"); ____setFilter uses R&R calculated field syntax.__You also need to have setFilterUsage set to "O" to enable the processing of setFilter.____Kathleen__R&R Support
-
jchiu_(Guest)
- Posts: 3
- Joined: Tue Oct 10, 2017 12:44 pm
==> RE: setFilter Function
It worked as you discribed. Now I am trying to add a date to the filter string using calculated field systax and I can^t get it to work.__bStat = setFilter(hRpt,(LPCSTR) "LIKE(^Feed*^,linename) and InstallDate = {3/17/73}");____Thanks.