#Other

Hi Community!

We're happy to share the next video in the series dedicated to Gen AI on our InterSystems Developers YouTube:

⏯ Open Source LLMs

InterSystems’ team is heading to the TreeHacks 2025 hackathon, taking place on February 14-16, 2025!

TreeHacks 2025 is Stanford's premier hackathon. The country's brightest engineering students are flown to Stanford's campus to build solutions to the world's largest challenges for 36 hours straight. Students will focus on four main areas for innovation: healthcare, sustainability, education, fintech & security, and entertainment.

Interested to become a mentor? Send a direct message to us!

InterSystems’ team is heading to the IC HACK ‘25 hackathon, taking place on February 1-2, 2025 in London, UK.

IC HACK ‘25 is an annual hackathon organised by Imperial College London Department of Computing Society. It is the biggest student-run hackathon in Europe, where over 700 of the UK's most creative and talented students work together for 24 hours of learning, building, fun, and networking.

Hey Community!

Check out the new video dedicated to Gen AI on our InterSystems Developers YouTube:

⏯ Healthcare Use-Case: Patient Portal Messages

Hello my Friends,

I have a question, I have a data like this

And I want to create a display like this, which I can put a status column beside the Item Column

The status become new, if there's no previous item, and if there's a same item after the first one, the status become Old

Does anyone could help me ?

I need to display it without subquery if possible

Thank You

Best Regards,

Steven Henry

Hi Community,

We're excited to invite you to the webinar 2025 Data Management: Technology Trends & Predictions.

Join this webinar for an engaging and insightful tech talk on the latest trends in data management technology in the UK and Ireland.

⏱ Date & Time: Thursday, January 23, 10:30 AM GMT

👨‍🏫 Speakers: 

• Andy Hayler, Practice Leader, Bloor Research
• @Mike Fuller, Regional Director of Marketing, InterSystems UK&I

Git link: https://github.com/ecelg/InterSystems-IRIS-as-a-Spotify-REST-client

Recently, I come up an idea in my mind that how can I put my playlist on IRIS.🧐

At the same time, I was told to pay for my Spotify subscription💸💸... ooo.. how about to get some data from the Spotify API... so I started to do study about it.

Like most of the development, let's start from Documentation of  the API https://developer.spotify.com/documentation/web-api

In order to get the data, i am required to request an access token from for the token endpoint URL.🧐

curl -X POST "https://accounts.

Visual Studio Code releases new updates every month with new features and bug fixes, and the November 2024 release is now available. 

Dear Developer Community,

It seems the Grinch got a little mischievous and swiped our recap before it could make its grand debut! 🎄💚 But don’t worry — our developer elves are hard at work tracking it down, and the full recap will be online shortly.

Hang tight, and we promise to have it back in time to spread all the holiday cheer (and the details you’re waiting for). Thanks for your patience, and keep an eye out for the return of our festive recap!

Hey Community!

Check out the new video dedicated to Gen AI on our InterSystems Developers YouTube:

⏯ AI Governance in IT solutions

I want to provide a shortcut to the D.C. A.I. from a hotkey which will automatically populate the question field here - https://community.intersystems.com/ask-dc-ai.

Is there a way to construct this URL such that it will populate the "Ask a Programming Question" field (and better yet, execute the query)?

Thanks!

Hi everybody,

I need to connect a Caché database to Metabase, but Metabase does not support this database.
Metabase only supports these databases:

- Amazon Athena
- BigQuery (Google Cloud Platform)
- Druid
- MongoDB (recommend version 4.2 or higher)
- MySQL (recommend version 8.0.33 or higher, as well as MariaDB version 10.4 or higher)
- Oracle
- PostgreSQL
- Presto
- Redshift (Amazon Web Services)
- Snowflake
- SparkSQL
- SQL Server
- SQLite
- Vertica

