Welcome to Luminate Ideas!

Please submit all product enhancement ideas below. We welcome your feedback; your ideas will be reviewed by the Product Manager that oversees the development of that part of the product on an ongoing basis and updated with its current status monthly based on our product planning process. Ideas you submit could help us shape features currently in development or grow our repository of requirements for our next big enhancement. Thank you for taking the time to share your thoughts and expertise with us.

If you believe you are experiencing a defect please contact Support.

Case sensitivity in queries

I've noticed that when we query on country=United States, anyone with UNITED STATES (all caps) is not picked up in query results. Could queries be changed so case wouldn't matter? We are trying to clean up the data on our side so this isn't an issue, but I doubt it will ever be perfect and we'll always miss someone.

  • Deleted User
  • Mar 31 2015
  • Reviewed: Voting Open
Area of the Product Database
Org/Company Name People for the Ethical Treatment of Animals, Inc.
  • Attach files
  • Guest commented
    May 26, 2015 16:19
    This is another huge issue for us. For example, if one of our admins uses "Facebook" in a sourcecode instead of "facebook", then all of the reporting/querying on our Facebook marketing program is broken. We waste a lot of staff time going back and trying to think of all the possible permutations of caps/lower and bloating up all of our queries with "OR" statements -- in addition to being a waste of staff time, this is also a huge waste of computing resources BTW. All queries should be case INsensitive!

Privacy Policy | Safe Harbor Notice | Terms of Use | Acceptable Use Policy | © 2019 Blackbaud, Inc. All Rights Reserved