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 #Tutorial #Video #Other Open Exchange app 8 1 0 362
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 #Tutorial #Video #Other Open Exchange app 8 4 1 647
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 Open Exchange app 1 1 0 361
Question Robert Cemper · Feb 26, 2023 Code assist in VSCode ? In Studio, I had a set of nice Assist Functions to create correct code.. Do they exist in some similar way also in VSCcode ? Same for SOAP wizard? #VSCode 1 2 0 341
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 203
Question Robert Cemper · Feb 3, 2023 Why to run ISC Agent in Demo Docker ? For quite some time I am bored by slowly starting Docke Demos from OEX.I type docker-compose up - d and after a few seconds docker-compose logs And I just see ISC Agent was started and is hanging aroundNo IRIS instance is up yet. #Docker #InterSystems IRIS 4 2 0 290
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 #Video #InterSystems IRIS #Open Exchange Open Exchange app 2 1 0 299
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 #Video #InterSystems IRIS #Open Exchange Open Exchange app 7 1 2 312
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: #Video #Other 1 0 1 282
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. #Video #InterSystems IRIS #Other 2 0 0 305
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. #Video #Caché #InterSystems IRIS Open Exchange app 6 1 1 558
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 152
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 169
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 224
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 298
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 227
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 223
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 163
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 141
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 222