Skip to Main Content
InterSystems Ideas

Have an idea, suggestion, or something that doesn’t work as expected in InterSystems products or services? Share it here on the InterSystems Ideas Portal.

The Ideas Portal is where community members can propose improvements, report bugs, and help influence the product roadmap across InterSystems products and the overall developer experience. 22% of submitted ideas are implemented by InterSystems or members of the Developer Community.

💡 Ideas and bugs are both welcome, no matter how big or small. You can submit feature requests, usability improvements, workflow suggestions, and bug reports. Whether you’re an experienced expert or just getting started, your fresh perspective is valuable.

🛠️ About bugs and fixes. If you have access to InterSystems WRC, please submit bugs there for immediate action. Bug reports submitted through the Ideas Portal are reviewed and tracked, but do not guarantee immediate resolution.

Start by sharing what could be better - the community and our teams will help take it from there.

Status Future consideration
Created by Ashok Kumar T
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
    Feb 6, 2025

    Thank you for submitting the idea. The status has been changed to "Future consideration".

    Stay tuned!