How would I go about translating the Where clause in the following SQL into a VB script factory filter condition?
<font class="small">Code:</font><hr /><pre>
Select * From BUG
Where BG_USER_01 LIKE '%P0007868%' OR BG_USER_01 LIKE '%P0008069%' OR BG_USER_01 LIKE '%P0008072%' OR BG_USER_11 LIKE '%P0008263%'
Thus giving two questions:
1) Is it possible to use multiple filters on the same field before performing a newlist command?
2) Is it possible to use regular expressions on a filter field?
OTA filters work the same way as the filters in the UI. You need to use an asterisk, and don't forget to wrap strings with spaces in double quotes.
There are lots of posts about filters in this forum.
... just another Tester ...
Is there a way to use AND / OR / NOT in filters in the Filter collection
oBugFilter1.Filter("BG_STATUS")= Closed or Open ' in this way