Question

What kind of wildcards does the Mendix platform supports on search fields?

7

I know we have wildcards on searchfields (e.g. %). Can someone give me an overview of ALL the wildcards the Mendix platform supports? Thanks

asked 2010-06-11

Jornt Moerland

4 answers

3

The same wildcards as SQL, so that would mean "%" and "*", if I'm not mistaken.

answered 2010-06-14

Achiel

2

And another tip is what to do when you want to search for "_" for instance. You can escape the character with a "\". So "\_" will find all the underscores in your search.

Regards,

Ronald

answered 2014-05-21

Ronald Catersels

1

Would be great to use operator > < as well!

This would allow you to search on greater then or smaller then or even reaches.

answered 2014-05-21

Andries Smit

Jacco Feenstra · Accepted Answer · 2010-06-14

Search is fulltext search and SQL wildcards as "_", "%'', are therefore not needed.

Since Mendix does not perform properly on wildcards as "!", and "*", I think Mendix does not use SQL wildcards, but substitutes characters like "_" and "%''.

I am not sure whether your answer is right.