Syndicate content 0  
 

Generally speaking, InterSystems products supported dynamic objects and JSON for a long while, but version 2016.2 came with a completely new implementation of these features, and the corresponding code was moved from the ObjectScript level to the kernel/C level, which made for a substantial performance boost in these areas. This article is about innovations in the new version and the migration process (including the ways of preserving backward compatibility).

5 0
2 3.2K

This code snippet uses %ZEN.Auxiliary.jsonSQLProvider. The namespace and string of SQL can be edited for different situations. The class method "test" runs the code:


Class eduardlebedyuk.passQuestionParams
{
    classmethod test(pValue = 50) {
        s ns = $Namespace
        zn "samples"
        s tSQL = "SELECT ID, Name FROM Sample.Person WHERE Id > ?"
        s tPR = ##class(%ZEN.Auxiliary.jsonSQLProvider).%New()
        s tPR.sql = tSQL
        s tPR.%Format = "tw"
        s tPR.maxRows = 100
     
        s tParam = ##class(%ZEN.Auxiliary.parameter).%New()
        s tParam.value = pValue
        d tPR.parameters.SetAt(tParam,1)
      
        d tPR.%DrawJSON() 
        //d ##class(%ZEN.Auxiliary.jsonSQLProvider).%WriteJSONFromSQL(,,,,,tPR)  //same thing
        zn ns
    }
}

(Originally posted to Intersystems CODE by @Eduard Lebedyuk, 5/13/15)

Here's a link to the code on GitHub

1 0
0 307

Hi, Community!

This post is a digest of the Developer Community postings in February 2018.

Most viewed

Book: Caché Objects and Atelier 212

Beautifying for Object Script ? 155

com.intersys.globals.GlobalsException occurs when I am trying to call connection.connect() with the correct credentials 143

Container - What is a Container IMAGE? 134

M:N Relationship 132

How to distinguish the String from Integer in COS 127

Performance in Cache object scripts 121

Atelier security quirk 119

Calculate the age of a person 116

Pulling information from Credentials using Cache Object Script 115

2 0
0 310

Hi Community!

Please welcome a new session recording from Global Summit 2017:

Shared Development in the 21st Century

https://www.youtube.com/embed/gOLC2gICEVQ
[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 410

Hi Community!

I'm pleased to announce that we've just launched the new product in the family of InterSystems Data Platforms:

InterSystems IRIS for Health

IRIS for Health — is the world’s first and only data platform engineered specifically for healthcare. It empowers you to rapidly create and scale the industry’s next breakthrough applications.

2 0
1 515
InterSystems continuously monitors our systems for any evidence of attempts to exploit vulnerabilities such as the newly announced Meltdown and Spectre attack vectors.
At this time we have seen no indications of attempts to target InterSystems systems or technology using these vulnerabilities.
· InterSystems is aware of recently reported cybersecurity vulnerabilities known as Meltdown and Spectre that affect a wide range of computer processors (See US-CERT Alert TA 18-004A, Meltdown and Spectre Side-Channel Vulnerability Guidance,
7 0
0 1.1K

Hi, Community!

Please find a new session recording from Global Summit 2017:

Load Balancing for Operational Resiliency

https://www.youtube.com/embed/E2uLbVeP5Yc
[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 395

Hi Community!

Check the new video on DC YouTube Channel:

SMART on FHIR Apps for Information Exchange

https://www.youtube.com/embed/Y8l1pQxC8iw
[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]

0 0
0 566

Hi Developers!

New video from Global Summit 2018 is available now on InterSystems Developers YouTube Channel:

Unit Test Coverage in InterSystems ObjectScript

https://www.youtube.com/embed/nUSeGHwN5pc
[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 512

Hi Community!

This is a digest of the Developer Community postings in November 2018.

Most viewed

New release cadence for InterSystems IRIS 302

Abnormal programming with InterSystems 217

Language features that you really should know from day 1 215

What is best approach to parsing CSV string to tab-delimited string? 207

How do You Convert 8-bit Database to Unicode? 141

InterSystems IRIS 2018.2 available in preview 139

How to get running operating system 122

ObjectScript: Looping over a multidimensional global value and comparing 119

Syntax highlighting for ObjectScript 119

Detection of last update timestamp of each class row (DSTIME ?) 117

Data Verifier for InterSystems Data Platforms 104

Uploading and downloading files via http 99

Fetch Message Header Data 62

Utility to compare class and include file definitions between builds 55

0 0
0 195

Hi Community!

Thank you for being with InterSystems Developer Community yet another year! We appreciate it very much!

We want to know how helpful DC for you today and how could we make it better.

Could you please go through this short 5 min survey which will let us know what do you think about DC and what could be improved.

We wish you a Merry Christmas and a Happy New Year!

Sincerely,

Your InterSystems Developer Community Team

1 0
0 215