When I'm asked questions about SQL, I like Intersystems staff at the WRC, generally ask about the Query Plan. My feeling is that even before you run a query you should examine the results of Show Plan to confirm that the code is going to give me the results in the manner I would expect. If I expect it to leverage an index and I see that it is not then I go back and look at what I might have done incorrectly and try to re-write the query to get the index behavior I'm looking for. To that end, there's a poll below to ask you if think moving the Show Plan button as the first button would be

0 0
0 144

In a healthcare setting we've an Ensemble namespace through which passes a key HL7 feed (the ADT feed from our PAS). It is split up, transformed and passed on to multiple downstream systems. We consider the feed going to each downstream system an interface. Each interface is developed as separately as possible - typically as a separate branch of our git repo (which we access via VS Code).

0 0
0 209

The use of Source Code Control systems in development is important. And there are a few systems known in the world, like GIT, SVN (Subversion), Perforce, Mercurial. Where the most popular nowadays is the git. Using it is very useful in many cases, but mostly it depends on the code as text, which can be compared between commits, branches, or versions of releases and so on.

1 0
0 290

Hello Everyone ,
Good Day !
I have a question regarding the implementation of USCDI (US Core Data for Interoperability).

Why USCDI was introduced?
What is the disadvantage of previous process ( communication between systems using concept like HL7) ?
What is the impact of implementing this concept in existing systems ? Do we have to change logics for processing the messages?
Will it effect the existing work flow of all the healthcare application?

0 0
1 207

When overwriting the Read method (that has a %CacheString return type) on a new class that inherits %Stream.FileCharacter class, returns an error about incorrect return type, must be Binary, even if it matched the real signature.

Looking at the compile global information we can see:

^oddCOM("%Stream.FileBinary","m","Read",42)="%Library.Binary"

After further investigation we realise that there is a generator method looking at the OdbcType class definition.

Setting LONGVARCHAR results in:

^oddCOM("User.CStream","m","Read",42)="%Library.String"

0 0
0 163
Discussion
· Sep 16, 2022
txt2img
Several models, such as DALL-E, Midjourney, and StableDiffusion, became available recently. All these models generate digital images from natural language descriptions. The most interesting one, in my opinion, is StableDiffusion which is open source - released barely a few weeks ago. There's now an entire community trying to leverage it for various use cases.
2 0
0 813

HI Dev's

I dont work for Intersystems but i have found this training course very helpful and wanted to make sure others know about it.

Advanced Data Transformations

Advanced Data Transformations

Add a for each loop.
Create and use utility functions.
Create and use lookup tables.
Use counting.
Create and implement a subtransformation.
Add a code action.
Add a group of actions to organize relevant actions.

2 0
0 188

Hello Hello,

I am building a patient room door signage for a customer who has Trakcare already deployed. The app will reflect patient's data upon admission in the hospital (eg. name, male/female, doctor, mrn, special diet, etc...)

When the patient is discharged, "something" will tell the app that the patient was discharged and the screen will be reset.

Appreciate any kind of direction and help.

Thank you!

0 0
0 120

This is a lesson learned, which I would like to share with community.


Recently I ran into an issue, where I was using %ConstructClone and it kept cloning extra records, which were not needed. The record for which I was trying to run a clone had many-to-one relationships.

The solution to this issue was using param -1. If you run %ConstructClone(-1) it will not clone relationships, but rather just clone single oref as desired in this case.


I hope this information helps someone who is working with similar records.

4 0
0 388

Hi Community,

Watch the recording of the Second Community Roundtable: "What is the best source control system for development with InterSystems IRIS?"

Some great discussions have been started during this roundtable. We invite you to continue these discussions. in the comments to this post.

Tell us, which source control you use and why – in the comments to this post.

https://www.youtube.com/embed/86xPyfc1mKI
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

6 0
0 229

Hi Developers!

With InterSystems IRIS Cloud SQL recently becoming Generally Available, some of you may have had a chance to try it out. Or maybe you used it for your contest entry or during the EAP period. We're curious to learn what YOU think of it. So, have you already tried the new service InterSystems IRIS Cloud SQL?

We have launched a new Ideas Portal category dedicated to this database-as-a-service (DBaaS) where we're looking for your ideas on how we can improve InterSystems IRIS Cloud SQL.

Or share your experience with the service in the comments to this post.

1 0
0 57

Hi Community! Many of you have seen the Data Points podcast episodes that we have been releasing since February. I mentioned previously that I planned to pose an open question to the community about topics you might like to hear in a podcast episode. Let us know in the comments if there are any conversation points you would find particularly interesting, and we can try to include some conversations with experts on said topics!

And in case you missed it, check out Episode 12 about the all-new chat bot on InterSystems websites!

https://5e18edf067eb59-03854285.castos.com/player/212752
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 0
0 134