I want to search records by input a long string containing a sub-string that is equal to value of a field.
For example, I have a field "trackingnum" (stock.picking model) and it is "TN1234". I input a longer string "xyzTN1234*abc" and search out related records with the same field value "TN1234" .
Is any expert here that could help? Thank you.