https://www.youtube.com/embed/DBpCPwLclUY [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]
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.
My previous article introduced you to SQL based Basic Class Query where a clever wizard created all the required code for you and your essential contribution was an SQL statement.
Now we enter the real Custom Class Query thatprovides more freedom but requires a deeper understanding of the mechanic behind the scene. The full code example is again on GitHub
My previous article introduced you to the COS based Custom Class Query. There were some features missing like more lines of the stream displayed and numbered.
https://www.youtube.com/embed/NTF6PcgoZxM [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]
https://www.youtube.com/embed/zcfLstacqic [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]
https://www.youtube.com/embed/__47xt1RH3E [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]
https://www.youtube.com/embed/EcaJETVJ6eg [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]
https://www.youtube.com/embed/xUIULmh6LhY [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]
https://www.youtube.com/embed/Y5p0YZVaeW0 [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]
https://www.youtube.com/embed/X6Ji9x-y8x8 [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]
https://www.youtube.com/embed/Fh0uyC9owyE [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]
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.
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 this Special thanks to @Oliver Wilms for the inspiration for this tool.
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
https://www.youtube.com/embed/S_nmZx8iWp8 [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]
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 uses a Process Private Global (PPG) as Temporary storage. using SELECT * FROM RCC.gstreamT WHERE RCC.useT('^jpgS')=1 and similar.
https://www.youtube.com/embed/Ev8ZEVfkIug [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]
Welcome to the 3rd edition of the InterSystems Ideas news bulletin! Curious about what has happened on the Ideas Portal since the previous one? Read on!
First of all, we've created a short video that explains the lifecycle of the ideas on the Portal:
https://www.youtube.com/embed/jffCadSfszM [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]
https://www.youtube.com/embed/owUeiGtLixE [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]
https://www.youtube.com/embed/wMMRprv_4_4 [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]
Watch this video to learn about InterSystems FHIR Server, the turnkey FHIR data solution that empowers FHIR application developers to focus on building life-changing healthcare applications:
https://www.youtube.com/embed/YyZc8dK9_jM [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]
https://www.youtube.com/embed/wJXvfeQoZxQ [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]
https://www.youtube.com/embed/_gqmslNaxZA [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]
https://www.youtube.com/embed/ouvGTFHgmiM [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]
By update
.png)
This tutorial is a follow on to Working with %Query .png)
.png)
.png)