Search

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