#Video

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.

Hi Community,

Watch this video to explore common security pitfalls within the industry and how to avoid them when building applications on InterSystems IRIS:

⏯ The OWASP Top 10 & InterSystems IRIS Application Development @ Global Summit 2022

Hey Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ InterSystems Security Development Lifecycle @ Global Summit 2022

Hey Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Understanding your InterSystems Login Account & Where to Use It @ Global Summit 2022

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Real-World CI/CD: Keep Calm & Build On @ Global Summit 2022

Hey Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Real-Life Experiences Migrating a Caché Application Portfolio to InterSystems IRIS @ Global Summit 2022

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ InterSystems Startup Accelerator Pitching Sessions @ Global Summit 2022

Hey Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Introduction to AutoML @ Global Summit 2022

Hey Community,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Let InterSystems IRIS Do the Work: Git Source Control & Linting ObjectScript Across Editors @ Global Summit 2022

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in January 2023:

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

Hi Community,

Watch this video to learn different ways to connect and interact with event streaming platforms like Kafka:

⏯ Working with Event Streaming Platforms @ Global Summit 2022

Seeing results in SMP or Terminal

If you run the suggested queries from Terminal in  SQL shell you see:

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 uses
a Process Private Global (PPG) as Temporary storage.
using  SELECT * FROM RCC.gstreamT WHERE RCC.useT('^jpgS')=1 and similar.

This might be an advantage for multiple access to the same stream in sequence,
The advantage is obvious: You have a personal snapshot in memory and no risk of
a conflict in access. This might be interesting if you work just on 1 specific stream.

Hi Community,

Watch this video to review the present of InterSystems cloud services and use cases, as well as a roadmap for the future:

⏯ InterSystems IRIS Cloud On-Demand Services @ Global Summit 2022

Hey Community! 

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:

⏯ Lifecycle of ideas on the InterSystems Ideas

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Importing Relational Data Using a DDL Script

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Modern(izing) Full Stack Development on InterSystems IRIS @ Global Summit 2022

Hey Developers,

Do check out our list of most popular videos of the year 2022 from our InterSystems Developers YouTube Channel: 

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in December 2022:

Hi Community,

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:

⏯️ What is InterSystems FHIR Server

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ InterSystems Cloud Services Overview

Hi Community,

Watch this video to learn what's in store for patient experience initiatives for our hospital clients:

⏯ Patient Experience and the EHR @ Global Summit 2022

Hey Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Introduction to Analytics with InterSystems IRIS

Hey Community,

Join this session to learn more about security-related topics, starting with the change to the OpenSSL libraries and the general distribution of third-party libraries with InterSystems products (e.g., Web Server):

⏯ Updates in Security @ Global Summit 2022

Hi Community,

Watch this video to get an introduction to data types in InterSystems ObjectScript, and see how to use three common data types: strings, lists, and objects:

⏯ ObjectScript Data Types

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Using System Functions in InterSystems ObjectScript