Source filtering LIKE not working properly

Discussion in 'RFID Software Technical Questions' started by JCSantaella, Oct 30, 2015.

  1. JCSantaella

    JCSantaella Member

    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.

  2. Howie Heckman III

    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.
  3. JCSantaella

    JCSantaella Member

    Hello Howie,

    It worked! Thank you for you help.


Share This Page