Article Robert Cemper · Mar 2, 2023 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. #Other 12 1 1 312
Article Robert Cemper · Mar 2, 2023 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. #Other 8 1 0 205
Article Robert Cemper · Mar 2, 2023 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 #Other 8 1 0 251
Article Robert Cemper · Mar 2, 2023 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 #Other 8 4 1 502
Article Robert Cemper · Feb 28, 2023 2m read Break the limits of your server Hi developers! You are experts in IRIS and know all tricks. The functionality of $ZF(-1,-2,-100, ......)is nothing new to you And you know the limits of this functionality.Both give you access to your local server command line environment. And that's it. #Other 1 1 0 282
Article Robert Cemper · Feb 6, 2023 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. #Open Exchange 4 2 0 170
Article Robert Cemper · Jan 30, 2023 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 220
Article Robert Cemper · Jan 30, 2023 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 236
Article Robert Cemper · Jan 27, 2023 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: #Other 1 0 1 183
Article Robert Cemper · Jan 23, 2023 2m read Global-Streams-to-SQL #2 Some technical background information There is not just one class in this package: rcc.gstream.cls but also rcc.gstreamT.cls While rcc.gstream works with direct access to the stream globals, the *T version usesa Process Private Global (PPG) as Temporary storage.using SELECT * FROM RCC.gstreamT WHERE RCC.useT('^jpgS')=1 and similar. #Other 2 0 0 178
Article Robert Cemper · Jan 23, 2023 2m read Global-Streams-to-SQL In general Global Streams are data objects embedded in Classes / Tables.Using and viewing them with SQL is normally a part of the access to the containing tables. SO WHAT? During debugging or searching for strange or unexpected behavior there could be the need to get closer to the stored stream. No big problem with direct access to Globals with SMP or Terminal.But with SQL you are lost.So my tool provides dynamic access to Global Streams wherever you may need thisSpecial thanks to @Oliver Wilms for the inspiration for this tool. #Other 6 1 1 373
Article Robert Cemper · Dec 19, 2022 2m read Reviews on Open Exchange - #23 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. #Open Exchange 0 0 0 121
Article Robert Cemper · Dec 4, 2022 2m read Reviews on Open Exchange - #22 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. #Open Exchange 0 0 0 133
Article Robert Cemper · Nov 28, 2022 2m read Reviews on Open Exchange - #21 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. #Open Exchange 2 0 0 192
Article Robert Cemper · Nov 25, 2022 2m read Reviews on Open Exchange - #20 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. #Open Exchange 3 0 0 255
Article Robert Cemper · Nov 11, 2022 2m read Reviews on Open Exchange - #19 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. #Open Exchange 1 0 0 195
Article Robert Cemper · Oct 22, 2022 2m read Reviews on Open Exchange - Oct. 2022 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. #Open Exchange 1 2 0 174
Article Robert Cemper · Sep 27, 2022 2m read Reviews on Open Exchange - Sep. 2022 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. #Open Exchange 1 0 0 135
Article Robert Cemper · Sep 18, 2022 1m read Reviews on Open Exchange - Statistics I produce my monthly Review Report on OEX packages now for 18 months.These are a view figures and some comments: #Open Exchange 5 1 0 105
Article Robert Cemper · Sep 2, 2022 1m read Reviews on Open Exchange - Aug. 2022 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. #Open Exchange 0 1 0 195