Learning Documentation Community Open Exchange Global Masters Certification Partner Directory Ideas Portal
Developer Community
  • Posts
    • InterSystems Official
    • Articles
    • Questions
    • Announcements
    • Discussions
    • Tags
  • Events
    • Tech Article Contest
    • Programming Contest
    • InterSystems Idea-A-Thon
    • Event Calendar
  • Products
    • InterSystems IRIS
    • InterSystems IRIS for Health
    • HealthShare
    • TrakCare
    • Caché
    • Ensemble
    • InterSystems Analytics (DeepSee)
    • InterSystems Text Analytics (iKnow)
  • Jobs
    • Job Opportunity
    • Job Wanted
  • Members
  • About
    • About Us
    • FAQ
    • Feedback
    • Report an Issue
    • Share an Idea
    • Code of Conduct
    • Contact Us

EN

Search by posts, members, tags
Language
EN|
ESPTJPCNFREN
New post
  • All posts
  • InterSystems Official
    New
  • Announcements
  • Articles
  • Questions
  • No answer
  • No accepted answer
  • With accepted answer
  • Discussions
  • Videos
  • Jobs

InterSystems resources

  • Download InterSystems IRIS
  • Try InterSystems IRIS online
  • InterSystems Container Registry
  • Early Access Program
  • Developer Hub
  • Become a partner
  • Share an idea
  • InterSystems IRIS on AWS
  • InterSystems FHIR Server on AWS
  • InterSystems IRIS on Azure

Our social networks

  

#Globals

7

Globals are multidimensional sparse arrays which are stored in InterSystems Data Platform. Everything in InterSystems Products is stored in Globals: Classes, Tables, Documents, Code.

Documentation.

By update
  • By update
  • By date
  • By likes
  • By views
  • By replies
AllTop
Question
Sylvain Guilbaud · Sep 8
How to do a SQL query on a multilevel global and display each level in the same table ?

Hello,

I have a global whose structure is multi-level and I am trying through a class and a SQL query to display a table which includes all the values ​​and levels.

#Globals #Mapping #SQL #Caché #InterSystems IRIS
0 2
0 106

Trending

1 week
1 month
3 months
6 months
Technological Bonuses Results for the InterSystems Python Programming Contest 2023
Evgeny Shvarov
27 256
Winners of the InterSystems Python Programming Contest 2023
Anastasia Dyubaylo
10 164
Cookbook for preparing your own assistant for meetings
Alexey Nechaev
5 106
Show more (2)
Getting started with the Jupyter Server Proxy extension for VS Code
John Murray
3 95
InterSystems IRIS trainings
Sylvain Guilbaud
5 51

News

Go there

Featured app

Learn more


Social networks

InterSystems resources

  • Download InterSystems IRIS
  • Try InterSystems IRIS online
  • Become a partner
  • InterSystems IRIS on AWS
  • InterSystems IRIS on Azure
  • InterSystems IRIS on GCP
  • IRIS Community Edition on Docker
  • Privacy & Terms
  • Guarantee
  • Section 508
  • Contest Terms
© 2023 InterSystems Corporation, Cambridge, MA. All rights reserved.

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up