It seems that any indexes (unique or otherwise) created in Creatio config are created to ignore case. This is not good from a data perspective, and prevents actual uniqueness checking in cases where the case of the characters matter. We need to be able to configure unique indexes to be case sensitive - I think ideally this would be the default option and you could check a checkbox in the config to ignore case if required, but certainly you should be able to generate normal database unique indexes which are case sensitive.
Do you like this idea?
1 comments
17:38 Jan 12, 2024
Hello,
Thank you for this idea, we will translate it to our developers and they will analyze what can be done.
Show all comments