Advanced List filters: 'is not' vs. does not contain'

I am trying to use a filter on a Relationship Type and want to exclude one type from my output.  If I use the 'is not' filter, I get an error.  If I instead use a 'does not contain' it works, but what I really want is the 'is not.'  

Interestingly this error is tied to the particular Relationship Object.  I had the Inner Join unchecked.  If I check the Inner Join, the 'is not' works!... but then I loose a couple lines of output because of the Inner Join, so not a good solution.

Please consider fixing the 'is not' filter so that it works with or without the Inner Join Object box checked.

  • Anne S.
  • Mar 2 2016
  • Attach files