Highlighted
Absent Member.
Absent Member.
11957 views

Report filter on null field values


In teamtrack, is it possible to include a report search filter that looks for a field with empty/blank/null values? this is a text field, so only container, like, not container, not like are available as operators. I have attempted all variations of "like NULL", "contains '*'", "not contains '.'" etc.
0 Likes
3 Replies
Highlighted
Absent Member.
Absent Member.

Re: Report filter on null field values


There is currently an enhancement request for what you would like to do using basic conditions. You can only use advanced SQL conditions to filter for null values at this time.
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: Report filter on null field values


thanks for the quick reply. will be looking for the new product/patch in the future
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: Report filter on null field values


Try to do an advanced sql report and use something like WHERE MyTextField IS NOT NULL
or
WHERE MyTextField <>''
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.