Skip to Main Content
InterSystems Ideas
We love hearing from our users. Tell us what you want to see next and upvote ideas from the community.
* Bugs and troubleshooting should as usual go through InterSystems support.
Status Needs review
Created by Ashok Kumar
Created on Jan 8, 2025

Native JSON Datatype exclusively for JSON

Create a built-in native JSON datatype like "%Library.String" and implement the SQL JSON_ functions natively. Store, retrieve, search, validate by schema and update the before save and save JSON values instead of store into

%String - we can't store large size JSON due to maxlength(3 million chars) %Stream.GlboalCharacter - unable to utilize the JSON_TABLE or other SQL function directly(use substring to extract first and use JSON_TABLE).

This would be useful.

  • ADMIN RESPONSE
    Jan 8, 2025

    Thank you for submitting the idea. The status has been changed to "Needs review".

    Stay tuned!