Hello,

I've created a metadata file with metadata editor to create ad hoc reports on the pentaho server.
When I try to create reports on the server I add a constraint not to select null values.

I get the following query generated :

SELECT DISTINCT
TABLEA.FIELDA
,TABLEB.FIELDB

FROM TABLEA LEFT OUTER JOIN TABLEB
ON ( TABLEA.field_ID" = TABLEB.field_id AND ( NOT( TABLEB.FIELDB IS NULL) ) )

instead of this one I would like to have:

SELECT DISTINCT
TABLEA.FIELDA
,TABLEB.FIELDB

FROM TABLEA LEFT OUTER JOIN TABLEB
ON ( TABLEA.field_ID" = TABLEB.field_id )

WHERE ( NOT( TABLEB.FIELDB IS NULL) )

how can I do to add a 'where ' clause in the ad hoc report?

thank you