How can I connect to the built-in database and execute a fuzzy search sql query on it?
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.
Would using OQL work for you? This is supported by Mendix.