Filter out datasets with empty field

[Former Member]

Hi Experts,

I want to filter a Table: Filter out all datasets where the FieldXY is empty. I tried with the filteroperator with expressions like '... is equal to NOT NULL' or '... is equal to NOT ''', but without result! Can some one give me the right expression?

Kind regards, Bernd

[Former Member]

Hi Bernd,

Have you tried defining the following expression in the Field column of the Define Filter dialog?

=!ISNULL(@FieldXY)

Best regards,

Udi

[Former Member]

Hi Udi,

I tried it (again?): (@FieldXY is equal to

=!ISNULL(@FieldXY)

and

!ISNULL(@FieldXY)

but it doesn't work: I get an empty table.

I have NW CE with SP04 and use the Flex Dynpros.

Any more ideas?

Regards, Bernd

[Former Member]

Hi Bernd,

This was a bug in SP04

I tried the

=!ISNULL(@FieldXY)

on SP05 and it worked.

Sorry for the confusion.

Best Regards,

Udi

[Former Member]

Hi Udi,

thanks for the answer. I will try it after the update to SP5. I will answer than again.

Thanks, Bernd