Search

Clear filter
Question
Mike Minor · Apr 13, 2018

cache sql insert into external database

As %String(EXTERNALSQLNAME = "PATIENT_CITY", EXTERNALSQLTYPE = 12, MAXLEN = 1000) [ SqlColumnNumber = 36, SqlFieldName = PATIENT_CITY ];Property PATIENTETHNICITY As %String(EXTERNALSQLNAME
Question
Ramil TK · Aug 3, 2022

Working With Date and Time

For this type of data, you can make your own indexes for different parts and/or combinations of them: a separate date, a separate time, a separate year, a separate year and month, etc
Question
Anna Golitsyna · Jul 24, 2024

Undocumented RoutineList features

Is that indeed so? After some system files reading, I discovered that you can EXCLUDE certain routines with ', by using the 'ABC or 'ABC* syntax.
Question
Krishna Jasti · May 10, 2017

Atelier Intellisense Not Working

Eclipse-based application.I don't know if the current 1.1 beta fixes this issue, nor if it will require a version of Caché greater that the current 2017.1 release in order to solve it (or indeed
Question
Eduard Lebedyuk · Jan 14, 2020

Getting dynamic object from iterator

I get this error on access: <PRIVATE PROPERTY> And the property is indeed marked as private. _sighs_ I should have expected that much. Which version are you using?
Announcement
Preston Brown · Jul 26, 2024

REMOTE: Looking for InterSystems skills in HL7+CCDA, SDA3,FHIR,IRIS

EMR/EHR Implementation – Designing clinical data integration solutions that improve patient record management and ensure compliance with industry standards.
Question
Scott Roth · Apr 2

ErrException: zOutputToIOStream+^EnsLib.HL7.Message

We receive an HL7 message with an RTF embedded from our EMR, send it through a DTL to just update the Patient Class, and then send it onto the Operation which is TCP.
Announcement
Preston Brown · Dec 13, 2024

Remote: Strong InterSystems HL7, ADT, CCDA to FHIR + IRIS + GCP

EMR/EHR Implementation – Designing clinical data integration solutions that improve patient record management and ensure compliance with industry standards.
Article
Robert Cemper · Apr 25, 2020

Static WHERE Conditions

It is built on by iFind and this older (but worthwhile) community article on custom spatial indices, although in both cases it works hand-in-hand with a custom index (using %FunctionalIndex
Question
Ephraim Malane · Oct 13, 2022

How to convert xlsx to csv

ClassMethod XLStoCSV(source As %String = "/data/sample.xlsx") As %Status [ Language = python ] { import pandas as pd read_file = pd.read_excel(source) read_file.to_csv(source+'.csv', index
Announcement
Vadim Aniskin · Jan 17, 2024

Top InterSystems Ideas Contributors for 2023

autosave for DTL and BPL pages @LuisAngel.PérezRamos 14 Make IRIS a part of Spring Cloud @wang.zhe 14 Most Commented Ideas: Idea Author Comments Binary index
Question
Nezla · Apr 10, 2022

SQL query confusion

Host Variables You can also try rebuilding the Index Table or clearing Cached Queries.
Question
Laura Cavanaugh · Jun 12, 2017

Possible to view the contents of a process private global?

I know the process ID< and I know the global name: ^||testing(index).
Question
Vivek Ranjan · Mar 12, 2018

Persistent table with %GUID As property

%%GUID" FC381F94-277E-11E8-82F0-005056B479AA The ^OBJ.GUID index that this creates can be accessed via %ExtentMgr.GUID.
Question
Mathew Lambert · May 23, 2018

##class( autocomplete for classnames

@Scott.Morrison9195 @Fred.Gustafsson, thank you for bringing this issue to our attention.