Article Robert Cemper · Mar 8 2m read The spooky ascetic Property During my recent work on Tutorial - Working with %Query #1I met a Class Property that is quite different from its same-named relatives.It is there since 'ever' but is rarely used, Related doc doesn't help so much. #ObjectScript #Caché #Ensemble #InterSystems IRIS 3 2 0 153
Article Robert Cemper · Mar 3 2m read Reviews on Open Exchange - #25 If one of your packages on OEX receives a review you get notified by OEX only own YOUR package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. I also placed a bunch of Pull Requests on Github when I found a problem I could fix. Some were accepted and merged, and some were just ignored. So if you did a major change and expect a changed review just let me know. #Caché #Ensemble #InterSystems IRIS #Open Exchange 2 0 0 40
Article Robert Cemper · Mar 2 4m read Tutorial - Streams in Pieces This tutorial is a follow on to Working with %Query It was displaying the content of the input stream chopped in fixed-size chunks.But often those streams are structured and have well-defined separators (e.g HL7)So as a side subject of this tutorial, this chapter shows how to break a stream into PIECES. It is exactly the same idea as the $PIECE() function for strings with some add-ons. #ObjectScript #Tips & Tricks #Tutorial #Caché #Ensemble #HealthShare #InterSystems IRIS Open Exchange app 7 1 0 121
Article Robert Cemper · Mar 2 5m read Tutorial - Working with %Query #3 My previous article introduced you to the COS based Custom Class Query.There were some features missing like more lines of the stream displayedand numbered. #Beginner #ObjectScript #Tips & Tricks #Tutorial #Caché #Ensemble #HealthShare #InterSystems IRIS Open Exchange app 5 1 0 97
Article Robert Cemper · Mar 2 5m read Tutorial - Working with %Query #2 My previous article introduced you to SQL based Basic Class Querywhere a clever wizard created all the required code for you and your essentialcontribution was an SQL statement. Now we enter the real Custom Class Query that provides more freedom butrequires a deeper understanding of the mechanic behind the scene.The full code example is again on GitHub #Beginner #ObjectScript #Tips & Tricks #Tutorial #Caché #Ensemble #HealthShare #InterSystems IRIS Open Exchange app 5 1 0 111
Article Robert Cemper · Mar 2 5m read Tutorial - Working with %Query #1 The title of the contest subject is not quite precise but addresses the %Library.classes involved.What is meant is officially named Class Query and is dating back to the early days of Caché.CLASS is used because it is embedded in a COS class.Though there is a precise description in the official documentation it remains rather abstract.My tutorial should guide you step-by-step through a simple example in COS to make it tangible to you #Beginner #ObjectScript #Tips & Tricks #Tutorial #Caché #Ensemble #HealthShare #InterSystems IRIS Open Exchange app 7 4 1 267
Article Robert Cemper · Feb 6 2m read Reviews on Open Exchange - #24 If one of your packages on OEX receives a review you get notified by OEX only own YOUR package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. #Ensemble #InterSystems IRIS #Open Exchange 4 2 0 91
Article Robert Cemper · Jan 30 1m read JSONfile-to-Global #2 The power of the presented tool becomes visible with a large JSON file.The example I have prepared is composed of the daily results of AoC 2023.Anonymization makes it usable for demo purposes. #Globals #JSON #Tips & Tricks #Tools #InterSystems IRIS #Open Exchange 2 1 0 118
Article Robert Cemper · Jan 30 2m read JSONfile-to-Global #1 The similarity between JSON objects + arrays and Globals in IRIS or Caché is evident.With small and medium size JSON objects navigation across %Dynamic Objects is comfortable.But with large and/or deep cascaded objects it becomes a challenge. The presented tool offers 3 variants loading an already existing %Dyamic object or Array into a global of your choice loading a %Stream containing a JSON object into a global of your choice loading an external File containing a JSON object into a global of your choice #Globals #JSON #Tips & Tricks #Tools #InterSystems IRIS #Open Exchange 6 1 2 149
Article Robert Cemper · Jan 27 1m read Global-Streams-to-SQL #3 Seeing results in SMP or Terminal If you run the suggested queries from Terminal in SQL shell you see: #Debugging #Globals #JDBC #ODBC #SQL #Tips & Tricks #Tools #Caché #Ensemble #InterSystems IRIS 1 0 1 102