Search

Clear filter
Article
Irene Mykhailova · Apr 25

Response times when using Dynamic and Embedded SQL

though all the data of Patient and Visit is stored in the Patient global. The index saved the day for the one-many relationship, and the execution time was considerably shorter
Article
Muhammad Waseem · May 30, 2022

FHIR Client to connect any open FHIR Server by using embedded python

,Practitioners and Encounters count along with Patient and Registered Servers details Index page will display FHIR Server List with active server selected. Select other server from
Article
Henrique Dias · Aug 26, 2020

Updating Patient Resource using fhir.js

the patient details, so I to search for an example of how to do it. The Github page of fhir.js has an example of how to update a resource. Looking at this example made me think
Question
Vivek Nayak · Mar 8, 2022

Patient resource not added in FHIR repository.

Hi Team, I got a 404 status code(fhirResponse.Status) in the below code while inserting patient resources. Other resources data are successfully inserted. Class
Question
Julian Matthews · Oct 1, 2018

Issues manually creating HS.SDA3.Patient

, except I'm falling over when it comes to repeating fields within the SDA3 when creating the HS.SDA3.Patient object manually from within Cache.If I take the Patient ID as an example
Question
Ba Moser · Aug 25, 2020

How to create index inside Array

Of Sample.Address; } In SQL it is Table Sample.Person1 No problem to define INDEX on Home_State But Table Sample.Person1_AR HowTo define an INDEX on AR_State ? Index st On AR.State; Does
Question
Guillaume Rongier · Jun 17, 2019

iFind Index With Relationship RowID Specification

]; Index NarrSemanticIdx On (Narrative) As %iFind.Index.Basic; Index UniqueNumIdx On UniqueNum [ Type = index, Unique ]; } The problem start when I add an Relationship in my indexed
Question
Keshav Iyer · Apr 11, 2022

Is it possible to add an index to a %SerialObject property?

I have a %Persistent class with properties that are of %SerialObject. I want to add an index to a property of the %SerialObject class. Is this possible? Yes. Here's a quick
Question
Yuri Marx · Sep 5, 2021

Rebuild table index using ObjectScript

How Can I Do It (rebuild index) using ObjectScript? Documentation do ##class(Some.ClassName).%BuildIndices($lb("indexName1", "indexName2")) BUILD INDEX (via SQL) %BuildIndicesXXX()
Question
Güvenal · Nov 10, 2021

SQL Search index on JSON objects.

Hello there!I am hoping to get some help with "SQL Search index" and JSON objects.I am storing a JSON object in a column of type %Stream.GlobalCharacter Property JSON
Article
José Pereira · Feb 2, 2021

A custom SQL index with Python features

/cover_post_final.png --- #### Functional Index But this is just the tools needed to compare images based on their content. If you hasn't a nice query language like SQL, you'll end up
Article
Vitaliy Serdtsev · Jun 29, 2017

SQL index for array property elements

. Let’s take a look at a simple example:Class User.eav Extends %Persistent { Index idx1 On attributes(ELEMENTS) [ Data = entity ]; Index idx2 On (attributes(KEYS), attributes
Question
Uri Shmueli · Aug 10, 2017

Custom Index for Not Null Values Only

Hi1. Is it possible do define an index like that :create index UIX on MyTable (Column1) where Column1 is not null2. What happens if we add an index on a property
Article
Alexander Koblov · Jan 29, 2016

Creating a Custom Index Type in Caché

The object and relational data models of the Caché database support three types of indexes, which are standard, bitmap, and bitslice. In addition to these three native types
Question
Evgeny Shvarov · Nov 30, 2017

Index Globals: Take Away or Rebuild?

Hi, Community!Consider you move data from one server to another or make a deployment with persistent data. What do you do with index globals?Is it always better to rebuild them