Learning
Documentation
Community
Open Exchange
Global Masters
Certification
Partner Directory
Ideas Portal
Developer Community
Ask DC AI
Posts
InterSystems Official
Articles
Questions
Announcements
Discussions
Tags
Events
Tech Article Contest
Programming Contest
InterSystems Ideas Contest
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
Ask AI
Language
EN
|
ES
PT
JP
CN
FR
EN
Search
All
Top posts
Latest posts
Tags
Type of post
Announcement
Article
Question
Discussion
Search by user posts
Tags
Caché
Developer Community Official
Documentation
Ensemble
Global Masters
Health Connect
HealthShare
InterSystems Ideas Portal
InterSystems IntelliCare
InterSystems IRIS
InterSystems IRIS BI (DeepSee)
InterSystems IRIS for Health
InterSystems Kubernetes Operator (IKO)
InterSystems Natural Language Processing (NLP, iKnow)
InterSystems Official
InterSystems Reports (Logi)
IRIS contest
Job Opportunity
Job Wanted
Learning Portal
Open Exchange
Other
Partner Directory
Resource Library
Summit
Supply Chain Orchestrator
TrakCare
.NET
Access control
Adaptive Analytics
Alerts
Analytics
Analyzer
Angular
Angular2
API
Apple macOS
Application Server
Artificial Intelligence (AI)
Authentication
AWS
Azure
Backup
Beginner
Best Practices
Big Data
Business Operation
Business Process (BPL)
Business Rules
Business Service
C++
Callout
CaretDev
CCR
Certification
Change Management
ChatGPT
Cloud
Code Golf
Code Snippet
Coding Guidelines
Columnar Storage
Compatibility
Compiler
Containerization
Contest
Continuous Delivery
Continuous Integration
Convergent Analytics
CSP
CSS
CSV
Cubes
Dashboards
Databases
Database Transaction Processing
Data Import and Export
Data Model
DC Feedback
Debugging
Deployment
Developer Community FAQ
Development Environment
DevOps
Digest
Distributed Data Management
Docker
Document Data Model (NoSQL)
DTL
Early Access Program (EAP)
Eclipse
ECP
Embedded Git
Embedded Python
Encryption
Enterprise Message Bank
Error Handling
Events
Failover
FHIR
Field Tests
Framework
Frontend
FTP
Generative AI (GenAI)
George James Software
Git
GitHub
Globals
Global Summit 2016
Global Summit 2017
Global Summit 2018
Global Summit 2019
Global Summit 2022
Global Summit 2023
Global Summit 2024
Google Cloud Platform (GCP)
Graph
High Availability
HL7
HTML
iFind
Indexing
Innovatium
IntegratedML
integration-required
Interoperability
InterSystems API Manager (IAM)
InterSystems Business Solutions and Architectures
InterSystems Demo Games
InterSystems Package Manager (IPM)
IoT
isNewTech
ITvisors
J2 Interactive
Java
JavaScript
JDBC
Journaling
JSON
Key Question
Key Value
Kubernetes
Languages
Large Language Model (LLM)
LDAP
LEAD North, LLC
Listings
Localization
Machine Learning (ML)
Management Portal
Mapping
MDX
Meetup
Message Search
Microservices
Microsoft Windows
Microsoft Windows Server
Mirroring
Monitoring
Multi-model
MultiValue Basic
Namespace
Natural Language Processing
Node.js
OAuth2
Object Data Model
ObjectScript
ODBC
Open Source
OpenVMS
Perforce
Performance
PID^TOO||
Platforms
Podcast
Prompt Engineering
Python
React
READY 2025
Red Hat Enterprise Linux (RHEL)
Relational Tables
Release
REST API
Security
Sharding
SOAP
Source Control
SQL
SSL
Startup
Studio
SVN
Swagger
System Administration
System Alerting and Monitoring (SAM)
Terminal
Testing
Tips & Tricks
Tools
Tutorial
Ubuntu
UI Development
UIMA
Unstructured Data
Vector Search
Video
Virtual Summit 2020
Virtual Summit 2021
Visualization
VSCode
Vue.js
Web Gateway
Webinar
XML
ZEN
Apply
Clear filter
Announcement
Anastasia Dyubaylo
· Feb 5, 2024
Winners of InterSystems FHIR and Digital Health Interoperability Contest
to the fhirmessageverification app by @珊珊.喻 🌟 $100 go to the Clinical Mindmap Viewer app by @Yuri.Gomes 🌟 $100 go to the
Patient
-PSI-Data app by @Chang.Dao
Article
Robert Cemper
· Jan 2, 2022
DB Migration using SQLgateway
edit and Test Connection - verify Connection successful - Be
patient
at this point. Postgres Containers sometimes take quite some time to talk to you. - Wait a little
Article
Robert Cemper
· Jan 30, 2022
My Reviews on Open Exchange - Jan.2022
4 dataset-finance clean and and complete exercise 5.0 y 5 Health Dataset nice DB for 270 anonymous
patients
5.0 y 6 objectscript-json-patch excellent
Article
Dmitry Maslennikov
· Jul 2, 2023
Profile ObjectScript with more power
patients
. This uncovers some interesting discoveries, like, about 40% of the time is spent on IndexResource And about 20% to ValidateResource Of course, this can't be very accurate
Article
Robert Cemper
· Aug 26, 2017
From The Roots to InterSystems
persistent data could easily take 30%+ of your available memory and no idea if sorting,
indexing
, .... No strong data types anymore or data types imposed by names (ALGOL, FORTRAN
Article
Peter Cooper
· May 11, 2018
Replacing ZEN - Part 3 - Progress to date 01
Index
to Articles Hi All It's been 6 weeks since my original article - - - - -but I have been busy on this project I have been looking at/thinking about a replacement
Article
Matthew Giesmann
· Nov 8, 2016
Introduction to Outlier Selectivity
indexes
, 90% vs. 3% of a table can make a big performance difference and can again change which query plan the SQL engine chooses. # Queries with Outlier Selectivity Outlier
Question
Jose Antonio Cañizares
· Jul 14, 2017
Is there a way to map a $lb() to its data model
positioning to match their $list
index
according to their property definition
index
. But you will need to describe each property to detect their types and if they are instantiable. In case
Question
Nael Nasereldeen
· Dec 10, 2019
Using %JSON.Adaptor to Export Complex Objects with relationships of 'many to many' type
, %JSON.Adaptor, %Populate){ Relationship Student As TafnitTest.Student [ Cardinality = one, Inverse = Teachers ];
Index
StudentIndex On Student; Relationship Tracher As TafnitTest.Teacher
Announcement
Anastasia Dyubaylo
· Mar 8, 2021
InterSystems Grand Prix Contest: CONGRATS THE WINNERS
place: iris-image-
index
-demo by @José.Pereira 🏅 5th place: Terminal Multi-Line Command Editor by @Robert.Cemper1003 🏅 6th place: Dictionary comparison
Question
Yone Moreno
· Aug 4, 2021
Convert a %String property with CDATA and XML content to Ensemble object
contador= tResultList.Count() /// ¿Por qué sale contrador = 0? $$$LOGINFO("contador es: "_contador) if (contador>0){ for
index
=1:1:tResultList.Count
Article
Evgeniy Potapov
· May 20, 2022
How we reduced the report generation time by 28 times
such a table to be a big one.What was the size (in GB) of the underlining global? Based on it looks like History.Views may not have indices or at least doesn't have a bitmap
index
Question
Evgeny Shvarov
· May 29, 2017
Globals vs Locals: What Is Faster
Hi, colleagues!Consider you need to put some (less than 1GB) data to an
indexed
array and do some data manipulations and calculations with it.Should I prefer global or local
Question
Tuan Minh Do
· Jul 16, 2018
%DOC with DeepSee
have data, you need to populate the associated
index
. A quick and dirty way to do this is an SQL query like the following: update ISC_DM.Fitabase1 set %Doc = %Doc I'm
Question
CM Wang
· Jul 18, 2017
How to dynamically change the entry defined in SQL storage map
for this ? <SQLMap name="
Index
"><BlockCount> ^Blk</BlockCount></SQLMap> set Blks = $lb(-100,-200,-300) for r = 1:1:$ll(Blks){set ^Blk = $li(Blks,r)do
first
previous
…
78
79
80
81
82
…
next
last
Log in or sign up
Log in or create a new account to continue
Log in
Sign up
Log in or sign up
Log in or create a new account to continue
Log in
Sign up
Log in or sign up
Log in or create a new account to continue
Log in
Sign up
Log in or sign up
Log in or create a new account to continue
Log in
Sign up