Wildcard for special character in Xpath? (à instead of a for example)
I need to do a search through Xpath (directly in the database or through microflow) where I want to search with a string on an attribute. This attribute might contain special characters, such as 'à’. Is it possible to somehow to do a wildcard search or searching for 'a' and returning values that contain 'à’? I can't seem to find this option and manually trying to create a flexibel search microflow seems both complicated and bad for performance.
Sytze de Bok
As far as I know this is not possible. Probably the easiest solution would be to duplicate the attribute and replace all 'à’ with normal ‘a’ then use this duplicate attribute to search.
Another approach would be to use Xpath like this:
where ‘text’ is the name of an attribute on my entity. Then you can add all the characters you need to search for.