Select statement - conditions failed

[kristofm]

I'm trying to preview a select statement with conditions but when I get the results I see that that he doesn't give me the results as asked in the conditions.

The conditions are made in the query editor of the Pentaho Report Designer 3.6.0.
(Data - Metadata - Edit Query)
Also in the report I get the wrong data.


Who can help me?
Anyone got experience with rebuilding Business Object into Pentaho reporting?

[bamaer]

Goeiemiddag Kristof,

If you get wrong data, you probably have an incorrect join or something similar in your metadata model.
It may be quicker/easier to test your queries in the metadata editor's query editor before going to the report designer.

Cheers,

Bart

[X3n0n]

Or maybe the AND, AND, OR are the problem, with the priorities.