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 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
New post
Language
EN
|
ES
PT
JP
CN
FR
EN
New post
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 IRIS
InterSystems IRIS BI (DeepSee)
InterSystems IRIS for Health
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 Olympics
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
Python
React
Red Hat Enterprise Linux (RHEL)
Relational Tables
Release
REST API
Security
Sharding
SOAP
Source Control
SQL
SSL
Startup
Studio
SVN
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
Question
Scott Roth
· Jan 18, 2018
Using StartsWith with a data lookup table
EN",BUC OR")An HealthShare expert might be able to answer if it is possible to have an
index
on the fields of your WHEN condition.A different approach could be to handle the whole
Question
Hannah Sullivan
· Aug 24, 2023
How to best cascade deletes for a property that is a list of a persistent class
impressive design.So you need to add an
index
on the ELEMENTS of your Property Organizationsto find all affected objects.some example of how to Thank you for the clarification
Question
John Bradshaw
· Jul 12, 2023
Help with global mapping with two namespaces with a static subscript
As %String [ Required ]; /// Contact Row IDProperty RowID As %Library.String(SELECTIVITY = 1, TRUNCATE = 1) [ Required ];
Index
RowIDBasedIDKeyIndex On (NS, RowID) [ IdKey, PrimaryKey
Article
Yuri Marx
· Apr 4
Part III: Studying for IRIS Developer Professional Certification with the "Ask Developer Community AI
| InterSystems IRIS Data Platform 2024.34.InterSystems Embedded Python in glance5.Python (Tools/APIs) | InterSystems API
Index
| InterSystems IRIS Data Platform 2024.36.New
Article
José Pereira
· Dec 27, 2021
Using Python to Implement an IMAP Client in InterSystems IRIS
from a list by its
index
, using the [\_\_getitem\_\_](https://docs.python.org/3/reference/datamodel.html#object.\_\_getitem\_\_) special method: USER>Set b = ##class
Article
Henry Pereira
· Dec 1, 2021
Data anonymization, introducing iris-Disguise
that follow. It is certainly a non-trivial feature to implement, but it gives you the ability to keep a
patient
encounter intact as the visit goes from admit to discharge. This scares
Question
Nicky Zhu
· Sep 3, 2018
Why does a DT succeed in test while failed in run time
;/UBadguanxing> ...</Record></test>The value of UBadguanxing will trigger the generation of labresult.the result is as below: <Container> <
Patient
>
Article
Eduard Lebedyuk
· Aug 3, 2020
Creating classes/tables with more than 999 properties in InterSystems IRIS
in IRIS or Caché. Entity–attribute–value model is usually used for this purpose. I have already written about this at the time: SQL
index
for array property elements. That's
Article
Yuri Marx
· Jul 20, 2022
Create Stored Procedures using Embedded Python
Python has become the most used programming language in the world (source: https://www.tiobe.com/tiobe-
index
/) and SQL continues to lead the way as a database language. Wouldn't
Article
Brendan Bannon
· Jul 15, 2021
Embedded SQL new in InterSystems IRIS
is flexibility in a live environment. In the past, if you add an
index
or ran TuneTable, the SQL in Cached Queries would make use of this new information right away while embedded SQL
Question
Krishnamuthu Venkatachalam
· Sep 12, 2020
Calling a classmethod of an instance from another instance via native method
to interact with is linked to an underlying Global Definition (Data,
Index
and Stream) then use the Global Mapping to Map the Globals used by the class into Namespace A 5) The Class
Article
Benjamin De Boe
· Jan 10, 2023
Columnar Storage in 2022.3
in a columnar
index
or data map. Also, you'll see it combine columnar and bitmap indices in a number of cases, which is great if you're starting off by adding columnar indices to an existing
Question
Gaolai Peng
· Sep 18, 2017
How to import a tab separated text file into a SQL table programmatically
= "Pending" ];
Index
idxRPPI On RPPI;ClassMethod LoadFromFile(){ Set pFileName="C:\mytest.tsv" Set pDelimiter= $C(9) Set rowType="RPPI varchar(50),Name varchar(516),BirthDate Date
Article
Murray Oldfield
· Mar 11, 2016
InterSystems Data Platforms and performance – Part 2
is here](https://community.intersystems.com/post/capacity-planning-and-performance-series-
index
) ***Edited Oct 2016...*** *[Example of script to extract pButtons data to a .csv
Article
Maks Atygaev
· Dec 11, 2016
Declarative development in Caché
://www.tiobe.com/tiobe-
index
/). [Edit, changed to 8. Pretty sure C and ASM don't have anything like this.]I don't want to say this is you, but some people have no room for innovation
first
previous
…
79
80
81
82
83
…
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