I come from Visual Studio and now I use mostly Cache 2017 Studio. One debugging functionality I miss dearly is current local variables automatically appearing in the Watch Variables window together with their values. Yes, I can hover or type them myself but both actions take extra time which is especially noticeable when debugging unfamiliar code across many routines. Any Cache settings or plugins to that effect? If not then why not? And if nothing else is there in Cache, what are the alternatives or hacks in this respect?

Anna

Hi Community!

Join us for another InterSystems Brazil virtual event, this time in partnership with Shift. The topic of discussion led by Marcelo Lorencin on September 16 will be: "InterSystems IRIS for notification of Covid-19's test results for the Ministry of Health". 

Please register now with the link below, vacancies are limited:

✅ InterSystems IRIS for notification of Covid-19's test results for the Ministry of Health

Date & Time: September 16 – 11:00 BRT

Note: The language of the webcast is Portuguese.

Join us!

Developments Healthcare Edition: Virtual Summit Updates, New FHIR resources, more

Hi Community:

Take a look at the latest Developments.

Hi everyone

Anyone knows how can we add a column to an existing linked table in Cache to reflect the external SQL table?

I've tried different queries. It does not fail but does not add the column either...

Hello Developer Community!

I’m pleased to announce the 0.9 release of the ObjectScript extension for Visual Studio Code. Earlier this year I announced that InterSystems would be joining the community in evolving this already popular tool. Since then, we have been hard at work solidifying the code base and building a slew of new features.

Before I get into the details, I’d like to take a moment to thank @Dmitry Maslennikov, @John Murray and the VS Code team at InterSystems for wholeheartedly embracing this new way of collaborating in the open, and working together to build a product that is

Common macro def as following

#def AnyNumber(%args) for i=1:1:$listlength(%args) { Write $listget(%args, i)}

Using this marcro in objectscript code:

ClassMethod Test() as %Status {

     $$$AnyNumber($lb(1,2,3))

}

if ths args is literal value , Iit worked great. But  When I want pass Objects, It's not working