And a few others made by the community. (It is possible to create a driver so that Caché is supported, but I have no experience with that.

When making calls through the Dev Portal, we have observed that port 8003 is being used in the construction of URLs, as demonstrated in the attached image. However, requests should be directed to port 8000. This behavior consistently results in the error shown in the image.
Is it possible to change the port generated in the URL?

About Kong Version 3.2.1.0

Last year we introduced our new angular-based View page for CCR as part of the UI refresh for the application.  This has been used very effectively by close to 1000 users around the world as the default UI for viewing CCR, and as a result we're getting ready to completely disable the "classic" View page.

Hey Community!

We're excited to share the results of the InterSystems Walking Challenge and would like to thank all the members of the Developer Community who joined it and finished the challenge! And now, let's look at the leaderboard 🎊

Hi Community!

Ceck out the new video dedicated to Gen AI on our InterSystems Developers YouTube:

⏯ Use cases in generative AI

Hello My Friends,

I have a question how to use order by %DLIST, this is my code:

SELECT

$ListToString(%DLIST(DISTINCT MRDIA_ICDCode_DR->MRCID_Code),', ' ) ICDX,

$ListToString(%DLIST(DISTINCT (MRDIA_ICDCode_DR->MRCID_Desc || ' (' || MRDIA_DiagnosisType_DR->DTYP_Code || ')')),', ' ) Diagnose

FROM SQLUser.PA_Adm

LEFT JOIN SQLUser.PA_AdmInsurance ON (PAADM_RowID = INS_ParRef AND INS_Rank = 1)

LEFT JOIN SQLUser.PA_AdmPackage ON (PAADM_RowID = PACK_ParRef)

LEFT JOIN SQLUser.MR_Adm on MRADM_ADM_DR = PAADM_RowID

LEFT JOIN SQLUser.MR_Diagnos ON MRADM_RowId = MRDIA_MRADM_ParRef

LEFT JOIN SQLUser.

Hi Community!

Ceck out the new video dedicated to Gen AI on our InterSystems Developers YouTube:

⏯ Keeping your data private and protected with RAG

Hi Community!

We are pleased to invite all our clients, partners and members of the community to take part in the first InterSystems event dedicated to digital health professionals in Italy - InterSystems Italian Healthcare Conference 2024. The registration is already open!

➡️ InterSystems Italian Healthcare Conference 2024

🗓  December 5, 2024

⌚ 9:30  - 18:00

📍 Excelsior Hotel Gallia, Milan

Hi Community!

We're happy to share the next video in the series dedicated to Gen AI on our InterSystems Developers YouTube:

⏯ Prompt before the prompt - third step of GenAI model training

Hi Developers! Join us at our next in-person Developer Meetup in Cambridge, MA. Topic for this meetup:

Talk 1: Deep dive on RAG and AI Hallucinations - by Thomas Dyar, Product Manager, MA - InterSystems
Talk 2: Leveraging AI to Transform Audio Data for Improved Clinical Outcomes in Healthcare - by Vishal Pallerla, Sales Architect, InterSystems

>> Register here

⏱ Day and Time: November 19, 5:30 p.m. to 7:30 p.m.
📍CIC Venture Café in Cambridge, Massachusetts

Hi Developer Community,

We all love coding, but every now and then, it’s time to step away from the code and exercise! The InterSystems Walking Challenge will help you recharge your mind and boost your fitness. Embark on a virtual journey from Lübeck to Lüneburg along the historic Salt Road, the legendary trade route that connected Europe centuries ago.

Win exciting prizes like treadmills, smartwatches, and medals.

👟🚶🧑‍🦼Lace Up, Step Out, and Code Better! 🔋💻💪

📅 Registration is open until  November 8.The challenge ends on November 22, 2024, at 6 PM CET

Want to join? Details below.

Generative artificial intelligence is artificial intelligence capable of generating text, images or other data using generative models, often in response to prompts. Generative AI models learn the patterns and structure of their input training data and then generate new data that has similar characteristics.

Generative AI is artificial intelligence capable of generating text, images and other types of content. What makes it a fantastic technology is that it democratizes AI, anyone can use it with as little as a text prompt, a sentence written in a natural language.

Hello Community!

We are pleased to invite all our clients, partners and members of the community to take cart in the InterSystems DACH Symposium 2024. The registration is already open!

For all those who were unable to travel to the Global Summit in the USA this year, there is once again the opportunity to get all the important information at our InterSystems DACH Symposium in November.

➡️ InterSystems DACH Symposium 2024

🗓  November 5 - 7, 2024

📍 Scandic Frankfurt Museumsufer | Wilhelm-Leuschner-Straße 44 | 60329 Frankfurt am Main

Users of the InterSystems Change Control Record application (CCR) often ask for useful resources which can help them learn CCR and stay in the loop on updates.  Please see this list of resources below and post ideas for additional resources or questions you may have!

• D.C. CCR Group - https://community.intersystems.com/tags/ccr
  • Please "Follow" the group in order to see announcements on training opportunities, application enhancements, Q&A from users
  • Please feel free to add your questions well, and tag with "Group = Other" and Tags = "CCR" to add them to people's CCR D.C.

Can InterSystems IRIS Data Platform 2019  be Integrated with Snowflake?

From InterSystems Do we have any predefined packages or Adapters available to Connect with Snowflake?

Can InterSystems  be Connected with Snowflake through Web Gateway Management?

Hi Community!

We're happy to share the next video in the series dedicated to Gen AI on our InterSystems Developers YouTube:

⏯ Fine-Tuning - second step of GenAI model training

This is a consequence of work being done by the VS Code team to improve Find in Explorer.

Symptoms without proposed APIs:

Note the continual clock badge and progress bar.

With proposed APIs enabled you will require v2.12.9-beta.4 or later, otherwise the find runs but returns no results.

See https://github.com/intersystems-community/vscode-objectscript/issues/14… for more information.

Visual Studio Code releases new updates every month with new features and bug fixes, and the September 2024 release is now available. 

Version 1.94 now includes: 

• Find in Explorer - Quickly find files in the Explorer view with the improved Find control. As a consequence of this, the Explorer's Find widget on server-side folders requires v2.12.9-beta.4 or later with Proposed APIs enabled. Read more in this Developer Community post. 
• Source Control Graph - More filtering options and interactivity in the Source Control Graph.

In this article, we’ll dive into the inner workings of the database management tool, exploring the architecture and technologies that power it. Understanding how the application functions behind the scenes will give you insight into its design, how it manages databases, tables, and how the API interacts with data.

We will discuss the core technologies used, including InterSystems IRIS as the primary database and Redis for caching. Additionally, we’ll break down the structure of the tables used and explain how the system handles data creation, retrieval, and manipulation through the REST API.