What does Like in Filter mean

ERPNext
1

There is a relationship called “Like” in ERPNext.

image
image1194×581 106 KB

What does it mean. How is it different from Equals and other operators? What does “Not Like” mean?

2

It is actually a MySQL filter. It is used when searching a field that contains similar words or part of a word.

For example,

`Title` Like '%supplier%'

will return all the documents that has the word supplier in the field Title.

You can use the % (percentage symbol) to define the position of the word.

  • %supplier will return the documents with the word supplier at the end,

  • supplier% will return those with the word supplier at the beginning,

  • and %supplier% will search for the word supplier anywhere in the field.

3 Likes