Portal Filter for Field Contains Keyword NOT equals, is it possible?
I want to filter a portal to show only the records that have the keyword Director in the first column in the related table.
I can make the portal show the records when the field equals Director but it doesn't show them if the field is, for example, "senior operations director."
I have a lot of records with a lot of different titles for director, other examples would be "marketing director" etc. So making a list of all the keywords it should be equal to is a very very long way around this issue.