Highlighted
Super Contributor.. Super Contributor..
Super Contributor..
1400 views

Filter NULL events

Jump to solution

Hi All,

At the smart Connector level, I am trying to filter out events that has NULL value in the name or message field.  I have so far tried the following and have not got it to work.

name is NULL

message is NULL

name = ""

message = ""

Any help in this matter would be very much appreciated.

Thank you

Murali

Labels (1)
0 Likes
1 Solution

Accepted Solutions
Highlighted
Trusted Contributor.
Trusted Contributor.

(name Is "NULL")

Match the case exactly and use plain (not accented) quotations. This works on ConApp 6.4.0.6881.3 with SC 7.0.5.

View solution in original post

0 Likes
3 Replies
Highlighted
Absent Member.
Absent Member.

Did you try allowing event that name is NOT NULL?

0 Likes
Highlighted
Trusted Contributor.
Trusted Contributor.

(name Is "NULL")

Match the case exactly and use plain (not accented) quotations. This works on ConApp 6.4.0.6881.3 with SC 7.0.5.

View solution in original post

0 Likes
Highlighted
Super Contributor.. Super Contributor..
Super Contributor..

Hi Martin/auchentoshan,

Both solutions worked :-).

Thank you

Murali

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.