$$$AnyNumber($lb(##class(someClass).%New()))

I know I can pass a %ListObjects , If I want more shorter Line. How can I do this.

Tks

Hello

We were wondering if there is a more concise and simple way to convert information from a string to an object.

The string has each line separated by ; and each field divided by |

The string would look like:

fecha1|nombreProfesional1|centro1|secuencia1|hora1|bloque1|acto1|lugar1|duracion1|nombreOrigen1|modo1||codigoCentro1|codigoAgenda1|especialidad1|codigoCentroOrigen1|codigoAgendaOrigen|borrable|telefono1|telefono2||origen1|;fecha1|nombreProfesional1|centro1|secuencia1|hora1|bloque1|acto1|lugar1|duracion1|nombreOrigen1|modo1||codigoCentro1|codigoAgenda1|especialidad1|codigoCentroOrigen1|cod

Hi i have rules and i want to log them to analyse what rules executed , I want to add in the log Msg Controller Id, MRN, Value coming in the message, and my customize text telling whats wrong with this field... i have like 50 rules and at the end i can check the log table and found like 20 entries so it means 20 data issues are there for a given message control id. any advice how to to do it

Hi Community,

Enjoy watching the new Global Summit 2019 video on InterSystems Developers YouTube Channel:

⏯ Building Data-Driven Web Apps

Hi,

Does anyone have a simple code snippet to encode and upload a raw text to Azure Blob?

I'm looking for any  reference documents on migrating about 3 TB of data from DB2 to IS IRIS Healthshare..  I've looked through the IS  documentation  and SQL gateway, or TSQL are some of the methodologies mentioned , was wondering  if anyone had done this type of migration before, and can provide any pointers.

I put a html file into ensemble dir ,it's encoding is utf-8.

But when I access this file througn browser, It show incorrectly

I checked http response header, It content-type charset is GB18030 So that's reason

How to change the charset to UTF-8?

Tks.

Hi 

We have several rules in router to validate HL7 messages, each rule check a particular field in HL7 message and send back response.  We want to run all rules and combine the rules responses into some variable/object and at the end if variable/object is empty it means message is valid, else send the value from this variable/object. This way one message we dont run it again and again, and we can send one message and response will give us combine results from all rules. 

For example,

Rule 1 - Check MSH.12 field, Send response "MSH.12 value not valid", and RETURN

Rule 2 - Check PID.3 field, Send

Hi Team,

I am getting this error while i entered one field and hit search button. The screen spinning for few minutes and prompt this error.Error Condition CSP application closed the connection before sending a complete response. The job is still running in the backend. Is there anything wrong with this SQLQuery, S Select="SELECT * FROM Sample.Class"
S:EntryDate'="" Where=Where_" EntryDate = '"_EntryDate_"' AND"
S:Location'="" Where=Where_" Location ='"_Location_"' AND"
S:Brand'="" Where=Where_" Brand ='"_Brand_"' AND"
S:Model'="" Where=Where_" Model Like '"_Model_"%' AND"
S:LineNo'=""

InterSystems has corrected a defect that can cause a build-up of orphaned processes consuming system resources. In extreme cases, this can cause a system to become unresponsive.

This defect affects the following versions:

• Caché and Ensemble 2018.1.4
• InterSystems IRIS and InterSystems IRIS for Health 2019.4, 2020.1, and 2020.2
• HealthShare Health Connect (HSAP) 15.032 built on Ensemble 2018.1.4
• HealthShare Health Connect 2020.1

No other InterSystems product versions are affected by this issue.

Hi Community!

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Use Case: Connecting Devices to IRIS for Health to Improve Patient Care

Dear,

I have a visual studio c# library (.net framework 4.7.2) where I want to use EF.  I cannot see my ODBC connection in datasource when I select a ADO.NET Entity Data Model for EF designer for database.

I followed the installation for CacheEF.zip file. (C:\Cache\Cache2010v2\dev\dotnet\bin\v4.0.30319)

Any Ideas,

Kurt

Hi all,

a HealthConnect customer of ours came across with a question to use an external service via REST and OpenID within one of his HealthConnect  (2020.1) productions. The overal idea is to send data to the external system after receiving a baerer token to use for the communication between HealthConnect and this system.

Since I´ve never done such thing before I have an idea to solve this task but looking for a best practise way to do so.

Hello fellow comrades.

I have a little issue concerning the creation of an embedded PDF sent by hl7. When I Extract it, the pdf is not completed (Seen by opening it with notepad++) compared to the one I created with a Base 64 converter.

The one I got from the Base 64 converter contains 7XXX contains lines and mine after my program contains 5900.

I'm testing with an application I'm writing in python. But I noticed that the pythonbind3 library will only work on the same machine where the cache is running. Is there really such a dependency?

I'm trying to run the examples that are in the / dev / python / samples3 folder, but they only work if I set "LD_LIBRARY_PATH" with the path to the cache installation folder.

But... I have this error when LD_LIBRARY_PATH is empty:

[root@cache2018 samples3]# python CPTest2.py -user _SYSTEM -password xxxxxx Traceback (most recent call last): File "CPTest2.py", line 3, in <module> import

I am currently working with docker for the first time the last month. I created a project with these 2 images:

• https://hub.docker.com/_/intersystems-iris-data-platform (for backend)
• https://hub.docker.com/_/nginx (for frontend)

My docker-compose.yml looks like this:

    version: '2'
    services:
        frontend:
            container_name: frontend
            build: 
                context: ./container/frontend
                dockerfile: Dockerfile.yaml
            ports:
                - "8080:80"
            
        backend:
            container_name: iris

Getting routingrules compiling error message. same code works fine for IRIS For Health

/// 
Class Training.HL7Validation.RoutingRule Extends Ens.Rule.Definition
{
Parameter RuleAssistClass = "EnsLib.HL7.MsgRouter.RuleAssist";
XData RuleDefinition [ XMLNamespace = "http://www.intersystems.com/rule" ]
{
<ruleDefinition alias="" context="EnsLib.HL7.MsgRouter.RoutingEngine" production="Training.HL7Validation">
<ruleSet name="" effectiveBegin="" effectiveEnd="">
<rule name="Valid Sending Facility Code Required">
<when condition="Lookup(&quot;OnboardedFacilities&quot;,HL7.{MSH:SendingFacility.NamespaceID},&

Is Cache the preferred database source for extracting data elements for use in Health Share Patient Index or is there a significant benefit in sourcing data from a warehouse, data mart, or MV? I realize that could be a loaded question with 100 other questions that may follow, however, if there is a known advantage to extracting data from a particular data storage type, the answer may highlight that point. 

Our team is in the inception and elaboration phase of using the Health Share Patient Index solution.

The Great Outdoors campaign is running on Global Masters and we invite you to join!

The main goal of this campaign is to drive answers for unanswered questionson DC so all the members get the answers they need. Your knowledge is so important for the community. It's time to share your expertise!

Complete all 7 challenges of this campaign till September 15, 2020 to enter a raffle to win a $50 VISA Card*!

Also, you can participate even if you are not a Global Masters participant - read below how:
 

I have come across several cases where I need to set a Date filter to send only send any admit/scheduled date past a certain point. We have a couple different date comparison functions but none looking at the true date. Most of them are date + 15 or etc. Does anyone have a good date function they have written to say if x > 20170102 ?

Thanks

Scott

You might have encountered this and not known how to prevent it, or perhaps not even noticed it...

Hi Community!

We're pleased to invite you to the Online meetup with the winners of the InterSystems FHIR programming contest!

Date & Time: Friday, September 4, 2020 – 11:00 EDT

What awaits you at this virtual Meetup? 

• Our winners' bios.
• Short demos on their applications.
• A short interview with all the winners about the past contest. Plans for the next contests.

I have a number of globals I want to loop through depending on a passed in string...

^A("SYSTEM")

^B("SYSTEM")

^C("SYSTEM")

^D("SYSTEM")

^E("SYSTEM")

I am passing in a string of "A:C:D"

Piecing that to pull out A,C,D, then want to use that to pull out A,C,D from above, but having problems setting the name of the global to be the name of the variable I have pulled out of the string

How do I set this?

I have tried ^varname("SYSTEM")

also tried setting a variable to have the value "^varname" and using that

Thanks

Edit:

May have found the issue but not the solution.

"SELECT * FROM wmhISTORYdETAIL" runs as a passthrough without asking for the DNS.

but

'SELECT Count([wmhISTORYdETAIL].[HistHMNumber] AS CountOfHistHMNumber FROM [wmhISTORYdETAIL] WHERE ((([wmhISTORYdETAIL].[HistMovType])='Receipt') AND (([wmhISTORYdETAIL].[HistMovDate])>=Date()-1) AND (([wmhISTORYdETAIL].[HistMovDate])<Date()));'

asks for the DNS but both are linked to a table that has the password saved.

Any Ideas please?

Rob

Hi

I have created an MS Access database with a passthrough query to our Intersystems Cache WMS system.