The newer dynamic SQL classes (%SQL.Statement and %StatementResult) perform better than %ResultSet, but I did not adopt them for some time because I had learned how to use %ResultSet. Finally, I made a cheat sheet, which I find useful when writing new code or rewriting old code. I thought other people might find it useful.

First, here is a somewhat more verbose adaptation of my cheat sheet:

Last comment 7 days ago
+ 7   2 13
1391

views

+ 7

rating

I've just been tempted to the option exchange (curiosity) and when browsing, I often right-click, and open links in a new tab, eventually ;-) I have enough interesting open tabs to go off and read the tabbed articles,

I can't do this in open exchange, it will only allow a direct click to open the url.

even worse, when I come back (to where I left off) It starts from the top of the page.

any chance of changing the url's to allow us to right click and open in a new tab

Last answer 7 days ago
+ 2   0 0
0

comments

42

views

+ 2

rating

I have a list property that I query from the database to get the values contained in that list using $LISTFROMSTRING() when the list is returned the list values contain a rectangle like character similar to when you copy past something to the Terminal and it has a preceding space .The problem is I need to compare those values to other values and they do not match because of this value I have tried to use $EXTRACT(value,*W) and *P but this is not striping the preceding character how do I get rid of this character any ideas please. 

Last answer 7 days ago Last comment 7 days ago
0   0 2
94

views

0

rating

In Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2018.1.2 (Build 309U) Mon Mar 4 2019 15:07:46 EST

I have a master record that has a relationship to a table with multiple transactions, and the transaction table has a relationship to another transaction table with multiple other transactions.

IE Item to Physcal to Physical Report

Item Master:

Last comment 7 days ago
0   0 3
0

answers

133

views

0

rating

Hi Community!

New "Coding Talk" video is already on InterSystems Developers YouTube:

How to Submit Your InterSystems Solution, Connector or Library to Open Exchange

0   0 1
0

comments

36

views

0

rating

As you might have heard, we just introduced the InterSystems API Manager (IAM); a new feature of the InterSystems IRIS Data Platform™, enabling you to monitor, control and govern traffic to and from web-based APIs within your IT infrastructure. In case you missed it, here is the link to the announcement.

In this article, I will show you how to set up IAM and highlight some of the many capabilities IAM allows you to leverage.

Last comment 8 days ago
+ 7   3 2
155

views

+ 7

rating

I am happy to announce that InterSystems API Manager is now generally available. InterSystems API Manager (IAM) is a new feature of the InterSystems IRIS Data Platform™, enabling you to monitor, control and govern traffic to and from web-based APIs within your IT infrastructure.

Last comment 8 days ago
+ 7   1 3
440

views

+ 7

rating

Hi,

I have a ORU message, which has a EVN segment that I want to remove and send the message across.

I tried to clone the request as below:

s newreq = request.constructClone

s changreq = newreq.RemoveSegmentAt("EVN")

Set request  = changereq

but it fails. Is there a way that I can safely remove a segment and pass it on?

Would appreciate your help in this

Regards,

Eric

Last answer 8 August 2019 Last comment 8 days ago
0   0 2
135

views

0

rating

Hello All,

I need some help:

 I would like to create Web Application using our ZEN with Cache DB so please guide me.

1.What is difference between zen page and zen application.

2.what is the difference between Client Method and server Method then where to use it.

Thanks.

Last answer 10 days ago Last comment 8 days ago
0   0 3
105

views

0

rating

We have created a custom SDA container to store a certain kind of new, customized patient data.

We are observing a behavior in the correspoding analytics table for this custom SDA class where rows are added for a patient for which the MPI is null and the patient record does not exist.

Last comment 8 days ago
0   0 2
0

answers

41

views

0

rating

Hi

Is there any way to control what control sequence is sent to a device when a   "write #" is executed?

I have an application that establishes a banner at the top of the terminal window and when we do a   "write #" the banner disappears.  I need to be able to recreate the banner line as part of the screen clear.

Thanks

Jenna

Last answer 9 days ago Last comment 9 days ago
0   0 2
111

