Filter Field Where Value Contain Word

[Community_Admin]

Question:

Is there any kind of way that allows me to filter a field based on "contains word" criteria.

Answer:

You can set such a thing as a filter on a dashboard, widget, or formula on any dashboard

JAQL syntax

{
"contains": "mm"
}

You can also use 'like' in the advanced option of the filter:

{
"like": "%black%"
}