InterSystems Developer Community

🌟 Meet BAS — an AI-powered climate action matcher built on InterSystems IRIS Vector Search.

BAS connects companies with UN-catalogued Cooperative Climate Initiatives, peer corporate actions, and sustainability reports from similar companies. The goal: turn climate ambition into concrete corporate action. Built in partnership with Race to Zero, the tool stores 172 climate initiatives and over 17,000 paragraphs from real sustainability reports 😄

Read the full story 👇
https://community.intersystems.com/post/iris-vector-search-climate-matching-introducing-bas

👋 Round 1 of the Community Bounty Program "Idea to Application" builds up the steam 🔥

Now is your chance to turn community-requested features into Open Exchange solutions and earn rewards along the way. Submit your app and receive 10k+ Global Masters points, badges and community recognition 🏅

🛠️ Current challenge ideas:
• Support for redoc for IRIS REST APIs
• Generate OpenAPI / Swagger Specification from FHIR Capability Statement
• Example of PyProd

⏰ Deadline: June 30, 2026

📋 Find more details here: https://community.intersystems.com/post/community-bounty-program-idea-application-%E2%80%94-round-1-live

Solve a community need. Build something useful. Have fun with it 💡

At , we explored how data-driven intelligence is transforming supply chain operations, enabling smarter decisions and more resilient performance.

Watch this to discover:
✅ How InterSystems solutions leverage -powered analytics and low-code data integration to address complex supply chain challenges.
✅ How real-time insights improve medical fulfillment, reduce procedure cancellations, and enhance service levels.
✅ How better data management drives more efficient, responsive supply chain operations.

https://community.intersystems.com/post/video-solving-supply-chain-challenges-data-driven-intelligence

See how advanced are helping organizations turn supply chain complexity into a strategic advantage!

🤠 Ever written a SQL query so deeply nested it took you ten minutes just to remember what it was doing?

Common Table Expressions (CTEs) in InterSystems IRIS SQL exist exactly for this reason. Using the WITH clause, you can break complex queries into named, readable steps — and the IRIS optimizer treats the whole thing as a single unified ex*****on plan anyway. So you get clarity without trading away performance.

The article walks through how predicate pushdown works (with actual ex*****on plans to compare), when to use a temporary table instead, and one key limitation worth knowing: IRIS CTEs don't currently support recursion — for hierarchical or iterative logic you'll need self-joins, staging tables, or ObjectScript 😄

Five copy-paste-ready examples included.

Read the full breakdown 👇 https://community.intersystems.com/post/common-table-expressions-ctes-intersystems-iris-sql

At , we explored how the InterSystems Package Manager (IPM) is evolving to support modern distribution models through ORAS and OCI-compliant registries.

Watch this to discover:

✅ How IPM leverages ORAS to publish and install solutions via industry-standard registries like Artifactory and Nexus.
✅ How InterSystems is using this approach to distribute its own software, and how you can apply the same strategy.

https://community.intersystems.com/post/video-deploying-solutions-using-intersystems-package-manager

Learn how standardized package distribution can streamline delivery and improve consistency across environments.