How can I connect to the built-in database and execute a fuzzy search sql query on it?

0
I am using the built-in database and I need to be able to implement fuzzy searches. Fuzzy searches are not possible through xpath, but are in sql, and the built-in database is postgre sql. I have tried using the database connector, but am not sure what the jdbc connection string would be, nor what the username or password would be.
asked
2 answers
1

Would using OQL work for you? This is supported by Mendix.

https://docs.mendix.com/refguide/oql/
https://marketplace.mendix.com/link/component/66876

answered
0

Could you not use contains, starts with, and/or ends with in an XPath constraint?

 

https://docs.mendix.com/refguide/xpath-contains/

https://docs.mendix.com/refguide/xpath-starts-with/

https://docs.mendix.com/refguide/xpath-ends-with/

 

answered