I'm trying to serialize property of type %TimeStamp in SQL statement with JSON_OBJECT, but I get a raw string instead of JSON DateTime format string. %JSONExport method on the same object works fine.
If one of your packages on OEX receives a review you get notified by OEX only own YOUR package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column.
I have number of hosts on an Ensemble production that are not updating the %LastActivity property in the
^CacheTemp.EnsHostMonitor global. This in return create an issue with our dashboard software which is showing wrong results even as the host is processing messages without issues.
Hello everyone! Don't miss the Developer Community Post Digest for April 2022.
General Stats
✓140 new posts published in April: – 27 new articles – 28 new announcements – 84 new questions – 1 new discussion ✓195 new members joined in April ✓9,465 posts published all time ✓10,809 members joined all time
I'm trying to take an unformatted social security number and insert the dashes into it. I'm getting a value in PID-19 like this: "123456789" and would like to use a data transformation to set the value in PID-19 to "123-45-6789".
Is there a way to find the median in Intersystems Cache SQL? I know it is not available as an aggregate function. Also in SQL Server I could try something like:
SELECT
(
(SELECT MAX(Score) FROM
(SELECT TOP 50 PERCENT Score FROM Posts ORDER BY Score) AS BottomHalf)
+
(SELECT MIN(Score) FROM
(SELECT TOP 50 PERCENT Score FROM Posts ORDER BY Score DESC) AS TopHalf)
) / 2 AS Median
However, there is no PERCENT Keyword in Cache as well. Any suggestions?
InterSystems has always provided -- with each maintenance release -- a document that describes all the changes in that maintenance release. This document is known informally as the relnotes or (now) the MRNotes*. Here’s a link to one of them, just to make sure we’re on the same page: https://docs.intersystems.com/iris20211/csp/docbook/relnotes/index.html
Hello everyone! Don't miss the Developer Community Post Digest for March 2022.
General Stats
✓144 new posts published in March: – 15 new articles – 48 new announcements – 80 new questions – 1 new discussion ✓222 new members joined in March ✓9,331 posts published all time ✓10,656 members joined all time
Has anyone here successfully connected to a community edition version of IRIS through port 22 to localhost? I have been trying for hours and hours to connect a Mobaxterm terminal session to IRIS and am at a total loss. Im not sure if port 22 isnt opening at this point or if its a configuration issue on my part. I am seeing either "Remote side unexpectedly closed network connection" or "connection refused" when i try to run the SSH session. I have tried 22/51773/1972 etc port settings under add/edit server to no avail. Any help is appreciated. Thanks.
From time to time, we get the previous question in support, something or someone is using more licenses than expected, and we need to find what.
We have two scenarios. The first scenario is when we realize that the licenses are exhausted when the application does not work or when we try to connect through the terminal and get the "lovely"
While converting FHIR JSON to SDA the file is being converted but, some of the data gets removed during conversion. Please help me out if you know the reason behind this.
We have created a utility to allow users to create a System task for a list of items the same way it’s done via SMP (attached below), the problem is that there may items and those systems tasks will grow a maybe exceed a couple of thousands so :
We have a solution with an EnsLib.EMail.InboundAdapter as services that scan a mailbox on incoming mail with attachments.
When a new email arrives, the service sends the request (with a property %Net.MailMessage) to the process. In the process, we try to loop through and retrieve part 2 which we assume is the file.
set Part = pRequest.Mail.Parts.GetAt (2)
We can read out the file name: Set FileName = Part.FileName
But how, and is it possible, to save the attached file to disk drive?
How to find out the number of active connections (including SQL, http, tcp and all remote connections) of an IRIS instance? A core based license is used.
I've checked the document and find %SYS.ProcessQuery.
I'm currently using this sql:
select count(distinct Pid) From %SYS.ProcessQuery where ClientIPAddress is not null and ClientIPAddress <> '127.0.0.1' and ClientIPAddress <> 'localhost' and IsGhost = '0'
I have a .woff2 file I'm trying to serve over CSP.
If I set: ^%SYS("CSP","DefaultFileCharset")="UTF8"
Then it "just works" - but I'd rather not do something so heavy-handed/instance-wide, on principle. (This is for something that will ultimately be published on the Open Exchange.)
By update
.png)
.png)
.png)
.png)