New post

検索

Announcement
· Sep 30, 2024

★受賞者発表!★ InterSystems デベロッパーツールコンテスト 2024(USコミュニティ)

開発者の皆様、こんにちは。

USコミュニティで開催していましたInterSystemsデベロッパーツールコンテスト の勝者が発表されました!

今回は 17 applications 🔥の素晴らしいアプリケーションの投稿がありました。 


Experts Nomination

🥇 1位 $5,000 は、 iterm を開発された @Dmitry Maslennikov さんに贈られました。

🥈 2位 $3,000 は、 sql-embeddings を開発された  @José Pereira さん @Henry Pereira さん @Henrique Dias さんに贈られました。

🥉 3位、4位 $1,125 は、 DX Jetpack for VS Code を開発された @John Murray さん、そして、 iris-ccd-devtools  を開発された  @Chi Nguyen-Rettig さんに贈られました。

🏅 5位 $500 は、 IPM in VS Code を開発された @John Murray さんに贈られました。

🌟 $100 - IOP REST Client Framework を開発された  @Antoine.Dh さんに贈られました。

🌟 $100 - Irisheimer を開発された  @Zacchaeus Chok さんに贈られました。

🌟 $100 - db-management-tool を開発された  @Andrii Mishchenko さんに贈られました。

🌟 $100 - iris-DataViz を開発された  @Muhammad Waseem さんに贈られました。

🌟 $100  - iris-dev-codeinspector を開発された  @Rodolfo Moreira dos Santos さんに贈られました。

Community Nomination

🥇 1位 $1,000 は、 iterm を開発された @Dmitry Maslennikov さんに贈られました。

🥈 2位 $750 は、IRIS-Test-Data-Generator を開発された @Dylan Cole さんに贈られました。

🥉 3位 $500 は、sql-embeddings を開発された @José Pereira さん @Henry Pereira さん @Henrique Dias さんに贈られました。

🏅 4位 $300 は、IPM in VS Code を開発された @John Murray さんに贈られました。

🏅 5位 $200 は、DX Jetpack for VS Code を開発された @John Murray さんに贈られました。

受賞された皆さん、おめでとうございます!また、コンテストにご興味お持ちいただきありがとうございました!

次のコンテストもご期待ください!

Discussion (0)1
Log in or sign up to continue
Question
· Sep 30, 2024

Combine all rows in select into one comma delimited string

I've got a select statement bringing back one value, I want to combine all rows into one comma delimited string. So for example:

 

SELECT First Name

FROM mydb.People

 

I get a list of names:

John

Fred

Sarah

Carl

Jane

Julie

 

Instead of having 6 rows in the result, I want one row, with one cell that has "John,Fred,Sarah,Carl,Jane,Julie"

 

Is there a way to do that?

2 Comments
Discussion (2)1
Log in or sign up to continue
Announcement
· Sep 30, 2024

Winners of the Developer Tools Contest 2024

Hi Community,

It's time to announce the winners of the Developer Tools Contest

Thanks to all our amazing participants who submitted 17 applications 🔥 

Now it's time to announce the winners!

Experts Nomination

🥇 1st place and $5,000 go to the iterm app by @Dmitry Maslennikov

🥈 2nd place and $3,000 go to the sql-embeddings app by @José Pereira, @Henry Pereira@Henrique Dias

🥉 3rd and 4th place and $1,125 each go to the DX Jetpack for VS Code app by @John Murray and iris-ccd-devtools app by @Chi Nguyen-Rettig 

🏅 5th place and $500 go to the IPM in VS Code app by @John Murray

🌟 $100 go to the IOP REST Client Framework app by @Antoine.Dh

🌟 $100 go to the Irisheimer app by @Zacchaeus Chok 

🌟 $100 go to the db-management-tool app by @Andrii Mishchenko 

🌟 $100 go to the iris-DataViz app by @Muhammad Waseem

🌟 $100 go to the iris-dev-codeinspector app by @Rodolfo Moreira dos Santos 

Community Nomination

🥇 1st place and $1,000 go to the  iterm app by @Dmitry Maslennikov

🥈 2nd place and $750 go to the IRIS-Test-Data-Generator app by @Dylan Cole

🥉 3rd place and $500 go to the sql-embeddings app by @José Pereira, @Henry Pereira@Henrique Dias

🏅 4th place and $300 go to the IPM in VS Code app by @John Murray

🏅 5th place and $200 go to the DX Jetpack for VS Code app by @John Murray 

Our sincerest congratulations to all the participants and winners!

Join the fun next time ;)

6 Comments
Discussion (6)6
Log in or sign up to continue
Article
· Sep 30, 2024 1m read

Usando o certificado OS com TLS/SSL

Tem um jeito fácil de adicionar um certificado (CA - certificate authority) às suas configurações no InterSystems IRIS 2019.1 (e 2018.1.2) no Windows e Mac. Você pode pedir para o IRIS usar a loja de certificados do sistema operacional usando:

%OSCertificateStore

no campo "File containing Trusted Certificate Authority X.509 certificate(s)". Aqui está uma imagem de como fazer isso no portal:

E aqui está um  link para a documentação que descreve isto. Está na lista de opções abaixo de  "File containing trusted Certificate Authority certificate(s)".

Isso é tudo que você precisa fazer! Agora essa configuração vai aceitar certificados solicitados por qualquer CA listado na loja de certificados do OS.

Discussion (0)1
Log in or sign up to continue
Announcement
· Sep 30, 2024

Global Masters is back! Launch Date: October 3, 2024

Hi Community, 

We’ve missed Global Masters, and we’re sure you have too!

🚀 Global Masters is Relaunching on October 3, 2024!

On October 3, we’ll share a link for all Developer Community members to access the new platform.
Don't miss a dedicated post on the Developer Community!

We’ve been working hard to bring the program back to you, but please bear with us if you notice any rough edges—it’s still a work in progress! We’ve focused on delivering the most valuable features first: challenges (which we now call “Asks”… but sometimes still “challenges” as we’re all adjusting!), rewards, and badges.

Some features are still under development:

1. API Integration: The integration between Global Masters, Developer Community, Open Exchange, and Ideas Portal is still in the works. The estimated launch is at the end of October. In the meantime, we’re tracking your contributions and will update your point balances once the feature is live.

2. Levels: The new platform doesn’t yet support Levels, but we’re working hard to bring them back as soon as possible.

The Wait is Over! 🎉 Hurray!

5 Comments
Discussion (5)6
Log in or sign up to continue