Body: <p>We created a report to list the contacts without a contactsubtype.
  Previously, it worked, since a recent update it no longer works.
  The report is based on a filter "contacsubtype is not one of" followed by a list of all contactsubtypes in use.
  What has changed?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-12-11T12:04:47.537Z
Comments.Text: What are the Civi versions where it does / does not work?
Comments.UserDisplayName: Aidan
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-12-11T12:30:37.607Z
Comments.Text: Now latest update 5.20. Previous about a year ago.
Comments.UserDisplayName: MarkDQ
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-12-12T06:50:38.757Z
Comments.Text: Which report template are you using?
Comments.UserDisplayName: Jaap Jansma - CiviCooP
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-12-16T21:45:03.313Z
Comments.Text: @JaapJansma-CiviCooP Contact report with filter ... (as mentionned in the question)
Comments.UserDisplayName: MarkDQ
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-12-19T13:03:48.310Z
Comments.Text: Do you have any technical knowledge? If so you can see whether the query generated is correct on the Developer tab of the report. If you think this is a bug in civicrm. You can file an issue on lab.civicrm.org. See https://docs.civicrm.org/dev/en/latest/tools/issue-tracking/#guidelines for how to do this.
Comments.UserDisplayName: Jaap Jansma - CiviCooP
Tags: <civireport>
Title: Filter no longer works in report
ThreadText: # Filter no longer works in report
  
  (Asked by: username_0 on 2019-12-10)
  
  We created a report to list the contacts without a contactsubtype.
  Previously, it worked, since a recent update it no longer works.
  The report is based on a filter "contacsubtype is not one of" followed by a list of all contactsubtypes in use.
  What has changed?
  
  **Tags:** civireport
  
  > **Comments:**
  > **username_1**: What are the Civi versions where it does / does not work?  
  > **username_0**: Now latest update 5.20. Previous about a year ago.  
  > **username_2**: Which report template are you using?  
  > **username_0**: @JaapJansma-CiviCooP Contact report with filter ... (as mentionned in the question)  
  > **username_2**: Do you have any technical knowledge? If so you can see whether the query generated is correct on the Developer tab of the report. If you think this is a bug in civicrm. You can file an issue on lab.civicrm.org. See https://docs.civicrm.org/dev/en/latest/tools/issue-tracking/#guidelines for how to do this.  
  
  ---
  
  ## 0 answers
  
  