New post

אתם משתמשים כבר ב-VS Code עם שרת InterSystems או שרק עכשיו מתחילים להשתמש?

אנחנו קוראים לכל מפתחי הקהילה שלנו להצטרף לוובינר הבא (בעברית!) שבו נעסוק בכל הנושאים היותר מתקדמים בעבודה עם VS Code.

לרישום ומידע:

https://community.intersystems.com/post/hebrew-webinar-vs-code-beyond-ba...

2 1
0 58
Article
· Jan 22 2m read
Getting JSON from SQL

Did you know that you can get JSON data directly from your SQL tables?

Let me introduce you to 2 useful SQL functions that are used to retrieve JSON data from SQL queries - JSON_ARRAY and JSON_OBJECT.
You can use those functions in the SELECT statement with other types of select items, and they can be specified in other locations where an SQL function can be used, such as in a WHERE clause

The JSON_ARRAY function takes a comma-separated list of expressions and returns a JSON array containing those values.

18 10
4 547

Are you preparing to use VS code for the first time? Just make sure you have enough privileges.

Have you defined your Iris server in your VS Code settings, and still get the following error?

VS Code accesses Iris/HealthConnect using the web application /api/atelier. If you do not have permission (i.e. you are using an LDAP user to connect and the web application is not configured to support LDAP), this is the reason why you couldn't connect.

7 3
2 364