Increase Filtering Critera Options for Data Lists

I would like to be able to use "Contains" and "One Of" as filtering criteria for Data List text fields as I do now for Ad Hoc Queries.  We share queries with other members of the organization by making Pages containing Data Lists.  The extremely limited filtering options on the Data Lists limits their functionality for us. Thank you!

  • Lori Thompson
  • Jan 25 2016
  • Reviewed: Voting Open
Blackbaud CRM / Query
Organization Name (Please enter full organization name) American Heart Association
Reported Version 4.0
  • Attach files
  • Lori Thompson commented
    July 29, 2019 17:12

    Although we are now moving most of our data analysis and reporting to Excel and Tableau, it really would be nice to be able to have better filter criteria, especially as noted below, for Blank and Not Blank.  

    Attachments Open full size
  • David Bourne commented
    July 29, 2019 06:10

    Hi Lori

    We've discovered that the "Equal To" data list filter operator acts as a Contains. It's just the label that is wrong... I hope that helps.

    Attachments Open full size
  • Guest commented
    February 16, 2017 21:55

    This would also be great for ListBuilders! Currently, text/String columns can just be searched for one search term. Filters from Ad-hoc that would be helpful to ListBuilders are: "Not Blank" and "Blank". Sorting helps with blanks, but in some cases, only records with blanks in a certain column need to be shown.

    Attachments Open full size

Related ideas