Is there a way to manipulate a string from a user_attribute to use with an access filter?
I currently receive a attribute in the form of a simple string ‘1.1.1’.
I need append a ‘.%’ to such value, as exemplified below, so I can use in a LIKE operation.
user_attribute: CONCAT(hierarchy, ‘.%’)
Things to consider:
- I can't change the received parameter. Receiving it with ‘.%’ would already solve the problem.
- I can't use sql_always_where, cause this explorer extends another, which already uses it (can't override)
Best answer by fabioView original