"Like" mapping does not validate question marks '?'
Hi all,
We have defined "like" mappings that look as follows:
CC_?? to CC_??
CC_??? to CC_???
The logic is clear: take everything starting by CC_ followed by 2 or characters and load it into the corresponding CC_xx or CC_xxx member.
The mappings work correctly so data is loaded where it should be, but they don't validate. The problem arises when power users try to migrate these mappings between environments. As per an internal policy, mapping migrations are performed with the "validate" option checked. As these don't validate, they fail to be migrated and have to be manually recreated. Not a big deal for an admin, but power users find this anoying.