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.

Add LOWER() and UPPER() options to Luminate Online Query Language

Currently WHERE conditions are case sensitive when querying the Luminate Online web services.

For example, SELECT * FROM Constituent WHERE PrimaryEmail = 'john.smith@test.com' will not return any results if the value in Luminate Online is set to 'John.Smith@test.com'.

It would be useful to have LOWER() and/or UPPER() options so that matching can be performed when casing does not match.

For example, SELECT * FROM Constituent WHERE LOWER(PrimaryEmail) = 'john.smith@test.com' would return a result if the value in Luminate Online is set to 'John.Smith@test.com'.

  • Adam Lemelin
  • Aug 23 2019
Org/Company Name ALSAC
  • Attach files

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