Learning
Documentation
Community
Open Exchange
Ideas Portal
Global Masters
Certification
Partner Directory
Startup Hub
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 Data Studio
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
Article
Gevorg Arutiunian
· Nov 8, 2018
Routine that converts indices to bitmap indices
Interesting to know underlying reasoning of saying: "Use bitmap
index
if there are less than X distinct values in common" or "Use bitmap
index
if selectivity of column is less than
Question
Vinay Purohit
· Apr 28, 2023
How to Set and Check session for CSP Page
One is the Login page and the other page show the
patient
details from the database.
Question
Evgeny Shvarov
· Mar 2, 2023
How Does InterSystems FHIR profile validation works?
", "baseDefinition": "http://hl7.org/fhir/StructureDefinition/
Patient
", "derivation": "constraint", "differential": { "element": [ { "id": "
Patient
. identifier",
Article
Nicole Sun
· Mar 25, 2024
A Peek at IRIS Data Platform Performance Strategies
Example:
Index
NameIDX ON Name; Bitmap
Indexes
: A unique
index
type utilizing bitstrings to represent sets of RowID values corresponding to a given
indexed
value.
Question
yeung elijah
· Jan 27, 2021
How use column (auto_increment)
as a primary key.You can overload this primary key by your own with this
index
:
Index
name On property_expression_list [ PrimaryKey ]; Doc : https://docs.intersystems.com/irisforhealthlatest
Question
Sebastian Thiele
· Apr 21, 2021
EnsLib.Workflow.TaskRequest with complex object
Our TaskRequest contains an object named
Patient
with some properties. We´d like to display the contents in the tasks description area.
Question
Aditi Goswami
· Jun 14, 2017
SQL Query for Range
You should look at the
index
, assuming there is an
index
on A and make sure it has all the values your expect.if the
index
has all the rows and the query is not returning them it is
Question
Sergey Sevastyanov
· Feb 12, 2020
How to: Receive one ADT/A17 message, send two A02's in DTL
In some cases you may need to perform 3 transfers: Transfer
patient
1 to a dummy bed, transfer
patient
2 to
patient
1's prior location, transfer
patient
1 to
patient
2's prior location
Announcement
Kristina Lauer
· Jun 16, 2021
Get an Overview of Personal Community
Learn the key features of Personal Community, an application that enables
patients
to get more involved in their own healthcare.
Question
Laura Cavanaugh
· Oct 26, 2022
One-to-many relationship not ordered as expected
as ClaimLine [Cardinality = many, Inverse = Claim]; } Class ClaimLine { Relationship Claim as Claim [ Cardinality = one, Inverse = ClaimLineRel, OnDelete = cascade];
Index
Question
Alexandre Mosselar
· Jul 11, 2016
How do I create a dimension with a hierarchical structure of grouping?
There you will find an example based on the
Patients
cube where an Age dimension (AgeD) includes one hierarchy with three levels ordered from the least to the most granular:I also recommend
Article
Eduard Lebedyuk
· Jul 5, 2016
Useful auto-generated methods
Indexes
For an
index
named “
Index
”, the following methods would be automatically available ClassMethod IndexExists(val) As %Boolean Returns 1 or 0 depending on whatever object
Question
Evgeny Shvarov
· Nov 6, 2017
How to find duplicates for a large text field in Caché Objects?
If use pure COS for
index
building, you can find duplicates earlier, just during
index
building, without quiering the
index
afterwards.
Article
José Pereira
· Jun 5, 2021
SMART on FHIR JS Library and examples in iris-on-fhir
("
Patient
/1223")) .then(resource => console.log(resource)) .catch(console.error); ``` This command retrieves a resource of
Patient
type.
Article
Timothy Leavitt
· Feb 21, 2024
Functional indices for lightning-fast queries on many-to-many relationship tables
We can look at the query plan: Generate a stream of idkey values using the multi-
index
combination: ((bitmap
index
DC_Demo.Post.Draft) INTERSECT ((bitmap
index
DC_Demo.Post.Author
first
previous
…
31
32
33
34
35
…
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