Question
· Jan 2
Nested queries

Hi Guys,

This Nested query is not working for some reason, but they work fine when executing separately ?

select id from FDRD_Com.List where vehicle in (select Car from FDRD_Com.Prod where ProductLineName='Toyota' and Car is not null)

Thanks

0 3
0 127
InterSystems Developer Community is a community of 25,013 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

Earlier this year I announced availability of a VS Code extension for coding in ObjectScript, Embedded Python or SQL using the notebook paradigm popularized by Jupyter. Today I published a maintenance release to correct a "getting started" problem.

Here's a video of the installation steps from the extension's README:

Open Exchange app
7 4
0 440

When developing a new Interoperability Production, it is quite natural that settings are initially added in the Production.

However, as soon as you want to move the Production from development to a test or staging environment, it becomes clear that some settings like HTTP Servers, IP addresses and/or ports need to be changed. In order to avoid these settings being overwritten during a redeployment later on, it is essential that you move these settings from the Production to the System Default settings.

9 2
7 444
Question
· Dec 12, 2024
Mirror entered trouble state

Dear community, my company use intersystems iris, a old version of 2019 and centos 7.9

At the moment, we are faced with a rather strange luck of iris.

Every day during working hours, we receive a error that iris primary cannot transfer the journal to the backup node.

We have availability monitoring, these errors do not affect availability in any way, but I still wanted to analyze this error.

I understand that the severity of this error is only 1, but Can someone share a diagnostic method this error?

1 1
0 158
Article
· Dec 16, 2024 2m read
Edit your Globals with VSCode and YAML

The best way to list, edit, save and delete globals is using an IDE. Now, it is possible if you use VSCode. It is also possible to save globals using yaml files. Perform the following steps:

1. Get an InterSystems IRIS instance and install the application iris-global-yaml: 

zpm:USER>install iris-global-yaml

2. If you just to want an InterSystems IRIS trial for tests git clone and run on docker:

Open Exchange app
13 11
6 440

Last Chapter: Creating a REST client to get Tracks from Spotify REST API - Part4 Save the Search Result

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

OK.... based on what I have done.... I am able to

1. Query Track information by making use of the Spotify API

1 0
0 114
InterSystems Official
· Dec 17, 2024
IPM 0.9.0 Released

We have released IPM 0.9.0. I previously remarked on some of the history and reasoning here; to summarize, this is a big release for two reasons: it represents a long-overdue reunification of our internal and community-driven work around IRIS-centric ObjectScript package management, and it has some backwards incompatibilities. There are several necessary backwards incompatibilities in our roadmap, and we've lumped them together; this will not be some new norm.

Open Exchange app
8 3
0 290

Last Chapter: Creating a REST client to get Tracks from Spotify REST API - Part3 Get some data (e.g. Artists)

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

OK we create a method to get data and lets try to get some Tracks 😁

0 0
0 110

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.

4 2
2 265

Last Chapter: Creating a REST client to get Tracks from Spotify REST API - Part2 Save and Refresh Token

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

Ok, now I am pretty sure i have a valid token for making query.😀

Shall we try to query something from the API.

0 0
0 147

Last Chapter: Creating a REST client to get Tracks from Spotify REST API - Part1 Check out token

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

Ok... Now we can check out a token but it will be expired in 3600 seconds.

There are 2 questions come up🤔

1. How to save this token????🙄

2 0
0 178
Article
· Dec 26, 2024 1m read
Global Masters Holiday Cards

🎄✨ Holiday Greetings from the Community! ✨🎄

On Global Masters, you’ve sent us wonderful greetings for the community, and we can’t wait to share them with everyone! We’ve transformed your greetings into beautiful holiday cards—check them out below 💌. Thank you all for your warm words!

We also held a small contest on Global Masters for the most original holiday greeting, and @Harshitha.Balakrishna's card was chosen as the best one! Here it is: 👇
📌 Below, you can see all the greetings shared by Global Masters members. They remind us of how important it is to be part of such a united and creative community.

8 0
0 207

***Restoring /opt/iris2024/mgr/user/ at 15:06:28
1 blocks restored in 0.0 seconds for this pass, 1 total restored.***Restoring /opt/iris2024/mgr/user/ at 15:06:28
1 blocks restored in 0.0 seconds for this pass, 2 total restored.***Restoring /opt/iris2024/mgr/user/ at 15:06:28
1 blocks restored in 0.0 seconds for this pass, 3 total restored.Mounting /opt/iris2024/mgr/user/
/opt/iris2024/mgr/user/ ... (Mounted)[Journal not applied to any directory]

What does it mean that the last line after recovery shows 'Journal not applied to any directory '.

0 1
0 109

Hey Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ InterSystems IRIS Cloud Document @ Global Summit 2024

https://www.youtube.com/embed/T7RzkugC7QQ
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 0
0 141

Dear Community,

As the 🎄 Festive Season 🎄 approaches, we’d like to share our warmest wishes with you. May your holidays be filled with the joy of 🧑‍💻 learning, 🫂 connecting with fellow members, and the excitement of new projects and challenges in the year ahead!

Looking back on 2024, we’re thrilled to celebrate some truly remarkable achievements with YOU, our amazing members:

12 1
0 132

Today, we take a moment to shine the spotlight on one of the true pillars of the InterSystems Developer Community, @Alberto Fuentes. His commitment, expertise, and enthusiasm have left an indelible mark on the Developer Community, and we couldn’t be more grateful. Alberto has been a part of the InterSystems ecosystem for over 15 years, starting his journey with InterSystems technology back in 2008. Since then, he has worn many hats, from integrating Ensemble at his previous job to officially joining InterSystems in 2011 and now holding the position of Sales Engineer. Over the years, he’s witnessed—and contributed to—some of the most significant milestones in the company’s history.

🤩 Let’s dive into his remarkable journey!

23 11
0 322