There is a relationship called “Like” in ERPNext.
What does it mean. How is it different from Equals and other operators? What does “Not Like” mean?
There is a relationship called “Like” in ERPNext.
What does it mean. How is it different from Equals and other operators? What does “Not Like” mean?
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.