Question

testing oql

0

Hi, I wrote a oql query, the system compile without error but when I open the report I receive an error. I'd like to test the query without running the page but I don't know a "testing button" please, may you help me? thanks luca

asked 2016-08-03

luca caruso

3 answers

Eric Tieniber · Answer 1 · 2016-08-04

I'm not aware of a built-in way to test your OQL.

That said, there is a Java method in the API: retrieveOQLDataTable that can run an OQL query passed in as a string. You could use this in a custom Java action, which you could hook to a page and test your OQL at runtime.

Make sure you secure access to this page, as it would technically allow you to query any data from your application's database.

Chris de Gelder · Answer 2 · 2016-08-04

Set the OQL log node on trace

Herbert Vuijk · Answer 3 · 2016-08-08

Reporting for Mendix From the appstore has a test tool/page.