In Electronic reporting How do I filter where a field not equal to null

(1) Share

Report

Posted on by Sophs@4Sight

223

I need to update a Electronic report but filter on a table where the comment field not equal null. Only show records where the comment field contains a value.

What is the syntax to Filter(TableRecords. CommentTable, TableRecords.CommentTable.Comment != "")

The != gives an error

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (2)

Answers (1)

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Please tell us what error you're getting.

By the way, an empty string and a null reference are two different things. But you seem to really want an empty string (""), not null.

Was this reply helpful? Yes No
Verified answer

Sophs@4Sight 223 on at

Like (0)

Report

Thank you I found the answer. The correct way is (TableRecords. CommentTable, TableRecords.CommentTable.Comment <> "")

Was this reply helpful? Yes No