Source filtering LIKE not working properly

[JCSantaella]

Hello everyone!

I am trying to filter tags from source using the EPC field.

Lets say my tag EFC is 00027.
if I add the filter: EPC LIKE 7, no results are stored in destination, but if I change the filter to: EPC LIKE 00027 results are stored in destination. Any ideas ? Am I doing something wrong?

Thanks for your help.

JC

 

[Howie Heckman III]

Hi JC,

Sounds like you need to wrap the search value in %. This will do a soft search for the value. If you do not do this it will simply do a case insensitive string comparison.

Try changing it to EPC LIKE %7%

Let us know if this helps.

 

[JCSantaella]

Hello Howie,

It worked! Thank you for you help.

JC