Search

Clear filter
Question
Keith Davis · May 31, 2019

How do I drop a table created by a Objectscript class

, for that matter). That's the thing, I don't want views, I want tables, and I need indexing (which was how this all got started, the indexing is not working). I was not aware
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
Question
Birun Balami · Mar 27, 2019

Sending Messages on the Top of Queue

. As the patient demographic data and "stat" lab orders should always be prioritized over routine order messages, a "high" priority value would be set for those messages during in-engine
Question
Ashok S · Nov 2, 2016

MDX QUERY

in holefoods or patients cube. Ashok, can you reproduce the problem in HoleFoods cube which comes with Samples namespace? It would be easier to play with the data and suggest
Question
Don Rozwick · Mar 22, 2017

How to Search the stream in Message Browser for a EnsLib.HTTP.GenericMessage

/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><Stream>{ "patient": { "identifier": "E23456778", "token": "PQOIWUE)&!@TT$1234706125" } } <
Question
praveen danda · Oct 10, 2017

Create Custom Table or View

les patients en retard set myquery=3 set myquery(1) = "SELECT profile_id,Type_Measure, Program as Heure_Ratée,Practitioner_Id,Warning_Type FROM Bwxpert_Repository.Enrollment
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
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
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

: 🏅 4th place: iris-image-index-demo by @José.Pereira 🏅 5th place: Terminal Multi-Line Command Editor​​​​ by @Robert.Cemper1003 🏅 6th place: Dictionary
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
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
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