Question

XPath Constraints

0

I am using an xpath constraint to retrieve an entity from the database such as [code = $code] It appears that the comparison is NOT case sensitive. How can I get a case sensitive comparison ?

asked 2020-05-19

John Chant

3 answers

Gerrit Kiefer · Answer 1 · 2020-05-19

Which database did you use? Do you use the file based database or postgres?

Robert Price · Answer 2 · 2020-05-21

I would suggest you create an extra field with a lowercase version of the code, and search against this. You then know it will always be in a fixed format. You can set this automatically in a Before Commit microflow.

Ronald Catersels · Answer 3 · 2020-05-21

Mendix is busy improving the documentation on this because it depends on the database you are using. You can already do a sneak preview on the documentation they are working on here: https://github.com/mendix/docs/pull/2477/files

Regards,

Ronald