Hi, I'm ExactTarget user and I have found some test case does not work when I use.
The first is filter with " and ",
The example is "LastName=Flintstone and FirstName = 'Wilma'" but when I tried
val response = dbUnsubscribe.select(s"EventDate >= $eventFrom and EventDate <= '$eventTo'", "order by EventDate"). There is no data return.
I found it's work when I change to val response = dbUnsubscribe.select(s"EventDate >= '$eventFrom' and EventDate <= '$eventTo'", "order by EventDate")
The second one is I add one example about filter by DateTime.
amagar088
commented
8 years ago
Hi, I'm ExactTarget user and I have found some test case does not work when I use. The first is filter with " and ",
The example is "LastName=Flintstone and FirstName = 'Wilma'" but when I tried val response = dbUnsubscribe.select(s"EventDate >= $eventFrom and EventDate <= '$eventTo'", "order by EventDate"). There is no data return. I found it's work when I change to val response = dbUnsubscribe.select(s"EventDate >= '$eventFrom' and EventDate <= '$eventTo'", "order by EventDate")
The second one is I add one example about filter by DateTime.