Source filtering LIKE not working properly

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

Moderator
Staff member
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.
 
Top