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.

Add a new idea Subscribe
Status Ideas Contest
Categories InterSystems Products
Created by Ashok Kumar T
Created on Apr 26, 2025

RELATED IDEAS

built-in way to dynamically include all columns in JSON_OBJECT()

There’s currently no way to Dynamically include all columns in JSON_OBJECT() without manually listing them in the SQL query. However, Scalar function JSON_OBJECT not supported for stream fields

ex: SELECT JSON_OBJECT(t) FROM TABLE t / SELECT JSON_OBJECT(*) FROM TABLE t/ SELECT row_to_json(t) FROM TABLE t

Having this capability would be especially useful in SQL queries, as it would simplify working with JSON.

  • ADMIN RESPONSE
    May 9, 2025

    Thank you for submitting an idea for the Ideas contest. The status changed to "Ideas Contest".

    Please answer the experts' clarifying questions, if any, during the contest and voting period.

  • Post comment