Skip to Main Content
Cumulocity IoT Feedback Portal
Status Unlikely to support
Categories Data at Rest
Created by Guest
Created on Aug 1, 2019

Case insensitive queries on API

Do queries on managed objects with third party integrated data, which does not always underlie a defined semantic. For instance do a query for all devices having a specific property value of abc or Abc or ABC etc.

  • Attach files
  • Admin
    Jane Porter
    Reply
    |
    Mar 28, 2022

    Hi Marco,

    Thank you for raising this request, it has been evaluated and rejected for the following reasons:

    1. Case sensitivity is dependant upon the underlying database.

    2. Switching between case sensitive and case insensitive would mean indices cannot be used - this would give an immediate performance degredation.

    Regards, Jane.

  • Admin
    Nikolaus Neuerburg
    Reply
    |
    Aug 2, 2019

    Hi Marco, as discussed some time ago that is currently not in plan.