On an IRIS system, we expect the default string collation for SQL columns to be SQLUPPER. This means WHERE conditions will be case-insensitive. However, when I make a WHERE condition on a SQL procedure that returns a string, it's case sensitive.For example:
Cures Act USCDI/ C-CDAv21 certification. I am looking for SDA3 examples for Newman-Bates-Kid/registry settings/advices on how to learn / whatever is helpful. InterSystems xsl files are clean but I am not working very often with xsl. I am mainly looking at Provenance and Clinical Notes, the 2 last errors we have. InterSystems documentation, so far I know, is very poor: only classes and some pages. Support has a small knowledge about SDA3 -> C-CDAv21 even if they try very hard to help.
Using the Data Transformation Builder I see the action if but in my scenario a case statement would be better. Is there anyway to do a case statement? This way I dont need to build a long if else logic.
I am experiencing a problem with an EDI process that uses a SQL Batch Service to connect to our DEV environment. However, when we point the EDI service to our TEST server, it errors out.
I have checked every single property on our TEST and DEV servers as well as the properties on the associated tables. They are identical. Nothing has changed in the SQL either.
I want to write the values that are stored in an array into the OBX 5 field. The text in MyArray(1) will go in the the first OBX 5 field. Then the text in MyArray(2) will populate the next OBX 5 field.
My question is how do you format the Set > Action Tab > Value entry so that it pulls the data from MyArray(source.{PIDgrpgrp().ORCgrp().OBXgrp().OBX:SetIDOBX})
I want to achieve the same function as the management portal under the Utilities menu。
I wrote a studio.sourcecontrol menu tool. I want to use chrome to open the CSP page. Now I can open it to CSP, but the IP address is the intranet IP of the cloud server. How can I get the IP of the current studio connection?
On local environment, calling Foo() is instantaneous (a few ms). On production/test servers (which have much better hardware than local) calling this function is slow and take between 200 ms to 800 ms. Obviously starting a new job with "job" command take lot of time on those environments.
I am working on setting up our Failover techniques as we move to a Mirror Environment with a Arbiter, 2 Failover Nodes, and a Async (DR) Node. There are some system commands that I would like to call when the Mirror moves, and I am working on a ZMIRROR routine for that, but I also wanted to create an additional step if we wanted to manually shutdown and for the Mirror to move. So I was looking at using ZSTOP to call a couple of different items while shutting down, while the documentation has an example a couple of questions come to mind about using ZSTOP.
I've the below code that copies 15000 records into a global, problem is that taking around 11 secs to finish and I'm wondering if there is any faster way (eg. would copying the file into stream and look through the stream makes it faster!?) because I've hundreds of files I need to process every time.
I'm using $ZF(-1) in a class method which will be invoked from a csp page.
What determines the environment of the spawned process? If I use $ZF(-1,"echo hello world > output.txt"), the resulting file is owned by cacheusr:cacheusr. However, when I use $ZF(-1,"printenv > output.txt"), the environment is from my personal unix account, no matter which Cache username I'm logged in under when running the web application.
I have lots of msg control id received from customers and i search these msg control id first in router to review the msgs and then search the same msg control id in the respective edge message viewer.
Is there a way i can generate the msg trace URLs for router and edge by using msg control id?
Is there a way to filter in a routine for a type of filtering column in Excel. I can apply exclusion logic, but wondered if there was some type of method that accomplished a type of filter.
Hello all, I am facing a little issue with line separators. I export classes with $SYSTEM.OBJ.Export to the file system, but I'm on a Linux (docker) environment and he uses LF.
Is it somehow possible to change the line separator for the export or in general?
I am working with Elastic Container Service in AWS running IRIS for Health containers 2020.1. We have an ECP Data Server. I like to be able to add a new host IP on the data server when a new client starts up. What table are the Allowed ClientIPs stored in?
I'm trying to send a message into a production on change a persistent object.
And when I change an object using SQL - I get an error, when change the object using objectscript - I get a message (but not an error or exception) But the most interesting - everything works fine (the object has been changed, and business service receives data)
I have a series of data organized by time (year and month) so I can use a time dimension to drill down data. So far so good.
However, I need to display the data not by calendar years and months but rather by seasons. The season has 12 calendar months but starts in September. So I'd like to see the data from September / Year N to August / Year N+1 using the same hierarchy as normal time dimension.
Has anyone done something similar?
Obviously, the season can start by any month, not only September :)
Atelier is not translating the indentation spaces used to format XDATA sections in Cache Studio. Lack of these spaces makes the XDATA difficult to read. The styling (coloring) of the code is working just fine. Also, it appears that other class code indentation works fine.
Is anyone else seeing this issue? Has there been any discussion when this issue might be addressed by InterSystems? How shall I get some attention to this issue?