views

0

rating

I have an OAuth 2.0 development environment where Caché is serving all three roles as the Authorization Server, Client and Resource Server based on a great 3-part series on OAuth 2.0 by @Daniel Kutac. I have a simple password grant type where an x-www-form-urlencoded body (as described in this post) is sent as a POST to the token endpoint at https://localhost:57773/oauth2/token and a response body with a HTTP Response 200 header is returned. The response body looks something like this.

Last answer 9 days ago Last comment 9 days ago
+ 1   0 3
47

views

+ 1

rating

Hi,

I am trying to use the  LogicialToDate method in the %Library.FilemanDate class.  In the class documentation it talks about the parameter STRICTDATA (see below).  I would like to set the STRICTDATA to a 1 but I am not sure how to do that when using this method because the method does not reference this as a parameter to be passed into it.  (see below).

How do I set the parameter?

Thanks

parameter STRICTDATA = 0;

Last answer 9 days ago Last comment 9 days ago
0   0 1
40

views

0

rating

Hello,

How should I go about it to add a page to the EnsPortal? I want to display a dashboard like page and I would like to be able to have it accessible from Management Portal. I hope there is a better way than typing the URL in address bar. Is the menu for Management Portal editable?

Thanks,

Oliver

Last answer 9 days ago
0   0 1
0

comments

42

views

0

rating

Hello All.

In need of some help.

We are currently migrating Interfaces from JCAPS to HealthConnect 19.1 and have done a lot of work on our Dev server.  I am looking to copy/export this work over to the Test server and have managed to export the production and Rules, HL7 custom Schemas etc.  The only thing left now are the Data Transformations but so far I can only find ways of copying the transformations over individually.  Is there some way to copy all of the transformations we have produced in our namespace to another server in one go?  

Thanks

Last answer 10 days ago Last comment 10 days ago
0   0 1
64

views

0

rating

I have created a custom container that contains medication adherence data. I want to know the best-practice way of querying the data for to display in a custom Zen page in the Clinical Viewer for a given loaded patient.

 

Let's say the custom class is called Hospital.Data.MedicationAdherenceData. Let's say the streamlet class is Hospital.SDA3.Streamlet.MedicationAdherenceData

 

Last answer 8 August 2019 Last comment 10 days ago
0   0 2
68

views

0

rating

At the moment I am trying to write a documentation file for a project and intend to use LaTeX for it.
Has anyone already had experience with this? I haven't found syntax highlighting with the LaTeX packages I know yet.
I found a request on Pygment but it was from 2016 and there was no reply on it since then.

Does anyone know a simple way for syntax highlighting COS in LaTeX?
Thanks for your input!
 

Martin

Last answer 10 days ago Last comment 2 April 2019
0   0 4
136

views

0

rating

Hey Guys,

I got stuck with this for 2 days, please help me

Actually my logic is when I enter the input on the text field in browser, the entered input to be print on the next page but I am getting "Undefined". How to i do it.

Below is my code:

 

 

Last answer 12 days ago Last comment 12 days ago
0   0 2
75

views

0

rating

Hi,
I had written one .net service for excel validation , after validation the data will be inserted in DB. I am getting value from an outbound message but the values are not inserting in DB. i have two classes one is for reading the value from excel and convert that into ensemble objects, here i am getting value. Another class for inserting the values from the ensemble objects but here i given a global variable for checking . It's shows global variable does not exist. I don't why it's not entering to 2nd class. Please give me the step by step explanation

Last answer 12 days ago Last comment 12 days ago
0   0 1
58

views

0

rating

I am trying out Atelier.  I have installed it and managed to get it to connect to a cache instance to test it.  I have created a local project and I am trying to copy the server files to it using the "Copy to Project" item on the popup menus.  I can copy both classes and routines to the project without issue, but when I try to copy the CSP files, I get the following message:

com.intersystems.atelier.utils.CheckedExceptionWrapper: Input length = 1

Last comment 13 days ago
0   0 2
0

answers

43

views

0

rating